|
Clearer GetDate
|
|
10
|
426
|
July 17, 2019
|
|
List Field Names In Group
|
|
8
|
248
|
July 17, 2019
|
|
Min,Max with Ranking
|
|
5
|
255
|
July 16, 2019
|
|
What SQL query to search for string containing alphanumeric characters and a specific word
|
|
1
|
319
|
July 16, 2019
|
|
How to get CF Leave with deduction of burnt leave (Available Leave only applicable for 3 month)
|
|
12
|
638
|
July 16, 2019
|
|
T-sql 2012 case statement within an update statement
|
|
1
|
268
|
July 15, 2019
|
|
Update 1 field out of 5
|
|
2
|
300
|
July 15, 2019
|
|
Insert values into table with foreign keys
|
|
1
|
240
|
July 13, 2019
|
|
How to Round to Nearest Whole Number
|
|
6
|
492
|
July 11, 2019
|
|
Best DB design -1 table, 2 items with same attributes
|
|
8
|
714
|
July 11, 2019
|
|
Use of one table as source of values for two columns in another table while maintaining integrity
|
|
2
|
285
|
July 11, 2019
|
|
Temp Table to run report from Visual Studio against, daily
|
|
9
|
904
|
July 10, 2019
|
|
Income, Expense Query in SQL Server
|
|
13
|
1927
|
July 9, 2019
|
|
T-sql 2012 issue with an update statement
|
|
2
|
310
|
July 7, 2019
|
|
Procedure t sql .. help urgency
|
|
4
|
978
|
May 11, 2018
|
|
Resources & Books
|
|
2
|
254
|
July 5, 2019
|
|
A way of Dialects' disappearance
|
|
0
|
260
|
July 5, 2019
|
|
Msg 102, Level 15, State 1, Line 6 Incorrect syntax near ')'
|
|
1
|
396
|
July 4, 2019
|
|
Data grouping based on time hour
|
|
2
|
333
|
July 3, 2019
|
|
Number of hours active for a week
|
|
14
|
525
|
July 3, 2019
|
|
Return Week Commencing Date (Monday) for a time stamped field
|
|
1
|
813
|
July 2, 2019
|
|
Shrink Database
|
|
3
|
303
|
July 2, 2019
|
|
Sql Regex pattern Find
|
|
1
|
328
|
July 1, 2019
|
|
Remove/Replace White Space in Columns
|
|
11
|
1338
|
July 1, 2019
|
|
sp_MSForEachTable
|
|
2
|
298
|
July 1, 2019
|
|
SQL to transpose result onto single line
|
|
22
|
655
|
June 30, 2019
|
|
Very long SQL query with lots of complex Calculations and conditions
|
|
14
|
1525
|
June 29, 2019
|
|
Query is not giving correct output of Column (Small_Bale_Weight)
|
|
0
|
266
|
June 29, 2019
|
|
Database Design SQL server
|
|
57
|
1839
|
June 29, 2019
|
|
How to update a value on another table due to updated value for the same fk value?
|
|
4
|
378
|
June 28, 2019
|