|
About the Transact-SQL category
|
|
0
|
1887
|
May 7, 2015
|
|
How to make many big inserts while preventing a lot of unused space
|
|
9
|
46
|
February 1, 2023
|
|
Getting records randomly one by one based on a certain criteria
|
|
4
|
13
|
February 1, 2023
|
|
Invoice Table Split date and calculate
|
|
8
|
31
|
February 1, 2023
|
|
How to create a rolling date search between two months
|
|
2
|
20
|
January 31, 2023
|
|
How to make a backup (.bak) file with desired physical / logical names
|
|
4
|
23
|
January 31, 2023
|
|
I want to take a database backup automatically and to zip the database automatically
|
|
35
|
17581
|
January 31, 2023
|
|
Sort alphanumeric values
|
|
10
|
83
|
January 30, 2023
|
|
Sub select based on the value of the sub select
|
|
3
|
51
|
January 30, 2023
|
|
How to put multiple printed rows in one line in sql?
|
|
3
|
70
|
January 30, 2023
|
|
Select Random Rows
|
|
7
|
49
|
January 29, 2023
|
|
How would you compare an excel with data in the database table?
|
|
19
|
102
|
January 29, 2023
|
|
Quick SQL Question
|
|
1
|
40
|
January 27, 2023
|
|
Calculate sections of time
|
|
3
|
32
|
January 27, 2023
|
|
Concat multiple columns in alphabetic order
|
|
3
|
24
|
January 27, 2023
|
|
Finding Integer in a string located in another table
|
|
8
|
39
|
January 26, 2023
|
|
SQL queries, select records with specific datatime occurrences (3 per week, 3 days in a row )
|
|
6
|
38
|
January 26, 2023
|
|
Assign user name to task on Round Robin approach
|
|
3
|
26
|
January 26, 2023
|
|
Total sur sql query
|
|
0
|
29
|
January 26, 2023
|
|
Presentation of results: multiple lines presented into concatenated values
|
|
1
|
28
|
January 25, 2023
|
|
How to encrypt column in sql server 2008r2
|
|
6
|
42
|
January 24, 2023
|
|
SQL - percentage from total
|
|
7
|
115
|
January 22, 2023
|
|
First entry is break out second entry is break in
|
|
5
|
35
|
January 23, 2023
|
|
TSQL - Assign same value to every line where condition is met for one line using case logic
|
|
2
|
47
|
January 23, 2023
|
|
Creating a back up with date attached to it
|
|
6
|
61
|
January 20, 2023
|
|
Extracting time stamp data from a combined column with log information
|
|
11
|
78
|
January 20, 2023
|
|
Differing results on similiar queries
|
|
6
|
60
|
January 19, 2023
|
|
Stored Procedure Execution - Takes much more time in One Server comparing another Server
|
|
1
|
40
|
January 19, 2023
|
|
How to select first distinct rows sequentially?
|
|
5
|
40
|
January 18, 2023
|
|
Including Additional Table Count in Existing Process
|
|
1
|
548
|
January 17, 2023
|