hunchback (5/23/2014)

---

The row_number function here is not deterministic, meaning the result could change even if it runs against the same data, because the ORDER BY clause is meaningless (ORDER BY...

The order is important and must be respected in the XML but in the result set it is not. Therefore, use the row_number function to assign the "order" when shredding...

Not certain what the problem is, testing your code with an addition of a row_number consistently brings back the results in the expected order.

😎

declare @Products xml = N'<BS>

<B Id="5" />

<B...

Without more information, the answer is it depends. What kind of queries, aggregation? How does the schema look like etc.

😎

Quick question, what has changes since the last successful attempt?

😎

Sean Lange (5/22/2014)

---

OK Now I get what you were saying. I just missed it because the portion of what you posted had no context to the whole dynamic sql issue....

I suggest you change from the + (addition) concatenation to the CONCAT function, it should implicitly cast the input to the appropriate character type if it does what says on...

First of all, sorry for my hurried and incomplete postings on the subject, the question is about parameter binding and sql injection, I recognise that this is slightly (read...

Good stuff!

😎

Sean Lange (5/22/2014)

---

Can you explain what this is doing? I don't get it. You say if the count is zero, don't run the code...but the code has already been executed....

Quick question, are you on SQL2008 SP1? If so, try OPTION ( OPTIMIZE FOR ( @xml = NULL ) ).

😎

ON DELETE CASCADE

😎

USE tempdb;

GO

CREATE TABLE dbo.TBL_PARENT

(

PARENT_ID INT IDENTITY(1,1)...

You can test the result set, if the count is 0 then don't execute the code, see the code!

😎

DECLARE @RES TABLE

(

is_hidden ...

Eric M Russell (5/21/2014)

---

I've seen fact tables in a star schema model with 20+ foreign keys. By default, foreign keys are not indexed, and nor should they generally speaking. Actually,...

Had a quick look at it again and discovered minor snags:-D

Firstly, this is not going to work for more than one customer at a time so I added a variable...