About the Transact-SQL category
|
|
0
|
2081
|
May 7, 2015
|
Get first datetime and last datetime on a single row
|
|
2
|
30
|
May 1, 2024
|
Help adding another case to subquery. I am trying to pull the bin label and warehouse but I am having trouble adding another case to subquery?
|
|
1
|
77
|
April 29, 2024
|
Separate values which are not delimited
|
|
5
|
79
|
April 29, 2024
|
U-SQL to T-SQL conversion
|
|
6
|
409
|
April 25, 2024
|
SQL Condition by user id
|
|
3
|
58
|
April 25, 2024
|
Count occurrences by time
|
|
2
|
91
|
April 24, 2024
|
Multiple Conditions in a CASE statement
|
|
1
|
504
|
October 24, 2016
|
How to set a variable from a table with comma?
|
|
2
|
99
|
April 18, 2024
|
Translate into easier query/more understandable
|
|
0
|
110
|
April 16, 2024
|
Hierarchy - need a tip
|
|
7
|
189
|
April 15, 2024
|
Sql trigger assign value to parameter
|
|
5
|
99
|
April 13, 2024
|
Could you please help me understand recursive queries in SQL? I have been stuck for one week trying to debug
|
|
1
|
91
|
April 12, 2024
|
Need help with the sql code - rolling 12 months count
|
|
2
|
102
|
April 12, 2024
|
How to Create A Stored Procedure from SQL Code
|
|
1
|
83
|
April 9, 2024
|
How to find relevant Data in tables
|
|
4
|
144
|
April 8, 2024
|
How to Modify Joins to Show Results in Fields
|
|
2
|
100
|
April 8, 2024
|
Pivot Item selling price according to Location code
|
|
0
|
83
|
April 8, 2024
|
[PostgreSQL] Can't calculate the column 'average_duration_per_turn' correctly in the query
|
|
0
|
89
|
April 7, 2024
|
Extracting string and inserting into another column in another table
|
|
14
|
118
|
April 5, 2024
|
USING LAG to obtain previous rows data
|
|
4
|
104
|
April 4, 2024
|
Opening And closing balance in for all Accounts
|
|
7
|
130
|
April 3, 2024
|
Unable to create database diagram
|
|
2
|
87
|
April 1, 2024
|
Create new columns based on min and max values of a record with multiple rows
|
|
9
|
127
|
March 28, 2024
|
SQL select Top 10 records for unique combination of two columns
|
|
8
|
113
|
March 27, 2024
|
ORA-01476: divisor is equal to zero
|
|
1
|
122
|
March 26, 2024
|
Picking only columns that has values
|
|
3
|
106
|
March 26, 2024
|
sUMMING MULTIPLE COLUMNS
|
|
2
|
146
|
March 25, 2024
|
How to use a part of a function as a column of a table
|
|
18
|
263
|
March 18, 2024
|
A SELECT statement that assigns a value to a variable must not be combined with data-retrieval operations
|
|
3
|
228
|
March 13, 2024
|