|
How to get CF Leave with deduction of burnt leave (Available Leave only applicable for 3 month)
|
|
12
|
554
|
July 16, 2019
|
|
T-sql 2012 case statement within an update statement
|
|
1
|
259
|
July 15, 2019
|
|
Update 1 field out of 5
|
|
2
|
277
|
July 15, 2019
|
|
Insert values into table with foreign keys
|
|
1
|
234
|
July 13, 2019
|
|
How to Round to Nearest Whole Number
|
|
6
|
465
|
July 11, 2019
|
|
Best DB design -1 table, 2 items with same attributes
|
|
8
|
662
|
July 11, 2019
|
|
Use of one table as source of values for two columns in another table while maintaining integrity
|
|
2
|
281
|
July 11, 2019
|
|
Temp Table to run report from Visual Studio against, daily
|
|
9
|
849
|
July 10, 2019
|
|
Income, Expense Query in SQL Server
|
|
13
|
1846
|
July 9, 2019
|
|
T-sql 2012 issue with an update statement
|
|
2
|
302
|
July 7, 2019
|
|
Procedure t sql .. help urgency
|
|
4
|
933
|
May 11, 2018
|
|
Resources & Books
|
|
2
|
244
|
July 5, 2019
|
|
A way of Dialects' disappearance
|
|
0
|
256
|
July 5, 2019
|
|
Msg 102, Level 15, State 1, Line 6 Incorrect syntax near ')'
|
|
1
|
387
|
July 4, 2019
|
|
Data grouping based on time hour
|
|
2
|
313
|
July 3, 2019
|
|
Number of hours active for a week
|
|
14
|
431
|
July 3, 2019
|
|
Return Week Commencing Date (Monday) for a time stamped field
|
|
1
|
762
|
July 2, 2019
|
|
Shrink Database
|
|
3
|
274
|
July 2, 2019
|
|
Sql Regex pattern Find
|
|
1
|
318
|
July 1, 2019
|
|
Remove/Replace White Space in Columns
|
|
11
|
1252
|
July 1, 2019
|
|
sp_MSForEachTable
|
|
2
|
287
|
July 1, 2019
|
|
SQL to transpose result onto single line
|
|
22
|
553
|
June 30, 2019
|
|
Very long SQL query with lots of complex Calculations and conditions
|
|
14
|
1450
|
June 29, 2019
|
|
Query is not giving correct output of Column (Small_Bale_Weight)
|
|
0
|
264
|
June 29, 2019
|
|
Database Design SQL server
|
|
57
|
1518
|
June 29, 2019
|
|
How to update a value on another table due to updated value for the same fk value?
|
|
4
|
348
|
June 28, 2019
|
|
Simple SELECT queries between 2 databases are not returning any result - need help
|
|
5
|
326
|
June 27, 2019
|
|
Splitting out a date
|
|
4
|
307
|
June 27, 2019
|
|
How to transfer a query result from a tab to another one without going through a system file
|
|
3
|
413
|
June 26, 2019
|
|
Update table with variables in insert sql
|
|
3
|
260
|
June 26, 2019
|