spaghettidba (3/21/2015)

---

TomThomson (3/20/2015)

---

spaghettidba (3/19/2015)

---

It has to be said that the Italian language doesn't help either: "the surgeon" translates to "il chirurgo", which is a masculine word to indicate the job,...

Just for fun here are two alternative methods, a single table scan solution without recursion and a dual self-join

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.TBL_DATE_SAMPLE') IS NULL

BEGIN

CREATE TABLE dbo.TBL_DATE_SAMPLE

(

...

Have you tried to add the Code Snippet Manager Command to the Tools menu?

😎

Edit: typo

Quick thought, there is...

A straight forward way of doing this is to calculate the running total on the first column, here is an example

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.TBL_SAMPLE_SHIFT') IS NOT NULL DROP TABLE...

Hi and welcome to the forum.

Not certain what you are after but this is my first interpretation

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.TBL_SAMPLE_DATA') IS NOT NULL DROP TABLE dbo.TBL_SAMPLE_DATA;

CREATE TABLE dbo.TBL_SAMPLE_DATA

(

...

patrickmcginnis59 10839 (3/19/2015)

---

Eirikur Eiriksson (3/17/2015)

---

First thought is that fixing the ageing OS/SQL Version should be...

Red

Quick thought, use either HASHBYTES or CHECKSUM

😎

WHERE CHECKSUM(@xml_old) = CHECKSUM(@xml_new)

Simmer

Classifying any person as inferior based on gender, race, religion, health, physical condition or any other irrelevant aspects or properties is both appalling and unprofessional. Under no circumstances should such...

Quick thought, do not ever ever ever judge the book by it's cover

😎

Hence...

Quick suggestion, start by browsing through Brent Ozar's posts/ebooks/posters[/url] on the subject

😎

bpowers (3/17/2015)

---

We are looking at upgrading our SQL Server 2008 SP4 Standard Edition instances to SQL Server 2012 SP1 Enterprise Edition. Has anyone experienced any issues doing such an upgrade?...