|
Get the sum of squares for each permutation
|
|
7
|
941
|
October 9, 2016
|
|
Transpose columns to rows
|
|
6
|
862
|
October 9, 2016
|
|
How to choose the event with the max id
|
|
8
|
977
|
October 9, 2016
|
|
How to create a store procedure for the script below to remove spaces in txt file with pipe delimited
|
|
3
|
594
|
October 8, 2016
|
|
SQL data base engine
|
|
7
|
802
|
October 8, 2016
|
|
IF Statement in Variable
|
|
4
|
529
|
October 6, 2016
|
|
Report needed weekly
|
|
1
|
396
|
October 6, 2016
|
|
Calculate min sum
|
|
9
|
891
|
October 6, 2016
|
|
Insert into an unknown table using select
|
|
16
|
2464
|
October 6, 2016
|
|
Duplicate Database Name in Sys.Master_Files
|
|
0
|
628
|
October 5, 2016
|
|
To calculate age and put age category
|
|
4
|
1103
|
October 5, 2016
|
|
Wildcard with like operator
|
|
7
|
716
|
October 5, 2016
|
|
Group according to time diff
|
|
7
|
883
|
October 4, 2016
|
|
Using Jenkins to deploy SQL code
|
|
6
|
6043
|
October 4, 2016
|
|
Query returned more than 1 value
|
|
5
|
548
|
October 4, 2016
|
|
SQL Stored Procedure to compare change in record
|
|
3
|
565
|
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
|
1504
|
October 3, 2016
|
|
Conditional Join with multiple identifiers and lengths
|
|
4
|
815
|
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
|
463
|
September 30, 2016
|
|
Regrading transpose from rows to columns and indicator 0 and 1 and sum combinations
|
|
5
|
752
|
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
|
457
|
September 29, 2016
|
|
Transposing data
|
|
1
|
370
|
September 29, 2016
|
|
Percentage in a group in sql
|
|
1
|
643
|
September 28, 2016
|
|
Record Selection
|
|
4
|
501
|
September 28, 2016
|