About the Transact-SQL category
|
|
0
|
2058
|
May 7, 2015
|
Create new columns based on min and max values of a record with multiple rows
|
|
9
|
73
|
March 28, 2024
|
SQL select Top 10 records for unique combination of two columns
|
|
8
|
44
|
March 27, 2024
|
ORA-01476: divisor is equal to zero
|
|
1
|
50
|
March 26, 2024
|
Picking only columns that has values
|
|
3
|
80
|
March 26, 2024
|
sUMMING MULTIPLE COLUMNS
|
|
2
|
100
|
March 25, 2024
|
How to use a part of a function as a column of a table
|
|
18
|
238
|
March 18, 2024
|
A SELECT statement that assigns a value to a variable must not be combined with data-retrieval operations
|
|
3
|
128
|
March 13, 2024
|
No Records Returned When Parsing XML
|
|
2
|
94
|
March 13, 2024
|
Select Top 1 from a nested CTE
|
|
6
|
144
|
March 13, 2024
|
Need help with counting
|
|
1
|
103
|
March 12, 2024
|
SQL Insert not Inserting
|
|
1
|
98
|
March 11, 2024
|
Find mismatching rows
|
|
4
|
580
|
October 3, 2017
|
Updating columns based on row number
|
|
5
|
72
|
March 11, 2024
|
Delete dates
|
|
1
|
98
|
March 7, 2024
|
Remove trailing zeroes from the middle of a string
|
|
4
|
91
|
March 7, 2024
|
Reshape the long file to wide file
|
|
1
|
92
|
March 6, 2024
|
What is the reason / benefit of prefixing the creation of a table with # sign
|
|
3
|
83
|
March 5, 2024
|
Copying query results to an existing table
|
|
3
|
83
|
March 3, 2024
|
T SQL for closest dates
|
|
2
|
87
|
February 28, 2024
|
Wildcard In A Date Field?
|
|
2
|
107
|
February 28, 2024
|
Query performance date range
|
|
8
|
133
|
February 27, 2024
|
Problem with Inner Join
|
|
1
|
93
|
February 26, 2024
|
Framing out a stored procedure
|
|
3
|
135
|
February 26, 2024
|
Column type for case ... end value
|
|
2
|
125
|
February 26, 2024
|
Upload a CSV file to sql using a query
|
|
2
|
119
|
February 25, 2024
|
Inserting a default value for a datetimeoffset column from a json data field that has a null value
|
|
3
|
104
|
February 23, 2024
|
Problem with Inner Join
|
|
2
|
102
|
February 22, 2024
|
Help required in creating a function that produces output based on the configuration table
|
|
0
|
73
|
February 22, 2024
|
Concat LID with a Seq Sting and make all Seq String in one cell and for the unique LID
|
|
3
|
192
|
February 15, 2024
|