|
Tricky selects in the same table
|
|
5
|
338
|
September 2, 2020
|
|
Trying to add an additional field to a pre-existing SQL code
|
|
5
|
250
|
September 2, 2020
|
|
To assign number incrementally and re-inititialize when column value changes
|
|
25
|
426
|
September 2, 2020
|
|
Select statement take 10 minute to return 1000 rows only why and how to minimize time?
|
|
5
|
375
|
September 2, 2020
|
|
Database mapping
|
|
0
|
244
|
September 2, 2020
|
|
Create employee list which not exist in first select
|
|
6
|
210
|
September 1, 2020
|
|
Reorder rank upon condition
|
|
6
|
240
|
September 1, 2020
|
|
Row partition isuue
|
|
1
|
180
|
September 1, 2020
|
|
How to address a huge jump in identity number?
|
|
3
|
1002
|
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
|
332
|
September 1, 2020
|
|
Partition issue
|
|
2
|
196
|
August 31, 2020
|
|
Q) Write a query to return Territory and corresponding Sales Growth (compare growth between periods Q4-2019 vs Q3-2019)
|
|
1
|
275
|
August 31, 2020
|
|
Function to ignore timestamp in DATE
|
|
2
|
2021
|
August 31, 2020
|
|
Row over partition problem
|
|
1
|
159
|
August 31, 2020
|
|
Finding the Out of Stock days and the disabled number of days at an item level
|
|
9
|
283
|
August 31, 2020
|
|
Many to many relationship query
|
|
4
|
274
|
August 29, 2020
|
|
Can you help me enhance query performance?
|
|
7
|
317
|
August 28, 2020
|
|
SQL Query with Tables from Two Databases in Same Server
|
|
1
|
250
|
August 28, 2020
|
|
Select and procedure / function
|
|
5
|
193
|
August 28, 2020
|
|
Run SSIS in SQL Job
|
|
1
|
502
|
August 28, 2020
|
|
The data types xml and varchar are incompatible in the equal to operator
|
|
4
|
2071
|
August 28, 2020
|
|
Getting sum from joined table data - MS SQL 2014
|
|
2
|
282
|
August 28, 2020
|
|
Pass column value to function in dynamic query string
|
|
4
|
385
|
August 27, 2020
|
|
SSIS Job Cannot Start - A required privilege is not held by the client
|
|
1
|
6562
|
August 27, 2020
|
|
Identify the corresponding negative number and separate left over positive number
|
|
3
|
331
|
August 27, 2020
|
|
An expression of Non-boolean type specified in a context when a condition is expected near 'id'
|
|
4
|
935
|
August 27, 2020
|
|
Replace quotation mark that is before or follows a letter but not a number
|
|
8
|
356
|
August 26, 2020
|
|
Avoiding error message regarding Default value
|
|
3
|
2206
|
August 25, 2020
|
|
TCP Provider: An existing connection was forcibly closed by the remote host
|
|
0
|
3788
|
August 24, 2020
|