|
Merge time slots where there are no gaps greater than slot allocation
|
|
2
|
664
|
September 1, 2016
|
|
Integration of Query with existing Stored Procedure
|
|
1
|
707
|
September 1, 2016
|
|
Comparing text field with Dates
|
|
9
|
1173
|
August 30, 2016
|
|
Calculating 12 X the monthly rate
|
|
3
|
537
|
August 30, 2016
|
|
Exclude on net $0?
|
|
7
|
831
|
August 29, 2016
|
|
Find best seller product based on sale and quantity
|
|
3
|
693
|
August 29, 2016
|
|
Display unprocessed Order details based on order quantity by stored procedure
|
|
8
|
1154
|
August 26, 2016
|
|
SQL join - multiple columns and multiple tables
|
|
9
|
1038
|
August 26, 2016
|
|
Exclude Tables on Update Statistics script
|
|
5
|
2924
|
August 25, 2016
|
|
Permission for Trigger
|
|
2
|
476
|
August 25, 2016
|
|
How to calculate running total column which has more than one date where criteria
|
|
1
|
568
|
August 24, 2016
|
|
Inner join, subselect, xml, or what to use?
|
|
2
|
594
|
August 24, 2016
|
|
Query Help
|
|
2
|
414
|
August 23, 2016
|
|
Case syntax
|
|
2
|
354
|
August 23, 2016
|
|
Sort sub select?
|
|
1
|
510
|
August 23, 2016
|
|
MS SQL - Import large data using Management Studio only
|
|
12
|
1649
|
August 23, 2016
|
|
Exec Procedure in select
|
|
2
|
705
|
August 23, 2016
|
|
Error converting data type varchar to bigint
|
|
2
|
566
|
August 22, 2016
|
|
XML query returns 0 rows
|
|
3
|
613
|
August 22, 2016
|
|
Calculate discount amount based on percentage in column
|
|
2
|
680
|
August 22, 2016
|
|
Concurrency Conflict
|
|
1
|
577
|
August 21, 2016
|
|
Retrieve portion id from the specific characters defined
|
|
2
|
491
|
August 19, 2016
|
|
Silly question
|
|
6
|
651
|
August 18, 2016
|
|
Group by issue
|
|
7
|
755
|
August 18, 2016
|
|
Inserting different Dateformats
|
|
4
|
550
|
August 18, 2016
|
|
SQL server 2014 - using patindex
|
|
3
|
769
|
August 17, 2016
|
|
Excel cell data from sql query
|
|
1
|
548
|
August 17, 2016
|
|
T-SQL to fill in gaps in table with averages determined in another table
|
|
7
|
1124
|
August 16, 2016
|
|
SQL Query involving two tables
|
|
2
|
438
|
August 15, 2016
|
|
Choosing duplicate records
|
|
1
|
451
|
August 12, 2016
|