troubleshooting Question

SQL DateAdd ????

Avatar of abennett10
abennett10 asked on
Microsoft SQL Server 2005
10 Comments2 Solutions484 ViewsLast Modified:
Hi guys!
Not sure if my problem needs DateAdd or not but here is my issue.
I need a stored procedure that will query the date field in a  table and
bring back a record for the current date, a record for the next day, and a record
for the day after that. According to the dates in the field.
Sounds a little confusing but see below.

And to make matters worse....the Shipdate datatype is varchar!
Sequence   ShipDate
--------- --------
3568597	12/22/2009
3570011	12/22/2009
3570482	12/23/2009
3570491	12/23/2009
50994	01/04/2010
51002	01/04/2010
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 2 Answers and 10 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 10 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros