|
Timeout when executing MERGE-statement in SQL Server 2016
|
|
1
|
1901
|
December 28, 2016
|
|
Create Table and add constraint
|
|
4
|
770
|
December 27, 2016
|
|
Returning only datetimes that occur more than once
|
|
2
|
536
|
December 25, 2016
|
|
Pivot with a comma and a space
|
|
6
|
841
|
December 26, 2016
|
|
Converting float value to smalldatetime is giving future date
|
|
12
|
5520
|
December 23, 2016
|
|
Help trying to match payments to invoices
|
|
2
|
679
|
December 22, 2016
|
|
Help with formatting an WHERE clause to remove duplicates without using DISTINCT
|
|
7
|
1862
|
December 21, 2016
|
|
Function to send email returning errors when called
|
|
10
|
2310
|
December 21, 2016
|
|
Previous row's one column data
|
|
3
|
515
|
December 21, 2016
|
|
Eliminating periods to find email pattern in SQL
|
|
2
|
587
|
December 20, 2016
|
|
Using Information Schema to query constraint from table
|
|
1
|
1284
|
December 20, 2016
|
|
Reformat output to different column structure
|
|
3
|
717
|
December 20, 2016
|
|
How do you search a table column containing wildcards
|
|
2
|
555
|
December 20, 2016
|
|
Parent child record from same table
|
|
3
|
2015
|
December 20, 2016
|
|
Query to find Special character & numeric in Name field
|
|
3
|
583
|
December 20, 2016
|
|
Reverse Recursive CTE to find Parent value
|
|
5
|
3618
|
December 20, 2016
|
|
Header in export file is changd from #DL to .DL
|
|
6
|
787
|
December 20, 2016
|
|
Trigger
|
|
2
|
654
|
December 20, 2016
|
|
Get data for present and past 2 years of date column
|
|
1
|
655
|
December 16, 2016
|
|
Printing years using CTE
|
|
16
|
1253
|
December 16, 2016
|
|
Desing of a table and Hirerarchy - IP's
|
|
0
|
519
|
December 16, 2016
|
|
Join columns and sum the value in one of the columns
|
|
9
|
1044
|
December 16, 2016
|
|
Calculate percentage in SQL
|
|
1
|
554
|
December 16, 2016
|
|
Using COALESCE or IS NULL not workin on User-Defined Table Type
|
|
8
|
963
|
December 15, 2016
|
|
Rounding a Calculated Field in Select Query
|
|
5
|
765
|
December 15, 2016
|
|
30 days followup admit into single line
|
|
3
|
567
|
December 14, 2016
|
|
Alpha and Numeric data in same column
|
|
7
|
686
|
December 13, 2016
|
|
Where EXISTS, subtract one line from the other
|
|
7
|
790
|
December 13, 2016
|
|
Joining Two tables from two different database but same server
|
|
2
|
550
|
December 13, 2016
|
|
Even distribution of costs
|
|
2
|
360
|
December 13, 2016
|