Ahhhhh.... you beat me to it Michael! I just remembered doing a function for one of our developers to list the parms in a stored proc.

I haven't worn a kilt since the last time I was in a wedding. It's a good feeling, and sporrans come in damn handy. ...

You might be right, but I think it's worth the risk. If you find it really does cause problems, then tell your developer that he has to do...

Think about this... the unused parameters do have a purpose. They are being used to save coding effort in the calling application.

I have lost my Zenlike tranquility and need to join Lynn for a walk in the desert.

Am I just being grumpy or does the OPs last...

I'll remember that the next time I take time off from MY job to help you out. 😉

Essentially he is saying: "I want you to do more work, so I don't have to do as much." You COULD provide him with a list...

This is definitely NOT the place to ask urgent questions. I've got a solution for you, but first I'd like to know why this is urgent.

I'm not asking you to show all of your data, but some sample temp tables with a few rows apiece would be nice. I'm working at...

Potso,

SELECT DISTINCT is just like a GROUP BY, only it doesn't require aggregation functions. It is redundant if you are using GROUP BY, and adds nothing to...

Sorry about that.

CTE stands for "Common Table Expression." You can look up more details in books online (the help function), but it is basically like...

The effectively places the records in the temp table in order of priority. This was necessary since an UPDATE statement cannot specify the order in which records should be updated....

You can use a CTE as the source for the update, like so.

declare @sampleSource table (rowid int identity(1,1),priority int) -- this would be your temp table

declare @sampleTarget table (rowID...

The effectively places the records in the temp table in order of priority. This was necessary since an UPDATE statement cannot specify the order in which records should be updated....

select convert(varchar(30),dateadd(month,datediff(month,0,getdate())-1,0),112) as FirstDayOfPreviousMonth,

convert(varchar(30),dateadd(day,-1,dateadd(month,datediff(month,0,getdate()),0)),112) as LastDayOfPreviousMonth

Just change getdate() to your date variable or column.

Here's how the last day previous month works.

The function datediff(month,0,getdate()) returns the number of...