Quick solution using aggregation to remove the null values

😎

USE tempdb;

GO

SET NOCOUNT ON;

;WITH SAMPLE_DATA(Advert,Network,Program) AS

( SELECT 'Acorn',NULL,NULL UNION ALL

SELECT NULL,'AC',NULL UNION ALL

SELECT NULL,NULL,'Adult'

)

SELECT

MAX(SD.Advert...

An alternative solution which doesn't require any joining. It scales well for large sets but has a weakness of returning false positives although fairly unlikely with this type of data....

Quick thought, sys.partitions is probably the best option as it does not require dynamic sql or depreciated backward compatibility objects.

😎

Ville-Pekka Vahteala (10/24/2014)

---

Koen Verbeeck (10/24/2014)

---

Nope, only 3 and that's apparently already...

Cadavre (10/24/2014)

---

Eirikur Eiriksson (10/23/2014)

---

Quick solution, should get you passed this hurdle

😎

; --terminator, not begininator 😛

WITH LAST_TABLE AS

(

SELECT TOP(1)

T.object_id

...

Koen Verbeeck (10/24/2014)

---

spaghettidba (10/23/2014)

---

Jack Corbett (10/23/2014)

---

spaghettidba (10/22/2014)

---

Stefan Krzywicki (10/22/2014)

---

Of course, regionalisms mean it could be called most anything.

For example: In most of the USA, a blended milk and...

There are quite few ways,...

Quick solution, should get you passed this hurdle

😎

;WITH LAST_TABLE AS

(

SELECT TOP(1)

T.object_id

,T.is_ms_shipped

...

Quick suggestion, search the sys.all_sql_modules definition

😎

SELECT

OBJECT_NAME(MO.object_id) AS OBJ_NAME

,OBJECT_SCHEMA_NAME(MO.object_id) AS OBJ_SCHEMA

,MO.definition

FROM sys.all_sql_modules MO

WHERE MO.object_id > 0

AND MO.definition LIKE '% TABLE...

Quick example of a simple method, normally does the job but strictly speaking it is reversible although it would require a hash-table approach.

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @SAMPLE_DATA TABLE

(

...

xsevensinzx (10/22/2014)

---

Jack Corbett (10/22/2014)

---

BWFC (10/22/2014)

---

We had 80 odd people at the show in September so a whole pig could well be worth it. I've just got to...

Out of curiosity, why would you want to do that?

😎

rodrigo.carrasco.e (10/21/2014)

---

I can not atachar database analysis services.

"the database can not be attached Because an error occurred while loading the log detach"

Any ideas, I have no backup. Please,...

Quick thought, many file formats have a signature or a magical number at the start of the file which is unique for that format. There are quit few resources available...

Luis Cazares (10/21/2014)

---

Eirikur Eiriksson (10/21/2014)

---

Ed Wagner (10/21/2014)

---

Luis Cazares (10/21/2014)

---

Eirikur Eiriksson (10/21/2014)

---

Ed Wagner (10/21/2014)

---

Eirikur Eiriksson (10/21/2014)

---

Luis Cazares (10/21/2014)

---

Eirikur Eiriksson (10/21/2014)

---

spaghettidba (10/21/2014)

---

Ed Wagner (10/21/2014)

---

Parma, Venice...these cities are making me think of authentic...