|
Select records with CASE statement
|
|
11
|
1244
|
March 9, 2016
|
|
Inner joins
|
|
8
|
1489
|
March 9, 2016
|
|
Msg 8120, Level 16, State 1, Line 1 Column 'Advisors.FirstName' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause
|
|
3
|
2644
|
March 9, 2016
|
|
Sequencenumber
|
|
1
|
389
|
March 9, 2016
|
|
5 previous working days
|
|
3
|
779
|
March 9, 2016
|
|
Help with "Join" repeating rows
|
|
1
|
478
|
March 8, 2016
|
|
Julian date to regular date
|
|
9
|
1154
|
March 8, 2016
|
|
Change Collation and refresh
|
|
1
|
635
|
March 8, 2016
|
|
Help Needed in Sql Function
|
|
6
|
943
|
March 8, 2016
|
|
Tryring to execute a command but i keep seeing the Msg 8120 error
|
|
3
|
748
|
March 8, 2016
|
|
Order by clause
|
|
2
|
417
|
March 7, 2016
|
|
Using Sub Query for results in a column
|
|
9
|
822
|
March 7, 2016
|
|
Select... max()
|
|
3
|
724
|
March 7, 2016
|
|
Calculate head count
|
|
1
|
801
|
March 7, 2016
|
|
SQL string into SQL query
|
|
3
|
987
|
March 7, 2016
|
|
Extract Parts of String
|
|
10
|
1673
|
March 7, 2016
|
|
Return changed values
|
|
1
|
433
|
March 7, 2016
|
|
Query help
|
|
4
|
1005
|
March 5, 2016
|
|
Old user and new user
|
|
9
|
1334
|
March 5, 2016
|
|
Combine records of different columns
|
|
3
|
738
|
March 4, 2016
|
|
Don't know where to start
|
|
8
|
1168
|
March 3, 2016
|
|
Extract part of Zipcode from full address string
|
|
6
|
11376
|
March 3, 2016
|
|
Newbie - I Dont Know
|
|
7
|
1102
|
March 3, 2016
|
|
Extract numeric values with digits from string
|
|
6
|
3341
|
March 3, 2016
|
|
Show 0 values if they are present
|
|
5
|
1184
|
March 2, 2016
|
|
If Column Exists in Source But Not Destination Then Create New Column
|
|
5
|
1754
|
March 2, 2016
|
|
Way to optimize this sql
|
|
4
|
820
|
March 2, 2016
|
|
Filtering Dates
|
|
10
|
1519
|
March 2, 2016
|
|
Remove .00 from float data type and set it to a whole number
|
|
1
|
625
|
March 2, 2016
|
|
SQL Server Join Help (Basic)
|
|
2
|
794
|
March 2, 2016
|