|
You have to know the DATE format waited by SQLserver.
Does the Accountid passes as you do without the doubles quotes ?
Stéphane.
Selon Raj <ramesh.chakri@GMAIL.COM>:
> how do u pass dates to a stored procedure?
> say with the following macro variables, I believe the dataofbirth
> stored just as text. If the stored procedure expects a date how to pass
> it?
>
> %let dateofbirth = 01Jan1968;
> %let AccountID = 333;
>
> create table debug1.sas_personInfo as select *
> from connection to oledb
> ( dbo.GetpersonInfo &dateofbirth &accountid );
>
> The above code doesnt work.!!
>
>
> thanks,
> Ram
>
| 
