|
Write an SQL against an excel spreadsheet
|
|
7
|
674
|
November 10, 2020
|
|
Conversion Failed When Converting the varchar value
|
|
4
|
1565
|
November 10, 2020
|
|
How to join many table with date interval in mysql
|
|
0
|
296
|
November 6, 2020
|
|
Need to move data from an IBM AS400 to a SQL Server
|
|
3
|
1354
|
November 3, 2020
|
|
Compare data of two table
|
|
3
|
295
|
November 3, 2020
|
|
Calculating working days between two dates
|
|
31
|
699
|
November 1, 2020
|
|
Set up alwaysON cluster
|
|
1
|
241
|
October 29, 2020
|
|
Certification on data warehouse
|
|
0
|
217
|
October 29, 2020
|
|
Manipulating Functions
|
|
1
|
341
|
October 28, 2020
|
|
What is the sequence of execution of SQL statements?
|
|
4
|
313
|
October 28, 2020
|
|
Selecting multiple criterias
|
|
3
|
556
|
October 27, 2020
|
|
Add two case statements to get net trade amount
|
|
5
|
320
|
October 26, 2020
|
|
Rolling Net Trade Values up by month
|
|
1
|
275
|
October 26, 2020
|
|
Trying to count two different amounts
|
|
4
|
346
|
October 26, 2020
|
|
Linked Server in SQL
|
|
0
|
198
|
October 22, 2020
|
|
SQL Question
|
|
1
|
353
|
October 21, 2020
|
|
SQL dateadd function
|
|
2
|
298
|
October 20, 2020
|
|
Sql query for masking 1st five charc in each cloumn
|
|
4
|
281
|
October 20, 2020
|
|
SQL SERVER EXTRACT METADATA & 100 rows for each table
|
|
23
|
2364
|
October 19, 2020
|
|
Help with a query
|
|
11
|
445
|
October 19, 2020
|
|
To ignore syntax error and continue executing back and forth between try and catch block
|
|
8
|
349
|
October 15, 2020
|
|
How to do an outer join when there are conditions
|
|
1
|
278
|
October 15, 2020
|
|
Is it possible to create sets?
|
|
1
|
291
|
October 6, 2020
|
|
Issue with joins
|
|
16
|
367
|
October 14, 2020
|
|
Remove one work with create as a column
|
|
7
|
303
|
October 14, 2020
|
|
Column showing how many days since last date of service
|
|
5
|
256
|
October 12, 2020
|
|
How can I get just the latest row?
|
|
7
|
342
|
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
|
1010
|
October 11, 2020
|
|
One to One relationship with Id in both tables. Possible or should be avoided?
|
|
0
|
226
|
October 9, 2020
|
|
Help with Date Arithmetic
|
|
0
|
333
|
October 9, 2020
|