|
Get the sum of squares for each permutation
|
|
7
|
960
|
October 9, 2016
|
|
Transpose columns to rows
|
|
6
|
884
|
October 9, 2016
|
|
How to choose the event with the max id
|
|
8
|
980
|
October 9, 2016
|
|
How to create a store procedure for the script below to remove spaces in txt file with pipe delimited
|
|
3
|
598
|
October 8, 2016
|
|
SQL data base engine
|
|
7
|
833
|
October 8, 2016
|
|
IF Statement in Variable
|
|
4
|
532
|
October 6, 2016
|
|
Report needed weekly
|
|
1
|
397
|
October 6, 2016
|
|
Calculate min sum
|
|
9
|
894
|
October 6, 2016
|
|
Insert into an unknown table using select
|
|
16
|
2498
|
October 6, 2016
|
|
Duplicate Database Name in Sys.Master_Files
|
|
0
|
629
|
October 5, 2016
|
|
To calculate age and put age category
|
|
4
|
1126
|
October 5, 2016
|
|
Wildcard with like operator
|
|
7
|
718
|
October 5, 2016
|
|
Group according to time diff
|
|
7
|
910
|
October 4, 2016
|
|
Using Jenkins to deploy SQL code
|
|
6
|
6059
|
October 4, 2016
|
|
Query returned more than 1 value
|
|
5
|
550
|
October 4, 2016
|
|
SQL Stored Procedure to compare change in record
|
|
3
|
581
|
October 4, 2016
|
|
SQL on AWS
|
|
1
|
403
|
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
|
688
|
October 4, 2016
|
|
Can jobs be run with out SQL server agents?
|
|
5
|
1513
|
October 3, 2016
|
|
Conditional Join with multiple identifiers and lengths
|
|
4
|
820
|
October 3, 2016
|
|
Prevent 2 users from updating the record at the same time
|
|
2
|
525
|
October 3, 2016
|
|
SQL Queries
|
|
1
|
405
|
September 30, 2016
|
|
Last row of records sorted by date and grouped bu custid
|
|
2
|
477
|
September 30, 2016
|
|
Regrading transpose from rows to columns and indicator 0 and 1 and sum combinations
|
|
5
|
775
|
September 30, 2016
|
|
No lock on any tables but when doing re-indexing on transaction table again application works
|
|
4
|
577
|
September 30, 2016
|
|
T-SQL Query Help
|
|
2
|
342
|
September 29, 2016
|
|
Select query to show just 1 row with total count
|
|
4
|
459
|
September 29, 2016
|
|
Transposing data
|
|
1
|
371
|
September 29, 2016
|
|
Percentage in a group in sql
|
|
1
|
644
|
September 28, 2016
|
|
Record Selection
|
|
4
|
503
|
September 28, 2016
|