In my books, having to use recursive CTEs qualifies as worst case scenario, do explore the...

eligiable (5/4/2014)

---

It's just the SignedByUserID, that for Bilal Mateen does not exists in tblMer_Outlet, so we can change it to B.UserID from tblGen_Users, both are the same, but that not...

What ever happened to Baby Jane, oops, sorry, Bilal Mateen's ID?

😎

Throwing in my nickles worth, first on the operation side; draw up your worst case scenarios, then think of few ways to make them even worse, how you would tackle...

I've just used this link and ran the download, works like a charm

😎

How about 2008 - 2014 versions:cool:

SELECT create_date AS INSTALL_DATE

FROM sys.server_principals

WHERE name = 'NT AUTHORITY\SYSTEM';

I would recommend using the ANSI standard information_schema

😎

/* Using ANSI standard information_schema */

IF EXISTS (SELECT * FROM tempdb.INFORMATION_SCHEMA.TABLES

...

Quite few ways of doing this, here is one

😎

DECLARE @XML_STUFF TABLE

(

XML_ID INT IDENTITY(1,1) PRIMARY KEY CLUSTERED NOT NULL

,XML_DATA...

The problem is in the data, each node can only have one parent!

😎

Quite few ways of doing this, in essence create a set of all customers/months and then do the count.

The server normally translates queries such as "select * from A left...

It is more of a preference, kind of a reminder...

Firstly, thank you all for looking into this. It was me after all missing something rather obvious, maybe too obvious. The CTE in the code generates a sequence of 10^8...

First thought would be a VPN implementation, encrypts the point to point communication

😎

Ooops, the lights are on but no one's at home 😛

[mental...

A little trick with SIGN and the OVER clause makes this a simple query

😎

USE AdventureWorks2012;

GO

;WITH MULTI_COUNTING AS

(

SELECT /* Sum the row numbers, gives distinct count */

...