Could you not use the generate scripts function in ssms.

It's somewhere on the database when you right click it, can also get it to script out the data and should...

Just use due date > getdate() and due date <= the first expression in my last post

--To get 23:59:59 of the current day

SELECT CONVERT(DATETIME,LEFT(CONVERT(NVARCHAR,GETDATE(),120),10)+' 23:59:59.997')

--To get 00:00:00 of the next day

SELECT CONVERT(DATETIME,LEFT(CONVERT(NVARCHAR,GETDATE()+1,120),10)+' 00:00:00.000')

--To get 23:59:59 of the next day

SELECT CONVERT(DATETIME,LEFT(CONVERT(NVARCHAR,GETDATE()+1,120),10)+' 23:59:59.997')

That will do what you need,...

DOH, my bad, forgot I was in the 2005 Forum,...

Why do you need to change from DATE to DATETIME?

SQLDBA360 (5/28/2012)

---

anthony.green (5/25/2012)

---

Bill and Ben the flower...

cursors have their place when you need to do RBAR but if you can go for set based executions.

now depending on what your cursor is doing will depend on if...

Ok, lets start again

For the current day you want

DueDate > GETDATE() AND DueDate < CONVERT(DATE,DATEADD(DAY,1,GETDATE())) --DueDate > '2012-05-28 15:12:00.000' AND DueDate < '2012-05-29'

For tomorrow (if you just want...

yes, like Andy said, you need to add in a row_number clause to your select, wrap it all in a cte, then have 2 variables, set 1 as the lower...

It all depends on what your doing with the processing and if the whole table needs to be processed at the same time or if they can be processed in...

For tomorrow

To see...

Can you post us some more sample data with varing dates, then give us a date and time...

declare a variable and set it to the variable + @@rowcount on each itteration

declare @rc bigint = 0

set @rc = @rc + @@rowcount

Sachin 80451 (5/28/2012)

---

I have a load of records in a table. Each with a duedate. The duedate is a datetime field.

I want to get todays records. Past the current...

Yeah, I'm out of the books now, everything is away, only thing i can see on my desk is my flash cards, but as I have spend all morning crossing...