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

Brandie Tarvin (6/17/2016)

---

I knew I was conflating Whole Numbers and Integers somewhat, so I went and looked it up. Then my mind got blown.

ZERO IS NOT A RATIONAL NUMBER!

Further proof...

Chitown (6/9/2016)

---

All, wondering if I can get some help? I am trying to find a script which can help me accomplish this task. I am trying to have a scheduled...

Perfectly valid (it seems) exercise in politics 😀

😎

Matt Miller (#4) (6/9/2016)

---

I will say that ROW_NUMBER() is a dangerous tool to use when trying to deduplicate data. It's dangerous in that unless the ORDER BY you provide can...