|
Calculating working days between two dates
|
|
31
|
550
|
November 1, 2020
|
|
Set up alwaysON cluster
|
|
1
|
232
|
October 29, 2020
|
|
Certification on data warehouse
|
|
0
|
211
|
October 29, 2020
|
|
Manipulating Functions
|
|
1
|
326
|
October 28, 2020
|
|
What is the sequence of execution of SQL statements?
|
|
4
|
288
|
October 28, 2020
|
|
Selecting multiple criterias
|
|
3
|
538
|
October 27, 2020
|
|
Add two case statements to get net trade amount
|
|
5
|
295
|
October 26, 2020
|
|
Rolling Net Trade Values up by month
|
|
1
|
266
|
October 26, 2020
|
|
Trying to count two different amounts
|
|
4
|
316
|
October 26, 2020
|
|
Linked Server in SQL
|
|
0
|
193
|
October 22, 2020
|
|
SQL Question
|
|
1
|
333
|
October 21, 2020
|
|
SQL dateadd function
|
|
2
|
288
|
October 20, 2020
|
|
Sql query for masking 1st five charc in each cloumn
|
|
4
|
268
|
October 20, 2020
|
|
SQL SERVER EXTRACT METADATA & 100 rows for each table
|
|
23
|
2134
|
October 19, 2020
|
|
Help with a query
|
|
11
|
405
|
October 19, 2020
|
|
To ignore syntax error and continue executing back and forth between try and catch block
|
|
8
|
304
|
October 15, 2020
|
|
How to do an outer join when there are conditions
|
|
1
|
267
|
October 15, 2020
|
|
Is it possible to create sets?
|
|
1
|
286
|
October 6, 2020
|
|
Issue with joins
|
|
16
|
329
|
October 14, 2020
|
|
Remove one work with create as a column
|
|
7
|
278
|
October 14, 2020
|
|
Column showing how many days since last date of service
|
|
5
|
244
|
October 12, 2020
|
|
How can I get just the latest row?
|
|
7
|
322
|
October 12, 2020
|
|
Write a SQL statement to make a join on the tables salesman, customer and orders in such a form that the same column of each table will appear once and only the relational rows will come?
|
|
1
|
1007
|
October 11, 2020
|
|
One to One relationship with Id in both tables. Possible or should be avoided?
|
|
0
|
221
|
October 9, 2020
|
|
Help with Date Arithmetic
|
|
0
|
326
|
October 9, 2020
|
|
Group By Issue
|
|
3
|
281
|
October 9, 2020
|
|
Problem with duplicate when join tables
|
|
5
|
303
|
October 7, 2020
|
|
Facing issue while returning true or false
|
|
7
|
315
|
October 7, 2020
|
|
Doubt sql creation user
|
|
2
|
251
|
October 1, 2020
|
|
Develop pivot table query
|
|
4
|
380
|
September 30, 2020
|