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

panneermca35 (6/27/2016)

---

Hi All,

I want to generate the HTML with rowspan and colspan using sql query.

I can create HTML table but unable to give rowspan to TD tags.

Please give me the...

TomThomson (6/25/2016)

---

BWFC (6/24/2016)

---

My wife was born in Edinburgh and we'll be legging it up the M6 as fast as we can with her passport stuck to the inside of the...

Jeff Moden (6/25/2016)

---

I got this right "just" by deduction (I don't use or work with XML) but, my word, let's add to the list of reasons why I hate XML,...

Here two fairly simple set based solutions based on the same logic. The first is pretty fast generating smaller sets and doesn't use a temporary table, the second one uses...

ChrisM@Work (6/24/2016)

---

jasona.work (6/24/2016)

---

ChrisM@Work (6/24/2016)

---

Eirikur Eiriksson (6/24/2016)

---

Luis Cazares (6/24/2016)

---

I'm sorry, is there any country that can give me good news? It seems that Mexico, US and UK are full of negative...

jasona.work (6/24/2016)

---

ChrisM@Work (6/24/2016)

---

Eirikur Eiriksson (6/24/2016)

---

Luis Cazares (6/24/2016)

---

I'm sorry, is there any country that can give me good news? It seems that Mexico, US and UK are full of negative news...

Luis Cazares (6/24/2016)

---

I'm sorry, is there any country that can give me good news? It seems that Mexico, US and UK are full of negative news and I'm getting grumpy...

Here is a prime number snippet I wrote a while ago, should help you getting started.

😎

USE tempdb;

GO

SET NOCOUNT ON;

--DECLARE @INT_BUCKET_01 INT = 0;

DECLARE @NUMBER INT = 1000000;

;WITH...

Nice piece and very good work Alan!

😎

kangarolf (6/22/2016)

---

Hi all,

I have created maintenance plans and scheduled them to backup the transaction log every hour and make full backups everyday.

When I got to restore a database (testing the...

mw112009 (6/17/2016)

---

Select top 1 GEOG FROM PharmacyProviders

( I copied the value from screen and pasted below )

0xE6100000010C85EB51B81E254540AE47E17A144E55C0

Then .....

create table delta( GEOG geography );

INSERT INTO delta(...