|
IF Statement in Variable
|
|
4
|
525
|
October 6, 2016
|
|
Report needed weekly
|
|
1
|
388
|
October 6, 2016
|
|
Calculate min sum
|
|
9
|
872
|
October 6, 2016
|
|
Insert into an unknown table using select
|
|
16
|
2407
|
October 6, 2016
|
|
Duplicate Database Name in Sys.Master_Files
|
|
0
|
626
|
October 5, 2016
|
|
To calculate age and put age category
|
|
4
|
1006
|
October 5, 2016
|
|
Wildcard with like operator
|
|
7
|
700
|
October 5, 2016
|
|
Group according to time diff
|
|
7
|
879
|
October 4, 2016
|
|
Using Jenkins to deploy SQL code
|
|
6
|
6021
|
October 4, 2016
|
|
Query returned more than 1 value
|
|
5
|
536
|
October 4, 2016
|
|
SQL Stored Procedure to compare change in record
|
|
3
|
564
|
October 4, 2016
|
|
SQL on AWS
|
|
1
|
398
|
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
|
677
|
October 4, 2016
|
|
Can jobs be run with out SQL server agents?
|
|
5
|
1456
|
October 3, 2016
|
|
Conditional Join with multiple identifiers and lengths
|
|
4
|
805
|
October 3, 2016
|
|
Prevent 2 users from updating the record at the same time
|
|
2
|
516
|
October 3, 2016
|
|
SQL Queries
|
|
1
|
397
|
September 30, 2016
|
|
Last row of records sorted by date and grouped bu custid
|
|
2
|
461
|
September 30, 2016
|
|
Regrading transpose from rows to columns and indicator 0 and 1 and sum combinations
|
|
5
|
732
|
September 30, 2016
|
|
No lock on any tables but when doing re-indexing on transaction table again application works
|
|
4
|
572
|
September 30, 2016
|
|
T-SQL Query Help
|
|
2
|
338
|
September 29, 2016
|
|
Select query to show just 1 row with total count
|
|
4
|
451
|
September 29, 2016
|
|
Transposing data
|
|
1
|
360
|
September 29, 2016
|
|
Percentage in a group in sql
|
|
1
|
638
|
September 28, 2016
|
|
Record Selection
|
|
4
|
496
|
September 28, 2016
|
|
SQL trigger to execute a bat file whenever there is only new record get inserted
|
|
1
|
329
|
September 28, 2016
|
|
Doing re-indexing on transaction table again application works fine
|
|
1
|
530
|
September 28, 2016
|
|
Unpivot sql columns into rows
|
|
0
|
333
|
September 28, 2016
|
|
Temporary Table Memory Usage
|
|
6
|
3523
|
September 28, 2016
|
|
Inserting and then filling blanks between database records
|
|
17
|
1052
|
September 27, 2016
|