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Þ

😎

Edit: not working.

An alternative window function based solution

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @CHANGE_TYPE VARCHAR(50) = 'Change1';

;WITH SAMPLE_DATA(CustomerID,ChangeType,OldValue,NewValue,TimeStamp) AS

( SELECT CustomerID,ChangeType,OldValue,NewValue,CONVERT(SMALLDATETIME,TimeStamp,0) FROM

(VALUES

...

Post the full and complete code you are running, including source definition, source query, insert statement and the destination table definition. Don't leave anything out!

😎

The change is simple, the sequence needs to be shifted so it starts counting at zero instead of one as otherwise it counts the night when it ends not when...

Thank you for the question Iulian. Fortunately we have come a long way from default sa accounts with no password, rpc wide open, early WebDav and other such horrors, still...

Straigt from the source;-)

😎

Quick though, use the object_definition function, that is the same as the system views use. Don't recall that I changed any settings on the system I'm using, brings back everything...

My 2 Cents: The SQL Server database platform is probably the most mature product Microsoft offers, some of the other components of the sQL Server Stack are less so. It...

That is straight...