Perhaps this:

CREATE TABLE #temp (LogIndex int, UserID nvarchar (10), LogTime datetime)

set dateformat dmy;

insert into #temp select 1, '01551 ', '20/02/2013 17:41:45.000'

insert into #temp select 2, '01551 ', '20/02/2013 17:41:45.900'

insert into...

Would it be a dumb question to ask what version of SQL Server you are running?

AndrewSQLDBA (3/12/2013)

---

For one thing, I do not have a Tally table setup on the server in which I am working.

So, are there any other ways of doing this without a...

Not really understanding the problem. Daylight Savings Time (spring forward, fall back) is one of those times that DBA's need to be proactive to ensure that jobs run appropriately....

Does that particular database have an database snapshot currently defined? Just a guess here.

What software are you using that adds another column to your query?

Same could be said ot their CRM product as...

If you are wanting to keep data for five days, you may want to revisit your date test. Looks to me that you will only keep data from today.

SQL_Enthusiast (3/11/2013)

---

Thank you Lynn, that was exactly what I needed!

Since DATE was not recognized (Type DATE is not a defined system type.), I changed it to DATETIME and used CONVERT....

fmuzul (3/11/2013)

---

Lynn Pettis (3/11/2013)

---

In addition, if the underlying table structure changes but the output of the stored procedures remains the same, you isolate the changes to the database. You...

fmuzul (3/11/2013)

---

Gazareth (3/11/2013)

---

Well, I think you've got both ends of the argument there in the last couple of posts!

But what's with the paranoia over DBA's Francesco? We're not all bad...

Start here:

http://www.bing.com/search?q=virtual+DBA+services&go=&qs=n&form=QBLH&pq=virtual+dba+services&sc=0-13&sp=-1&sk=

In addition, if the underlying table structure changes but the output of the stored procedures remains the same, you isolate the changes to the database. You modify the stored...

Use the hyperlink...

Whatever it wants...