|
To calculate age and put age category
|
|
4
|
986
|
October 5, 2016
|
|
Wildcard with like operator
|
|
7
|
699
|
October 5, 2016
|
|
Group according to time diff
|
|
7
|
877
|
October 4, 2016
|
|
Using Jenkins to deploy SQL code
|
|
6
|
6011
|
October 4, 2016
|
|
Query returned more than 1 value
|
|
5
|
534
|
October 4, 2016
|
|
SQL Stored Procedure to compare change in record
|
|
3
|
563
|
October 4, 2016
|
|
SQL on AWS
|
|
1
|
395
|
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
|
662
|
October 4, 2016
|
|
Can jobs be run with out SQL server agents?
|
|
5
|
1424
|
October 3, 2016
|
|
Conditional Join with multiple identifiers and lengths
|
|
4
|
803
|
October 3, 2016
|
|
Prevent 2 users from updating the record at the same time
|
|
2
|
510
|
October 3, 2016
|
|
SQL Queries
|
|
1
|
389
|
September 30, 2016
|
|
Last row of records sorted by date and grouped bu custid
|
|
2
|
459
|
September 30, 2016
|
|
Regrading transpose from rows to columns and indicator 0 and 1 and sum combinations
|
|
5
|
726
|
September 30, 2016
|
|
No lock on any tables but when doing re-indexing on transaction table again application works
|
|
4
|
570
|
September 30, 2016
|
|
T-SQL Query Help
|
|
2
|
331
|
September 29, 2016
|
|
Select query to show just 1 row with total count
|
|
4
|
449
|
September 29, 2016
|
|
Transposing data
|
|
1
|
357
|
September 29, 2016
|
|
Percentage in a group in sql
|
|
1
|
630
|
September 28, 2016
|
|
Record Selection
|
|
4
|
484
|
September 28, 2016
|
|
SQL trigger to execute a bat file whenever there is only new record get inserted
|
|
1
|
327
|
September 28, 2016
|
|
Doing re-indexing on transaction table again application works fine
|
|
1
|
528
|
September 28, 2016
|
|
Unpivot sql columns into rows
|
|
0
|
327
|
September 28, 2016
|
|
Temporary Table Memory Usage
|
|
6
|
3496
|
September 28, 2016
|
|
Inserting and then filling blanks between database records
|
|
17
|
1050
|
September 27, 2016
|
|
Install sqlexpress 2016 on Small Business server 2011
|
|
2
|
841
|
September 26, 2016
|
|
Endpoint: Where is Encryption Required/Supported Info?
|
|
0
|
366
|
September 23, 2016
|
|
Fix performance of database 60GB with json strings
|
|
23
|
3471
|
September 23, 2016
|
|
SQL Server 2008: Error 1934 while enabling the database for Merge Replication
|
|
0
|
597
|
September 23, 2016
|
|
Spl Crimson power supply
|
|
0
|
567
|
September 23, 2016
|