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...

could be a number of issues

is sql browser running?

is the sql server running?

firewall blocking the TCP port

sql only set to accept local connections

Ah, yes it was, I didnt notice that.

MadTester (5/28/2012)

---

Been trying to solve this with a cursor on the initial query but I seem to be stuck in a loop adding the same record.

I am appealing since...

you have multiple process id and you can only link 1 row to 1 row, you cant link 1 row to many rows in a result set

CREATE TABLE #temp

(

Work_ID...