Thanks for that. And yes I'm...

Over the years I have isolated xp_cmdshell, xp_sendmail etc from users and 3rd Party applications by using a stored procedure in front of the system procs. All inputs are checked...

A simple and quick way to archive data.

-- Simple table to populate with data

CREATE TABLE [dbo].[Current MPANs]( [MPAN] [char](13) NOT NULL PRIMARY KEY )

CREATE TABLE [dbo].[Old MPANs] ([MPAN] [char](13)...

I know of one place that does backup to the USB drive, yet they have 2 SANs?!

During a DR test the admin guys were too rushed to do a...

Throwing the 2 versions of the code through a test rig shows that the methods are reasonable similar on speed. Its how the methods get used is probable more...

Using the above sample from Cadavre to load the data here is an alternative. Admittedly you will need to prejudge the possible number of options and pad out the sql...

Did you want a null for no colours or a zero?

select[Main Category]

,[SubCategory]

,[SubCategory2]

,[SubCategory3]

,[Distinct Products] = COUNT(distinct [Product Name] )

,[Distinct Manufacturers] = COUNT (distinct [Manufacturer] )

--- Choose which answer

,[Distinct Colours]...

Tony, you may want to take the bugs out of the application first as in the long run it will cause less complex sql.

I think the answer you are looking...

Perhaps a bit late but a different solution in one statement 🙂

To set the data up based on the solution of http://www.sqlmag.com/article/tsql3/calculating-concurrent-sessions-part-3-103407:

USE tempdb;

IF OBJECT_ID('dbo.Sessions', 'U') IS NOT...