Fortunately, this is a non-issue. I have never had any sort of desire to engage in social networking, and quite honestly I shudder at the thought of it.

In my iopinion, pruning can be very advantageous when it comes to bringing new technical resources into your database.

Clutter = Distraction

Thanks Jeff,

I already have the link bookmarked for future reference. I look forward to having a bit more time to fully read through and possibly implement the techniques.

Regards,

Ryan Gillings

Jeff,

Thank you for posting your solution...I believe I will be able to gain much benefit from your posted running total logic.

I have received major performance/response time gains by replacing a cursor with a while loop in a similar fashion to what I posted.

Additionally, by using a variable table, there is...

I wouldn't feel right if I didn't offer a non-cursor alternative.

Below should work fine for your scenario, but you may need to tweak your ProductId datatype in the @temp table...

I would not completely rule out that it could be that your database(s) have outgrown your server hardware. SQL can be a bit of a memory hog if you...

Alternately, you can also use the DATEPART function instead of DATEDIFF:

DECLARE @Date DATETIME

SET @Date = GETDATE()

SELECT DATEADD(MONTH,1,DATEADD(DAY, (-1 * DATEPART(DAY,@Date)) + 1, @Date))

This may be posted already, but...

DECLARE @Date DATETIME

SET @Date = GETDATE()

SELECT CONVERT(VARCHAR,DATEPART(YEAR,@Date)) + CONVERT(VARCHAR,DATEPART(WEEK,@Date))

Well put!

"IT guy" seems to be a general term used by someone who doesn't really understand technology. I would compare it to a "Brain Surgeon" being called a "doctor", or...