i am getting this error : [Microsoft][SQL Native Client][SQL Server]Conversion failed when converting datetime from character string.

i place 'set @Account_date = convert(datetime,'yyyy-mm-ddThh:mm:ss.mmm',126)'

that i know,i want the exact format

hi

i used like this in #prompt('parm1','datetime')# in cognos framework.but it gives me error like parm 1 is not found in stored procedure.

if i use #prompt('parm1 ','ndatetime') then it gives...

my problem is in sql stored procedure i have datetime ,but in cognos framework it givesme error like expected framework is CCYY-MM-DD T hh:mm:ss.even i cast it to varchar in...

what i tried to install this,it just gives me 3 option ,modify,repair and remove,does i install right one

i do have local admin rights,can i add manually sql server native client 2008

ok.under ODBCINST.INI, i cannot see entry for sql 2008 native client

but where to see registry entries in PC

but that driver doesnt show under driver tab in odbc source .How can i create new data source without it

hi

this file is exist in system32,i dont have any error.however in the administrator tools ,its writte to install new driver ,use driver's set up program.what does that mean??

i installed from the same site ,you posted .and its successfully,but it doesnt show under odbc data source driver

ok. i created 2 temp table and join with the third one to get my total .thanks everybody for your help

Thanks everybody for response, there was some error in table. i got fix that

hi

this is my sample script.plz get me solution

CREATE PROCEDURE abc

( ...

this function is the only my problem,nothing else