This is a great solution, linked list idea adds complexity though. You can easily change the way you rank your songs and make Position column as float. Then you assign...

ChrisM@Work (9/9/2013)

natalie.ignatieva (9/9/2013)

Jeff Moden (9/8/2013)

I, however, do not consider the fact that it won’t give you an error for an attempted multiple-update on a single row a fault. Nay....

paul.knibbs (9/9/2013)

I would say it's entirely possible for it to be both. Yes, it's a...

Jeff Moden (9/8/2013)

I, however, do not consider the fact that it won’t give you an error for an attempted multiple-update on a single row a fault. Nay. I...

I am not exactly sure what you do in your code, but if you want to pull results as

TR001 555.55

TR002 123.55

TR003 34.00

..

TR008 23.76

THEN use

SELECT Tbl_Transaction.int_TransCode, SUM(Flt_Amount) AS Amount

FROM Tbl_Transaction...

Sorry, I forgot to close brackets:

You probably could run something like:

SELECT SUM(

CASE

WHEN Tbl_Transaction.int_TransCode = 'TR001' THEN Tbl_Transaction.Flt_Amount

WHEN Tbl_Transaction.int_TransCode = 'TR002' THEN Tbl_Transaction.Flt_Amount

(..etc)

WHEN Tbl_Transaction.int_TransCode = 'TR008' AND (some...

You probably could run something like:

SELECT SUM(

CASE

WHEN Tbl_Transaction.int_TransCode = 'TR001' THEN Tbl_Transaction.Flt_Amount

WHEN Tbl_Transaction.int_TransCode = 'TR002' THEN...

The color coding is actually correct. The first [ character starts a table name that only ends at the final ], so everything in between them is part of the...

Great question, thank you!

Management studio shows me this script mostly in black meaning there is something wrong in the script even if it's completed successfully. I guess even colorblind people can see it....

Please, try this code and let me know if it works faster for you:

SELECT MAX(RecordId) AS RecordId

INTO #T

FROM dbo.AllRecordsAS s2

GROUP BY SubrecordId

INSERT INTO #Temptable

(s1.SubrecordId,

s1.RecordId)

SELECT s1.SubrecordId, s1.RecordId...

A while ago there was one question with not intended mistake in the script and I lost points. Now I thought that this was just not intended mistake and lost...

Good question!! Thank you.

The correct answer is "XML segment, with the integrated parser marking most values illegal, but IE can open this segment surrounded by root element ", but my IE gives me...

I want my point 🙂