|
Use of one table as source of values for two columns in another table while maintaining integrity
|
|
2
|
280
|
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
|
1832
|
July 9, 2019
|
|
T-sql 2012 issue with an update statement
|
|
2
|
298
|
July 7, 2019
|
|
Procedure t sql .. help urgency
|
|
4
|
930
|
May 11, 2018
|
|
Resources & Books
|
|
2
|
240
|
July 5, 2019
|
|
A way of Dialects' disappearance
|
|
0
|
255
|
July 5, 2019
|
|
Msg 102, Level 15, State 1, Line 6 Incorrect syntax near ')'
|
|
1
|
386
|
July 4, 2019
|
|
Data grouping based on time hour
|
|
2
|
312
|
July 3, 2019
|
|
Number of hours active for a week
|
|
14
|
430
|
July 3, 2019
|
|
Return Week Commencing Date (Monday) for a time stamped field
|
|
1
|
727
|
July 2, 2019
|
|
Shrink Database
|
|
3
|
272
|
July 2, 2019
|
|
Sql Regex pattern Find
|
|
1
|
313
|
July 1, 2019
|
|
Remove/Replace White Space in Columns
|
|
11
|
1183
|
July 1, 2019
|
|
sp_MSForEachTable
|
|
2
|
269
|
July 1, 2019
|
|
SQL to transpose result onto single line
|
|
22
|
524
|
June 30, 2019
|
|
Very long SQL query with lots of complex Calculations and conditions
|
|
14
|
1406
|
June 29, 2019
|
|
Query is not giving correct output of Column (Small_Bale_Weight)
|
|
0
|
264
|
June 29, 2019
|
|
Database Design SQL server
|
|
57
|
1485
|
June 29, 2019
|
|
How to update a value on another table due to updated value for the same fk value?
|
|
4
|
333
|
June 28, 2019
|
|
Simple SELECT queries between 2 databases are not returning any result - need help
|
|
5
|
319
|
June 27, 2019
|
|
Splitting out a date
|
|
4
|
299
|
June 27, 2019
|
|
How to transfer a query result from a tab to another one without going through a system file
|
|
3
|
412
|
June 26, 2019
|
|
Update table with variables in insert sql
|
|
3
|
259
|
June 26, 2019
|
|
Both Read Uncommitted and Deadlock Priority Low
|
|
1
|
299
|
June 25, 2019
|
|
Latest value for a collection on counters
|
|
7
|
394
|
June 25, 2019
|
|
Retrieve the same tables and columns result set from 40 database at once
|
|
14
|
780
|
June 24, 2019
|
|
Error in Creating table
|
|
2
|
273
|
June 24, 2019
|
|
Struggeling to get date for Friday next week
|
|
10
|
501
|
June 24, 2019
|
|
Row count discounting subsequent records
|
|
5
|
455
|
June 24, 2019
|