|
Transpose columns to rows
|
|
6
|
857
|
October 9, 2016
|
|
How to choose the event with the max id
|
|
8
|
969
|
October 9, 2016
|
|
How to create a store procedure for the script below to remove spaces in txt file with pipe delimited
|
|
3
|
588
|
October 8, 2016
|
|
SQL data base engine
|
|
7
|
791
|
October 8, 2016
|
|
IF Statement in Variable
|
|
4
|
525
|
October 6, 2016
|
|
Report needed weekly
|
|
1
|
392
|
October 6, 2016
|
|
Calculate min sum
|
|
9
|
883
|
October 6, 2016
|
|
Insert into an unknown table using select
|
|
16
|
2419
|
October 6, 2016
|
|
Duplicate Database Name in Sys.Master_Files
|
|
0
|
627
|
October 5, 2016
|
|
To calculate age and put age category
|
|
4
|
1062
|
October 5, 2016
|
|
Wildcard with like operator
|
|
7
|
706
|
October 5, 2016
|
|
Group according to time diff
|
|
7
|
883
|
October 4, 2016
|
|
Using Jenkins to deploy SQL code
|
|
6
|
6037
|
October 4, 2016
|
|
Query returned more than 1 value
|
|
5
|
540
|
October 4, 2016
|
|
SQL Stored Procedure to compare change in record
|
|
3
|
564
|
October 4, 2016
|
|
SQL on AWS
|
|
1
|
402
|
October 4, 2016
|
|
How to connect to SQL Server 2014 installed on one PC from a 2nd PC without Windows server and domain involved?
|
|
2
|
682
|
October 4, 2016
|
|
Can jobs be run with out SQL server agents?
|
|
5
|
1499
|
October 3, 2016
|
|
Conditional Join with multiple identifiers and lengths
|
|
4
|
807
|
October 3, 2016
|
|
Prevent 2 users from updating the record at the same time
|
|
2
|
520
|
October 3, 2016
|
|
SQL Queries
|
|
1
|
405
|
September 30, 2016
|
|
Last row of records sorted by date and grouped bu custid
|
|
2
|
462
|
September 30, 2016
|
|
Regrading transpose from rows to columns and indicator 0 and 1 and sum combinations
|
|
5
|
741
|
September 30, 2016
|
|
No lock on any tables but when doing re-indexing on transaction table again application works
|
|
4
|
575
|
September 30, 2016
|
|
T-SQL Query Help
|
|
2
|
341
|
September 29, 2016
|
|
Select query to show just 1 row with total count
|
|
4
|
451
|
September 29, 2016
|
|
Transposing data
|
|
1
|
366
|
September 29, 2016
|
|
Percentage in a group in sql
|
|
1
|
642
|
September 28, 2016
|
|
Record Selection
|
|
4
|
501
|
September 28, 2016
|
|
SQL trigger to execute a bat file whenever there is only new record get inserted
|
|
1
|
331
|
September 28, 2016
|