Michael L John (7/5/2016)

---

Can anyone in the U.K. (or is it K minus U these days?) make a recommendation for technical training? We have a colleague in London who's...

Quick thoughts Thomas, do not use a while loop as there is no need for it and neither a table variable which will only introduce extra pressure on the tempdb.

😎

Here...

Have a look at Brent's excellent post on the subject[/url]

😎

Spam, spam and again spam 🙁 Why on earth is it so hard to tackle this problem on sqlservercentral.com???

😎

BWFC (7/1/2016)

---

Eirikur Eiriksson (7/1/2016)

---

Brandie,...

Brandie Tarvin (7/2/2016)

---

BWFC (7/1/2016)

---

Eirikur Eiriksson (7/1/2016)

---

Brandie Tarvin (7/1/2016)

---

Oh dear. I knew things were getting tense in Asia, especially between China and Taiwain, but this?

Oh dear. I hope they talk it...

Brandie, you are part...

Here is...

This quick suggestion should get you started

😎

USE tempdb;

SET NOCOUNT ON;

;WITH SAMPLE_DATA(PrintedDate,PrintedBy,DocumentPreparedBy,Name,UserName,Remarks,IPAddress,DateCreated,AppID,AppVersion,LastLoggedin) AS

(SELECT * FROM

(VALUES

(

CONVERT(DATE,'20010123',112)

...

You are very welcome.

😎

Quick suggestion

😎

Declare @Message xml

Declare @Proc xml

Declare @customer XML

Declare @product xml

set @Message = '<Message>

<Procedure>sp_testProc</Procedure>

<Customer>

<row>

...

Football

Hi Xedni,

you are very welcome. I do see one problem with your code and that is that all subsets of the same size will be identical (duplicates), is this what...

Jeff Moden (6/27/2016)

---

Nice code, as always, Eirikur, but I'm curious why you would help someone do something that you agree they should not do. :blink: I hope the company...

Jeff Moden (6/27/2016)

---

With or without...