-
convert access query dateserial function into stored procedure
Hi,
Below is a access query which is using dateserial function.
can you please convert the below query into equivalent TSQL using function and calling that function into the stored procedure.
"select DateSerial([cy],IIf([mois_activity_plan]="Janvier",1,Null,1) from Table"
datatype for "cy" and "mois_activity_plan" are "text" in the table.
Dateserial function has the formatateserial(year,month,day)
please help.
Many thanks,
rakesh
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|