SQLPain (9/11/2015)

---

I ran the code again you gave, this time its giving me the following error.

Msg 195, Level 15, State 10, Line 3

'ROW_NUMBER' is not a recognized function name.

Msg 156,...

tt-615680 (9/12/2015)

---

Dear All,

I have a database which gets refreshed on the daily by restoring 1 transactional file log, at the moment it is done manually but I'm trying to create...

Alan.B (9/11/2015)

---

Thanks Eirikur, you always seen to have the answer. Very interesting stuff - I have never really played around any Undocumented Query Optimizer Trace Flags (I used to play...

Further on the topic, the input tree is generated during the parsing and binding phase. Since the query processor does not evaluate variable values during this stage, this step produces...

Alvin Ramard (9/11/2015)

---

Eirikur Eiriksson (9/11/2015)

---

Did try it briefly few years back, not bad but it didn't end up in the tool...

Did try it briefly few years back, not bad but it didn't end up in the tool chest, main reason being...

pronto

Mike Sofen-356112 (9/11/2015)

---

Eirikur Eiriksson (9/11/2015)

---

My 2 Cents, when working with large and often complex schema, cluttering a detail level ERD into a single diagram does neither make sense nor serve...

Hermetic

You are very welcome.

😎

The image posted does not help much, the only thing one can suggest from this is to add covering indexes to the...

Quick question, can you post the DDL (create table), sample data as an insert statement and the desired output?

😎

My 2 Cents, when working with large and often complex schema, cluttering a detail level ERD into a single diagram does neither make sense nor serve any purpose (apart from...

Have a look at Aaron Bertrand's article Script to create dynamic PIVOT queries in SQL Server[/url]

😎

Quick example

😎

USE tempdb;

GO

SET NOCOUNT ON;

/* XML snip to update, note added a ROOT element */

DECLARE @TXML XML = '<ROOT>

<Name>Assets - Reconciler</Name>

<UpdatedOn>2015-05-20T13:23:09.230</UpdatedOn>

<CreatedOn>2015-05-20T13:22:04.920</CreatedOn>

<UpdatedBy>RLG\JoeBloggs</UpdatedBy>

<CreatedBy>RLG\JoeBloggs</CreatedBy>

<InputDirectory>\\99.999.999.9\Active</InputDirectory>

<OutputDirectory>\\99.999.999.9\Archive</OutputDirectory>

<ErrorDirectory>\\99.999.999.9\Errors</ErrorDirectory>

<LoadId>0</LoadId>

<Type>ExcelFile</Type>

</ROOT>';

DECLARE @NEW_IP VARCHAR(15) = '123.456.789.012';

DECLARE @SAMPLE_TABLE TABLE

(

...