|
Merging between two tables not working properly
|
|
4
|
720
|
April 4, 2017
|
|
Going back in time from today's date, but not including weekend saturday and sunday dates
|
|
5
|
655
|
April 4, 2017
|
|
Alternative to Subquery in join
|
|
5
|
3259
|
April 4, 2017
|
|
Dividing and Rounding up not working
|
|
2
|
597
|
April 3, 2017
|
|
Passing list of values to stored procedure
|
|
11
|
11723
|
April 3, 2017
|
|
Sql error won upload
|
|
31
|
4511
|
April 3, 2017
|
|
Pivot or not - 2 SQL Queries
|
|
4
|
693
|
April 3, 2017
|
|
Order BY Clause Conflict with Distinct
|
|
1
|
599
|
April 3, 2017
|
|
Employee Location History Table
|
|
3
|
602
|
April 2, 2017
|
|
Get Top Bidder for each product based on ID sequence (First IN; First Priority win the item - first IN; top price win the item), 1 user only allow win 1 item
|
|
3
|
487
|
March 31, 2017
|
|
Match two data sets based on item values
|
|
4
|
765
|
March 31, 2017
|
|
Create view showing current status on each day
|
|
1
|
465
|
March 30, 2017
|
|
Query with subqueries using queries results
|
|
2
|
580
|
March 30, 2017
|
|
Repeatedly records
|
|
2
|
683
|
March 30, 2017
|
|
Convert IF statement to CASE
|
|
1
|
496
|
March 30, 2017
|
|
Extract data
|
|
7
|
714
|
March 30, 2017
|
|
Inserting new recordset from another recordset in Stored Procedure
|
|
8
|
694
|
March 30, 2017
|
|
Finding the tag of a particular status - two dates in two tables
|
|
2
|
478
|
March 30, 2017
|
|
Creating a Procedure for Comparing Two Tables
|
|
0
|
398
|
March 30, 2017
|
|
Select Replace and convert from int to string
|
|
5
|
730
|
March 30, 2017
|
|
How to generate rows by month based on loop iterate month from date
|
|
3
|
749
|
March 30, 2017
|
|
Summing a column
|
|
4
|
523
|
March 30, 2017
|
|
Cursor, Dynamic SQL or both
|
|
2
|
573
|
March 29, 2017
|
|
Query to get multiple results from one column
|
|
3
|
494
|
March 29, 2017
|
|
Retrieving data from blob column where characters are unknown
|
|
2
|
476
|
March 28, 2017
|
|
SQL Help for multiple conditions
|
|
4
|
535
|
March 27, 2017
|
|
Query with left outer join (replace *=)
|
|
7
|
862
|
March 27, 2017
|
|
2 Replace Functions in 1 column
|
|
6
|
783
|
March 27, 2017
|
|
Query help please
|
|
1
|
369
|
March 26, 2017
|
|
Need t-sql code to Parse string
|
|
20
|
1683
|
March 26, 2017
|