|
UPDATE, CASE results
|
|
7
|
1159
|
July 17, 2015
|
|
SQL to determine if a non-attendance is a “DROPOUT”
|
|
4
|
960
|
July 17, 2015
|
|
Where clause of an update statement
|
|
45
|
3155
|
July 16, 2015
|
|
Sql server: output as per requirement
|
|
2
|
1015
|
July 16, 2015
|
|
User Notification Query
|
|
7
|
1243
|
July 15, 2015
|
|
Grab oldest Date
|
|
3
|
962
|
July 15, 2015
|
|
Fastest way to retrieve the result
|
|
5
|
1361
|
July 15, 2015
|
|
Update table by looping values from another
|
|
8
|
1046
|
July 15, 2015
|
|
Create journal entries for moving assets
|
|
3
|
973
|
July 15, 2015
|
|
Modifying T-SQL query to return XML results
|
|
1
|
515
|
July 15, 2015
|
|
Table constraint
|
|
2
|
494
|
July 14, 2015
|
|
Select records by compare LName and FName
|
|
1
|
558
|
July 14, 2015
|
|
Trying to calculate aggregate functions
|
|
2
|
931
|
July 14, 2015
|
|
Error in - Alter table column datatype size
|
|
10
|
1041
|
July 14, 2015
|
|
Search between range
|
|
3
|
681
|
July 14, 2015
|
|
Convert/cast
|
|
10
|
1988
|
July 13, 2015
|
|
Evaluating rows to identify >=6 months of consecutive service
|
|
2
|
742
|
July 13, 2015
|
|
If statment on mmdd
|
|
5
|
1162
|
July 13, 2015
|
|
New to SQL - Query Help
|
|
5
|
1008
|
July 13, 2015
|
|
TmpTbl with # sign
|
|
7
|
1271
|
July 13, 2015
|
|
Oracle to SQL
|
|
8
|
1110
|
July 13, 2015
|
|
Nvarchar convert to decimal with sum
|
|
4
|
3493
|
July 13, 2015
|
|
If it exists, update it; if not, create it
|
|
10
|
1542
|
July 13, 2015
|
|
SQL Server one to many relationship
|
|
2
|
999
|
July 13, 2015
|
|
How to remove the duplicate records based on memberid
|
|
5
|
1678
|
July 13, 2015
|
|
Many-to-many, how do I handle IDs?
|
|
1
|
835
|
July 13, 2015
|
|
Computation between two rows of same table
|
|
4
|
1111
|
July 12, 2015
|
|
Epllation of code
|
|
1
|
657
|
July 12, 2015
|
|
Count calls to a function
|
|
2
|
835
|
July 12, 2015
|
|
My StoreProcedure Problem
|
|
2
|
754
|
July 11, 2015
|