Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Microsoft SQL Server > stored proc wit...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 3 Topic 11158 of 11517
Post > Topic >>

stored proc with datetime

by mcnewsxp <mcourter@[EMAIL PROTECTED] > Jun 19, 2008 at 11:55 AM

i need a little syntax help with a SP.
i have a datetime field that is part of the search criteria.
it may be null in which case it should be ingnored or get all dates.
if a date parameter is passed it should find it.

it only works for all when the arrivaldate is a varchar.
	@[EMAIL PROTECTED]
 varechar(10) = '%',

and only finds the matching date when
	@[EMAIL PROTECTED]
 smalldatetime,

?
 




 3 Posts in Topic:
stored proc with datetime
mcnewsxp <mcourter@[EM  2008-06-19 11:55:13 
Re: stored proc with datetime
"Plamen Ratchev"  2008-06-19 15:25:21 
Re: stored proc with datetime
mcnewsxp <mcourter@[EM  2008-06-19 13:56:21 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Wed Dec 3 1:15:35 CST 2008.