I was thinking the other day that maybe we could use a persisted computed column for something like the Modified date. If I set the column "Modified_date" as a persisted...

Here's a quick example of the differences of the different datatypes. Note that to insert the time into the datatypes that support time, you have to prefix your MM:SS with...

Rick Osgood-429286 (6/23/2010)

---

I am cleaning up a number of stored procedures and have come accross quite a few with the following operators:

WHILE @@fetch_status != -1

So, two questions:

1) What is the...

Oleg, thanks for the explanation. Hugo, thanks for the links, especially for the data type precedence. Between the two of you'll, this is the explanation that the question should have...

Maybe what is needed is to utilize a method that will allow you to programatically test all the permetations of a procedure. By saving this test, you will be able...

I'd be interested in this also. I have a database that was kept in sql 2000 compatability mode, but I'd like to find out what needs to be modified so...

You know, the people that help out here are all un-paid volunteers. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables affected, and INSERT statements to put...

Lynn,

I appreciate your trying to explain the soccer rules to those of us not as directly involved as you are. You've helped me to understand it somewhat better, though I...

You know, the people that help out here are all un-paid volunteers. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables affected, and INSERT statements to put...

danny09 (6/21/2010)

---

Hi wayne,

Thanks for pointing about the indexes.. i do have indexing on the table. i tested your SQL and i see that it results the same inserted data...

Danny, I'm agreeing with Dan here. If you take the below code, you...

You can first strip the time from the date you are working with.

This works for me:

declare @mydate datetime

set @mydate = GETDATE()

SELECT DateAdd(day, -1, DATEADD(week, DATEDIFF(week,0,DATEADD(day, DateDiff(day,0,@mydate), 0)), 0))

Interesting issue. Too...

DateDiff is counting the # of boundaries crossed. In the "datepart Boundaries" section, it implies that...

Dan,

Good job, and thanks for posting the data in a readily consumable format.

Edit: deleted code... didn't do the job.

Yes, that he is!

The TVF function with cross apply works like lightning

I have never seen cross...