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...

Quick suggestion

😎

SELECT

SAC.object_id

,SAC.name

,SAC.column_id

,SAC.system_type_id

,SAC.user_type_id

,SAC.max_length

,SAC.precision

,SAC.scale

,SAC.collation_name

...

Add the count of each department as the rowspan to the first department cell of each department, easy with count and row_number over (partition by department)

😎

Quick though, count the null columns in each row and add the count to the colspan of the last cell.

😎

Must say that I agree with Jeff here, this seems to be very fragile and error prone, ie. what if two customers have the same name?

😎

The deduplication part is really...