CELKO (11/6/2012)

---

Where is your DDL? Why did you think you did not have to follow minimal Netiquette? You do not know that rows are not records!

I want...

As noted, it can also be done with dynamic SQL.

DECLARE @TableName VARCHAR(100) = 'Hist'

,@SQL NVARCHAR(MAX)

;WITH CountCols AS (

SELECT name, MySQL=' UNION ALL...

You probably only needed to add the COLLATE to the 1st and/or 4th parameters to STUFF.

komal145 (11/6/2012)

---

Hi friends

How to Exclude Records using join . I usually do not in

Example: I have a Table A and Table B

I want to exclude all the loans...

goenka.vishal (11/6/2012)

---

SL_NUMVENDOR_CODEVENDOR_DESC PO_NORATEORD_QTYRECV_QTYCR_DATE

1 38 MEENA ENTERPRISES ...

Brandie Tarvin (11/6/2012)

---

For my next SQL Saturdays blog post, I'm coming up with a list of acronyms & definitions for accidental / rookie DBAs.

Anyone have any suggestions for me to...

Can you provide some sample data in a readily consumable form and expected results?

I agree with Sean on the dangers and issues with this. But if you must you must.

To get around the sorting issue he notes, there is always this:

;with cte...

Dave Ballantyne (11/6/2012)

---

Hi,

I would be careful about making any form of 'X is faster than Y' statements , ever!

In this case i have found ,annecdotally, that PIVOT has a relatively...

Levelling the playing field by adding OPTION (MAXDOP 1) to the crosstab queries (including an additional one of my own design), I got these results:

Method ...

CH,

Interesting test so I tried to reproduce your results. I used just 4 passes instead of the 10 in your loop and got this:

Method ...

Jeff Moden (11/4/2012)

---

Dwain,

Add 10 to each SNo and see if it still works.

You're on the right track though. Just a small change will do it.

SELECT SNo = MIN(SNo)

...

I've solved it before. In my case I was running SQL Server 2008 R2 64 bit and 32...

qrius (11/4/2012)

---

Hi, am trying to pass 'Orange,Guava' argurment to this stored Proc. dbo.TESCOS table has two columns, Fruit varchar(100) and Price int. I keep getting errors >> Msg 207, Level...

imex (11/4/2012)

---

Hi,

Try:

select

a.SNo,

a.Date,

a.Cat as Cat_A,

a.Value as Value_A,

b.Cat as Cat_B,

...