Grant Fritchey (6/5/2014)

---

Please, please, please, bestester behavior, no piling on of any kind (or I'll delete the posts and I can do that, BWA-HA-HA-HA, THE POWER!, ahem, where was I),...

Here is the problem, we can't see what you see unless you show us. Without knowing what it is you are trying to accomplish about all we can do...

Maybe not. If you show us what it is you are trying to do instead of hiding it behind obfuscated...

TomThomson (6/3/2014)

---

patrickmcginnis59 10839 (6/3/2014)

---

Rudyx - the Doctor (6/3/2014)

---

A great list discussion - my 3 cents:

- table variables need to be depracated with extreme prejudice

- SSMS generated code (IMAX...

Sean Lange (6/3/2014)

---

Rudyx - the Doctor (6/3/2014)

---

What is wrong with table variables ?

hmmm ...

table variables are not capable of having indexes (however they support constraints and primary keys)

no indexes mean:

...

Eirikur Eiriksson (5/30/2014)

---

Since this is a 2012 thread, how about the window functions?

😎

create table #sampledata

(

userId int,

BaseYear int,

TotalSales...

Koen Verbeeck (6/2/2014)

---

Lynn Pettis (6/2/2014)

---

Looks like a Cartesian product to me as well.

Looks like someone was writing the query using the ANSI-89 joins but forgot the WHERE clause to properly...

Looks like a Cartesian product to me as well.

Looks like someone was writing the query using the ANSI-89 joins but forgot the WHERE clause to properly restrict the result set.

Yes, I have read about that sort of thing in the EU in general. But from...

TheSQLGuru (6/2/2014)

---

I call "daughter distraction" on that one Lynn! 🙂 Actually I have seen, and used myself often, int dates stored as CCYYMMDD in data warehouses. I think...

Between NOLOCK and no gaps in invoice numbers how much more fun can we have??

And you complexity to the process that really isn't necessary.

Also, since it is looking like you are using SQL Server 2008 or later there are better alternatives to allowing dirty reads. One of the biggest reasons people add...

vinpes (6/2/2014)

---

Hi Lynn,

I considered this option, but it could be other problem of concurrency.

Imagine I have two record of with invoice Nr not completed, ie

InvoiceID flagcompleted

1 ...

Why are you allowing the use of NOLCK hints? You are aware of the potential data issues that can occur from using dirty reads, aren't you?