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

What are you using to do the export?  If you are using BCP and use \" to enclose text fields in quotes in the format file, you should have no...

Adam is correct... basically, there is no way to store just the Month and Year in a datetime field.  In fact, you cannot store a "formatted" date in a datetime...

BCP... read all about it in Books-on-Line then post back.  I'll be happy to help once you are familiar with the terms and capabilities.

>The problem is that you have no idea what your are doing.

Apparently, Joe, you don't either because you provided no help to solve the problem... only caustic criticism on a...

Yes, there is, kind of, but I don't know if it will work with a cursor (I avoid cursors) and it uses a temp table (no so bad if proper...

Yeah, you're right Frank... Not enough coffee