Guess the only think to do is to mix a salty soup cup and...

Quick question, are there frequent changes in the schema/tables? If not, you are better off using the import export wizard to create the packages and edit as needed. To dynamically...

I'm intrigued by this comment, could you elaborate further?

😎

happycat59 (9/30/2014)

---

As far as I am concerned, this is another dodgy question. The sample data includes 4 rows only. Personally, I read the suggested answer and treated the...

Thanks for the question Steve.

Misread the 1, 2, 3, 3, 4 as 1, 2, 3, 4 and of course ticked row_number:pinch: Off for making more industrial strength espresso

😎

TomThomson (9/30/2014)

---

Stewart "Arturius" Campbell (9/30/2014)

---

Randomness leads to unpredicatable outcomes, very much as depicted...

hakan.winther (9/30/2014)

---

Eirikur Eiriksson (9/30/2014)

---

Thank you for the question Amit.

Given options of 0,2 and 20 with the set's cardinality of 20 makes this kind of obvious; the granularity of syscolumns is...

Thank you for the question Amit.

Given options of 0,2 and 20 with the set's cardinality of 20 makes this kind of obvious; the granularity of syscolumns is {object,column}, one can...

djj (9/29/2014)

---

They hire me to be a DBA and then they do not take my suggestions.

I tell them they should only store a standardized value. A prime example of...

Sean Lange (9/29/2014)

---

The problem is these overpriced consultants are also full of overpriced crappy code. These are the people...

Quick suggestion for simplification

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @REPORT_MONTHS INT = 6;

DECLARE @NOW ...

Quick suggestion to get you started

😎

USE tempdb;

GO

SET NOCOUNT ON;

;WITH SAMPLE_DATA(Location,Building,RoomName,Habitant )AS

(SELECT * FROM (VALUES

('USA','White House','Oval Office','Mickey Mouse')

,('UK','Whitehall','24hour Lounce','Donald Duck')

) AS X(Location,Building,RoomName,Habitant)

)

SELECT

'group' AS '@type'

...

Thanks Steve for this question, it highlights the issue with RAND documentation, which ironically is more random in Books Online than the actual output of the function itself. Or as...

Not certain what you are asking for but I´ll throw in some explanation. Column names cannot be changed during the execution, changing the column name must then be an action...

Quick question, which SQL Server Version are you onÞ

😎