|
hi guys i'm here first time any advice would be appreciated.
insert into ##temp
values(convert(varchar,'select StartDate from JFTest11.dbo.FScalar',112),
null,null,null);
my question is this: i have one main table ,there is one startdate colom which is datetime type. i make one temp table i want to insert all start date value in temp table using above command. there is 4 lakhs record in main table. there is need some change in my query to get all data in temp table pls. when i'm running this command i got error message all time Msg 241, Level 16, State 1, Line 1 Conversion failed when converting datetime from character string. pls help me i,m helpless situation .it's very imp for my project. pls mail me on this id vikassharma_47@hotmail.com thanks vikas
(comments are locked)
|
|
It should be
(comments are locked)
|
|
Or possibly this:
insert into ##temp
SELECT convert(varchar,(select StartDate from JFTest11.dbo.FScalar),112),
null,null,null
This will give an error IF the nested select returns more than one row (which may be what you want :) )
(comments are locked)
|
