|
Simplify a database table
|
|
1
|
255
|
October 13, 2020
|
|
Generating Narcissistic Number or Armstrong Number and TSQL
|
|
15
|
487
|
October 13, 2020
|
|
Performance Issue
|
|
8
|
406
|
October 12, 2020
|
|
Create privileges for user to see his own data by his id
|
|
3
|
253
|
October 11, 2020
|
|
Incorrect syntax error near 1059 when build dynamic query?
|
|
1
|
294
|
October 11, 2020
|
|
Optimization of duplicates code block in query
|
|
2
|
390
|
October 11, 2020
|
|
SQL - syntax
|
|
2
|
239
|
October 11, 2020
|
|
How to avoid using ( OR && IS NULL ) on where statment when Delete Data?
|
|
6
|
365
|
October 10, 2020
|
|
How to select data based dynamically based on start and end of Affected Product from Parts Data Table?
|
|
7
|
371
|
October 8, 2020
|
|
Aggregate value by group
|
|
2
|
256
|
October 8, 2020
|
|
Convert Data Type within a Select Query and while using a Case When Query
|
|
3
|
864
|
October 7, 2020
|
|
To create three rows against each row
|
|
26
|
1270
|
October 6, 2020
|
|
Splitting a crazy column into two new columns
|
|
5
|
411
|
October 6, 2020
|
|
Compare 2 tables
|
|
17
|
372
|
October 6, 2020
|
|
SQL pattern search
|
|
11
|
369
|
October 5, 2020
|
|
Simple sql query format
|
|
10
|
573
|
October 5, 2020
|
|
Find rows with duplicate sub strings
|
|
8
|
1081
|
October 4, 2020
|
|
Delete records from multiple tables
|
|
2
|
1133
|
October 4, 2020
|
|
Getting cumulative values when certain dates have no records
|
|
2
|
290
|
October 1, 2020
|
|
Add a Time column and a Date column together?
|
|
5
|
301
|
October 1, 2020
|
|
How to separate values by stick when Feature values for C and X is different?
|
|
4
|
315
|
September 30, 2020
|
|
Sql and Where Clause with Data Type Table
|
|
1
|
291
|
September 30, 2020
|
|
USP VS TVF - why is one so much slower than the other?
|
|
7
|
799
|
September 30, 2020
|
|
Why is this simple running total script erroring?
|
|
5
|
273
|
September 30, 2020
|
|
Can I use only one statment for update without using three statment update separately?
|
|
3
|
282
|
September 30, 2020
|
|
How to delete part of string
|
|
14
|
435
|
September 29, 2020
|
|
Today date -1 year
|
|
2
|
319
|
September 28, 2020
|
|
How to count Leadfinish where have values and not null?
|
|
4
|
324
|
September 27, 2020
|
|
To get Total Hour & Late Hour from Time In, Time Out, 1st Break & 2nd Break
|
|
22
|
487
|
September 25, 2020
|
|
Performance issue?
|
|
3
|
283
|
September 25, 2020
|