Thanks nskr72... I missed that.

You can avoid this...

IF (@FromDate = NULL)

SET @FromDate = '1/1/1900'

... by doing this... (just a bit faster, I think)

SET @FromDate...

> Do you think this may pose deadlock problems?  This should be the only stored procedure or even script for that matter that would ever access this table.

Fred,

Yeah, your method...

A third party company that we had the great misfortune of hiring, did something similar (nearly identical) in our database... it caused an average of 620 deadlocks a day.  The...

Not sure why you wouldn't want to use a set based Trigger for this... it's a tried and true method and will run raster than anything else you could throw...

>Will having 2 records for the one shift with 2 seperate ID's affect my Analyisis Services CUBES? 

Here's a bit of code where you will not have two records... most of...

Perhaps instead of a stored procedure, it should be a view so that you can select from it as if it were a table.  Also, take a look at OpenRowSet...

Dude?

Do you want to automatically delete the dupes (leaving only the earliest or the latest) or just find them?  Frank is correct... the search leads to lot's of "duplicate row" goodies...

You're welcome and thanks for the feed back.

We ran into a similar problem at work...

You have an IS NULL in the WHERE clause and while that is not in itself a problem, you've probably run into a...

I ran into a similar problem with a rather lengthy query and it became a real pain.  I originally used IF logic but it required that the same lengthy query...

Brian,

Really nice job on the "Stored Procedures and Caching" article.  Looks like a few other folks share my sentiment.  Definitely above the norm of what I've come to expect from...

If you format the "preview" table (also known as a "staging table") correctly, BCP will catch the kinds of errors you mentioned.  Dates should always go into a DateTime data-type column. ...

I had some very good luck using a CASE statement in a WHERE clause for just this purpose.  Try something like this...

CREATE PROCEDURE ListMyTable( @Op As Integer, @ParamValue...