|
|
-
Robert Dennyson Commented 4 Months ago through Ask
Hi Dilip,
You can try pivoting like this.
DECLARE @ordList VARCHAR(MAX);
SELECT @ordList = STUFF((SELECT ', [' + RTRIM(ordinal) + ']' AS [text()]
FROM (
SELECT DISTINCT CONVERT(VARCHAR,ordinal) ordinal FROM Ordinals
) ...
|
-
Robert Dennyson Posted 9 Months ago through Just Learned
Do you know ANSI-92 versions of T-SQL therefore early 6.5 version was so programmatically influenced. This was tha old-style LEFT OUTER JOIN syntax.
SELECT TableX.ID, TableY.ID
FROM TableX, TableY
WHERE TableX.ID *= TableY.ID
The ...
|
-
Robert Dennyson Posted 9 Months ago through Just Learned
Do you know ANSI-92 versions of T-SQL therefore early 6.5 version was so programmatically influenced. This was tha old-style LEFT OUTER JOIN syntax.
SELECT TableX.ID, TableY.ID
FROM TableX, TableY
WHERE TableX.ID *= TableY.ID
The ...
|
-
Robert Dennyson Posted 9 Months ago through Just Learned
Do you know ANSI-92 versions of T-SQL therefore early 6.5 version was so programmatically influenced. This was tha old-style LEFT OUTER JOIN syntax.
SELECT TableX.ID, TableY.ID
FROM TableX, TableY
WHERE TableX.ID *= TableY.ID
The ...
|
-
Robert Dennyson Posted 9 Months ago through Just Learned
Do you know ANSI-92 versions of T-SQL therefore early 6.5 version was so programmatically influenced. This was tha old-style LEFT OUTER JOIN syntax.
SELECT TableX.ID, TableY.ID
FROM TableX, TableY
WHERE TableX.ID *= TableY.ID
The ...
|
|
|
|
|
-
prince Question Received 9 Months ago through ASK
Kindly refer the below link, It is **T-Sql Server 2005** question. for adding dynamic columns in a temporary table. Here 2 temp tables are there as tabl1 and table2 and result is in "output table". here my rows are getting converted in columns. Using plain...
|
|
|
|
|