|
How to update status to not match character in case of signature key not have stars *?
|
|
3
|
381
|
September 8, 2020
|
|
How to replace (or Plid is null) with any thing more best practice?
|
|
6
|
326
|
September 7, 2020
|
|
Safe/correct way to reduce balance from account
|
|
2
|
365
|
September 3, 2020
|
|
Strangest thing... for little old me anyway
|
|
11
|
339
|
September 3, 2020
|
|
Insert unique record into the table
|
|
11
|
289
|
September 3, 2020
|
|
Update record
|
|
2
|
211
|
September 3, 2020
|
|
How to update table
|
|
3
|
278
|
September 3, 2020
|
|
SQL Query to match and increment the number on the match
|
|
11
|
592
|
September 3, 2020
|
|
Using the Most Recent Data
|
|
4
|
236
|
September 2, 2020
|
|
Tricky selects in the same table
|
|
5
|
336
|
September 2, 2020
|
|
To assign number incrementally and re-inititialize when column value changes
|
|
25
|
422
|
September 2, 2020
|
|
Select statement take 10 minute to return 1000 rows only why and how to minimize time?
|
|
5
|
371
|
September 2, 2020
|
|
Reorder rank upon condition
|
|
6
|
236
|
September 1, 2020
|
|
Finding the Number of Out of Stock Days and Disabled days considering the start and end of the week
|
|
0
|
189
|
September 1, 2020
|
|
How to get missing parts on trade code table and that exist on table #parts and #search data?
|
|
7
|
326
|
September 1, 2020
|
|
Partition issue
|
|
2
|
191
|
August 31, 2020
|
|
Row over partition problem
|
|
1
|
156
|
August 31, 2020
|
|
Finding the Out of Stock days and the disabled number of days at an item level
|
|
9
|
278
|
August 31, 2020
|
|
Many to many relationship query
|
|
4
|
274
|
August 29, 2020
|
|
Can you help me enhance query performance?
|
|
7
|
311
|
August 28, 2020
|
|
SQL Query with Tables from Two Databases in Same Server
|
|
1
|
249
|
August 28, 2020
|
|
Select and procedure / function
|
|
5
|
189
|
August 28, 2020
|
|
Getting sum from joined table data - MS SQL 2014
|
|
2
|
274
|
August 28, 2020
|
|
Replace quotation mark that is before or follows a letter but not a number
|
|
8
|
336
|
August 26, 2020
|
|
Avoiding error message regarding Default value
|
|
3
|
2149
|
August 25, 2020
|
|
How to update status where no data returned from select statement?
|
|
1
|
256
|
August 24, 2020
|
|
Why count is wrong for Books related to Authors?
|
|
10
|
365
|
August 24, 2020
|
|
When group value based on feature some times come left and some times come right why and how to solve issue
|
|
10
|
292
|
August 24, 2020
|
|
Update query question
|
|
7
|
236
|
August 24, 2020
|
|
How to replace sub string by stuff?
|
|
1
|
261
|
August 24, 2020
|