|
List Field Names In Group
|
|
8
|
245
|
July 17, 2019
|
|
Min,Max with Ranking
|
|
5
|
241
|
July 16, 2019
|
|
What SQL query to search for string containing alphanumeric characters and a specific word
|
|
1
|
316
|
July 16, 2019
|
|
How to get CF Leave with deduction of burnt leave (Available Leave only applicable for 3 month)
|
|
12
|
559
|
July 16, 2019
|
|
T-sql 2012 case statement within an update statement
|
|
1
|
260
|
July 15, 2019
|
|
Update 1 field out of 5
|
|
2
|
277
|
July 15, 2019
|
|
Insert values into table with foreign keys
|
|
1
|
235
|
July 13, 2019
|
|
How to Round to Nearest Whole Number
|
|
6
|
469
|
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
|
283
|
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
|
1847
|
July 9, 2019
|
|
T-sql 2012 issue with an update statement
|
|
2
|
303
|
July 7, 2019
|
|
Procedure t sql .. help urgency
|
|
4
|
934
|
May 11, 2018
|
|
Resources & Books
|
|
2
|
244
|
July 5, 2019
|
|
A way of Dialects' disappearance
|
|
0
|
257
|
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
|
317
|
July 3, 2019
|
|
Number of hours active for a week
|
|
14
|
432
|
July 3, 2019
|
|
Return Week Commencing Date (Monday) for a time stamped field
|
|
1
|
774
|
July 2, 2019
|
|
Shrink Database
|
|
3
|
276
|
July 2, 2019
|
|
Sql Regex pattern Find
|
|
1
|
318
|
July 1, 2019
|
|
Remove/Replace White Space in Columns
|
|
11
|
1269
|
July 1, 2019
|
|
sp_MSForEachTable
|
|
2
|
288
|
July 1, 2019
|
|
SQL to transpose result onto single line
|
|
22
|
558
|
June 30, 2019
|
|
Very long SQL query with lots of complex Calculations and conditions
|
|
14
|
1455
|
June 29, 2019
|
|
Query is not giving correct output of Column (Small_Bale_Weight)
|
|
0
|
264
|
June 29, 2019
|
|
Database Design SQL server
|
|
57
|
1552
|
June 29, 2019
|
|
How to update a value on another table due to updated value for the same fk value?
|
|
4
|
352
|
June 28, 2019
|
|
Simple SELECT queries between 2 databases are not returning any result - need help
|
|
5
|
328
|
June 27, 2019
|