parthmeister (3/10/2013)

---

Hi Folks,

i am having the sql below:

SELECT TOP (100) SAMINC.dbo.OESTATS.YR as YEAR , SUM(SAMINC.dbo.OESTATS.SALESAMTF) AS TotalSales

FROM SAMINC.dbo.OESTATS INNER JOIN

dbo.Company ON SAMINC.dbo.OESTATS.LINVCUST = dbo.Company.Comp_IdCust COLLATE Latin1_General_BIN

GROUP BY SAMINC.dbo.OESTATS.YR

that generated the...

Rauf Miah (3/10/2013)

---

I like to insert SIRCODE in Sequence like x= x+1000

Then it look like

Comcod Sircode ...

...or, if you might want to keep the code and re-instate it later...

Add

AND 1=0

to the WHERE clause.

I don't like the look of hitting that xml over and over...

You might want to try something like this to get the data out into a tabular form, then work...

Sounds ominous :w00t:

I have only posted one item on Connect - it was related to a specific technology within Visual Studio 2012, it got no up votes from anyone, but was checked...

AndrewSQLDBA (3/1/2013)

---

Hello Everyone

I have a rather odd situation. I want to add a lock to a table on purpose. I need to update and then select from that table...

Yes, you can do it.

You need to make sure that your Dealer Name group is a Child Row Group of the Division group, then it's just formatting (like the indent).

Edit:...

I know what...

not directly, but you could store the results of

each proc into tables and intersect those,

ChrisM@Work (2/26/2013)

---

dwain.c (2/26/2013)

---

ChrisM@Work (2/26/2013)

---

peter-757102 (2/26/2013)

---

Using a binary comparisons is a good speedup for specific cases and good to be aware of and certainly worth mentioning in bold with its...

Usman Butt (2/22/2013)

---

L' Eomot Inversé (2/22/2013)

---

mister.magoo (2/22/2013)

---

What bothered me was that feeling that "someone should have thought of this ages ago, shouldn't they"?

Always makes me nervous when that is...

ErikEckhardt (2/22/2013)

---

COLLATE only needs to be on one side of the expression. Either side will do. You don't...

dwain.c (2/22/2013)

---

mister.magoo (2/22/2013)

---

ChrisM@Work (2/22/2013)

---

L' Eomot Inversé (2/22/2013)

---

mister.magoo (2/22/2013)

---

And here is the code (with notes removed for brevity) and the changes underlined.

Sorry if I have made a mistake, but I think...

ChrisM@Work (2/22/2013)

---

L' Eomot Inversé (2/22/2013)

---

mister.magoo (2/22/2013)

---

And here is the code (with notes removed for brevity) and the changes underlined.

Sorry if I have made a mistake, but I think this is...