|
Why this STRING_AGG does not work?
|
|
6
|
10168
|
March 12, 2021
|
|
Finding the difference between datetimes excluding sundays and Business holidays
|
|
1
|
251
|
March 11, 2021
|
|
Why this join does not work?
|
|
5
|
301
|
March 11, 2021
|
|
Need help with corecly applyingwhere statment
|
|
4
|
332
|
March 8, 2021
|
|
How can do a loop select stmt from this folowing table
|
|
2
|
238
|
March 8, 2021
|
|
Lock my db in client's machine
|
|
10
|
318
|
March 4, 2021
|
|
Get Value from 2 Different Tables Depending on Condition
|
|
4
|
520
|
March 3, 2021
|
|
Moving table data from an SQL script and adding it to another SQL script
|
|
2
|
333
|
March 3, 2021
|
|
GUIs with Databses(Creating a program similar to Microsoft Acces from Scratch)
|
|
0
|
241
|
March 2, 2021
|
|
SUM, MAX, while joining 2 tables
|
|
1
|
230
|
March 2, 2021
|
|
Sql query to select latest row
|
|
2
|
197
|
March 1, 2021
|
|
EXEC sp_MSforeachdb
|
|
4
|
253
|
February 28, 2021
|
|
Why does CASE WHEN NULL IN (SELECT A FROM B) THEN 'Y' ELSE '' AS [NULL] does not work?
|
|
4
|
391
|
February 27, 2021
|
|
What is the difference between IN and EXISTS?
|
|
7
|
309
|
February 27, 2021
|
|
How can I reference the table (T1 JOIN T2 ON A=B JOIN T3 ON C=D)?
|
|
5
|
736
|
February 27, 2021
|
|
Is there an easy way to populate a column with an INDEX/MATCH statement?
|
|
3
|
540
|
February 26, 2021
|
|
Is joining table completely deceiving?
|
|
2
|
219
|
February 25, 2021
|
|
Can SSMS work as Notepad++?
|
|
5
|
879
|
February 24, 2021
|
|
What is the difference between ON (C1=C2 AND C3=C4) and ON (C1=C2 OR C3=C4)?
|
|
3
|
278
|
February 22, 2021
|
|
Passing dynamic column names an data in json to query with
|
|
4
|
5347
|
February 22, 2021
|
|
Do WHERE statements filter the pre-join tables or the after-join table?
|
|
9
|
8804
|
February 22, 2021
|
|
Buggy date comparison
|
|
2
|
239
|
February 21, 2021
|
|
Cannot use an aggregate or a subquery in an expression
|
|
3
|
431
|
February 21, 2021
|
|
Calculate days ahead for a date to know expiring password date
|
|
1
|
243
|
February 19, 2021
|
|
Need help with insert/update statement(Appeon Powerbuilder)
|
|
1
|
561
|
February 19, 2021
|
|
Is there a command to drop all temp tables when re-running the query?
|
|
4
|
5974
|
February 19, 2021
|
|
How can I store and reuse (1,2,3)?
|
|
20
|
409
|
February 18, 2021
|
|
Is it possible to store part of a query as a variable to reuse?
|
|
6
|
810
|
February 18, 2021
|
|
How to use 'IF' in a query
|
|
4
|
210
|
February 18, 2021
|
|
Is this strategy robust?
|
|
4
|
198
|
February 17, 2021
|