Make sure you understand what's going on in the...

Cadavre (1/20/2012)

---

I'm going to go and be a little different, because I always am 😀

Here's the query I'd use:

SELECT [name], [count]

FROM (SELECT

SUM(CASE...

I'm going to go and be a little different, because I always am 😀

Here's the query I'd use:

SELECT [name], [count]

FROM (SELECT

SUM(CASE WHEN...

Yes, the white space trailing your varchar wasn't a space - it was a tab or some other white space character instead.

e.g.

DECLARE @test-2 TABLE(testID INT IDENTITY, cct...

DECLARE @ColumnList NVARCHAR(MAX)

SELECT @ColumnList = COALESCE(@ColumnList, '') + ',' + CHAR(13) + CHAR(10) + CAST(COLUMN_NAME AS VARCHAR(128))

FROM INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_NAME = 'MY_TABLE'

ORDER BY ORDINAL_POSITION

IF LEN(@ColumnList) > 0

BEGIN

SELECT @ColumnList = STUFF(@ColumnList, 1,...

{fn length} is a Microsoft ODBC canonical function that is supposed to work the same with any data type.

GSquared (1/19/2012)

---

I must not have written clearly.

I'm not disagreeing with semicolons being...

I more meant that I include CR/LF, I didn't mean that I specifically wrote them as LF...

GSquared (1/18/2012)

---

Cadavre (1/18/2012)

---

Admittedly, the answer to that is "no".

However IMO, to avoid ambiguity, whether or not your method works is irrelevant....

Admittedly, the answer to that is "no".

However IMO, to avoid ambiguity, whether or not your method works is irrelevant. It...

Here's my guess: -

BEGIN TRAN

CREATE TABLE #yourSampleData (AssignmentID INT IDENTITY, QuestionID INT, StakeholderID INT)

INSERT INTO #yourSampleData

SELECT * FROM (VALUES(1, 10),(1, 9),(2, 10),(1, 2))a(QuestionID,StakeholderID)

--Set string and question number

DECLARE @string VARCHAR(4000) =...

Laurie-1124340 (1/18/2012)

---

The string contains ONLY the stakeholderids. There will be ONE QuestionID to update so that stays the same for all stakeholders.

QuestionID StakeholderID

1...

Wikipedia's black-out is javascript based. I didn't realise it was "blacked-out" until a colleague informed me - I block all web-based scripts from running on my machine so it was...

Check out Jeff Moden's splitter article for the best way to split your comma separated string --> http://www.sqlservercentral.com/articles/Tally+Table/72993/%5B/url%5D.

Once you've implemented that, you can split the strings into a data-set (temp...

Jeff Moden wrote an excellent article that does exactly what you need. Click this link --> http://www.sqlservercentral.com/articles/Tally+Table/72993/%5B/url%5D