Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pkandoth
Starting Member
2 Posts |
 Posted - 2004-10-21 : 11:11:47
|
| Hi I've a problem!!! i want to use datediff thats no problem. But the first parameter has tobe parameterised. What datatype do i declare it as. i declare it as varcharit returns me an error : Invalid parameter 1 specified for datediff. i'm doing this in a stored procedure.Is there a way out or do i've to use the good old 'IF' or 'Case' ?regardspradeep |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-10-21 : 11:39:34
|
| Duplciate of http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=41563 |
 |
|
|
|
|
|
datediff