|
About the Transact-SQL category
|
|
0
|
1823
|
May 7, 2015
|
|
First word of address field
|
|
11
|
41
|
August 9, 2022
|
|
Extract string between 2nd set of repeating characters
|
|
1
|
19
|
August 9, 2022
|
|
Why does this IIF not work
|
|
4
|
34
|
August 9, 2022
|
|
Optimizing query of large table based on ids in another large table
|
|
5
|
52
|
August 5, 2022
|
|
Change part of URLs
|
|
9
|
45
|
August 5, 2022
|
|
Time conversion?
|
|
5
|
44
|
August 5, 2022
|
|
Interval data
|
|
2
|
42
|
August 4, 2022
|
|
Local variable with more than 1 value
|
|
7
|
51
|
August 4, 2022
|
|
SQL query - join tables
|
|
6
|
44
|
August 3, 2022
|
|
Select single records
|
|
2
|
42
|
August 3, 2022
|
|
I can't append data to file excel file already exist using python sql server 2019
|
|
1
|
36
|
August 2, 2022
|
|
Split the invoice date as per startdatetime and enddatetime
|
|
1
|
43
|
August 2, 2022
|
|
Synchronizing data between two tables in a certain way
|
|
5
|
46
|
July 31, 2022
|
|
Adding calculation to case when operator
|
|
2
|
46
|
July 29, 2022
|
|
Need to rearrange order of names from a fullname column to LAST, SUFFIX, FIRST and accommodating for no suffix
|
|
2
|
37
|
July 29, 2022
|
|
SQL Transposing Rows to Columns
|
|
7
|
94
|
July 28, 2022
|
|
Insert into and update stock in second table
|
|
1
|
34
|
July 28, 2022
|
|
XML and SQL Query Unable to Get This!
|
|
5
|
66
|
July 26, 2022
|
|
How to avoid using string aggreagte for give unique numbers for every group of numbers?
|
|
5
|
52
|
July 25, 2022
|
|
How to iterate on a SELECT statement?
|
|
6
|
54
|
July 25, 2022
|
|
Query for listing rolls of students who got >50(greater than 50) in either mathematics or computer table
|
|
7
|
46
|
July 24, 2022
|
|
Need Sql Query
|
|
4
|
61
|
July 22, 2022
|
|
Check the date using GETDATE function
|
|
1
|
31
|
July 22, 2022
|
|
Insert using Recursive
|
|
3
|
48
|
July 22, 2022
|
|
Query Syntax Help Group By Join
|
|
4
|
30
|
July 21, 2022
|
|
Help with SQL query - TSQL
|
|
3
|
61
|
July 21, 2022
|
|
Split single row into multiple rows based on 2 Date and time constraint in SQL Server
|
|
0
|
46
|
July 21, 2022
|
|
Compare the records from the recent Monday to the immediate last Monday and flag as old or new
|
|
3
|
37
|
July 20, 2022
|
|
ELSE LAG logic help!
|
|
0
|
46
|
July 19, 2022
|
