About the Transact-SQL category
|
|
0
|
2082
|
May 7, 2015
|
Get the min start and max end when the datetime overlap is more than 1 day
|
|
6
|
30
|
May 3, 2024
|
CASE Statement to Categorize Data Request
|
|
2
|
23
|
May 2, 2024
|
Get first datetime and last datetime on a single row
|
|
2
|
35
|
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
|
103
|
April 29, 2024
|
Separate values which are not delimited
|
|
5
|
82
|
April 29, 2024
|
U-SQL to T-SQL conversion
|
|
6
|
413
|
April 25, 2024
|
SQL Condition by user id
|
|
3
|
59
|
April 25, 2024
|
Count occurrences by time
|
|
2
|
93
|
April 24, 2024
|
Multiple Conditions in a CASE statement
|
|
1
|
506
|
October 24, 2016
|
How to set a variable from a table with comma?
|
|
2
|
100
|
April 18, 2024
|
Translate into easier query/more understandable
|
|
0
|
112
|
April 16, 2024
|
Hierarchy - need a tip
|
|
7
|
190
|
April 15, 2024
|
Sql trigger assign value to parameter
|
|
5
|
109
|
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
|
104
|
April 12, 2024
|
How to Create A Stored Procedure from SQL Code
|
|
1
|
84
|
April 9, 2024
|
How to find relevant Data in tables
|
|
4
|
146
|
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
|
120
|
April 5, 2024
|
USING LAG to obtain previous rows data
|
|
4
|
106
|
April 4, 2024
|
Opening And closing balance in for all Accounts
|
|
7
|
130
|
April 3, 2024
|
Unable to create database diagram
|
|
2
|
88
|
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
|
127
|
March 26, 2024
|
Picking only columns that has values
|
|
3
|
107
|
March 26, 2024
|
sUMMING MULTIPLE COLUMNS
|
|
2
|
147
|
March 25, 2024
|