|
Group By or CTE?
|
|
5
|
203
|
January 12, 2023
|
|
How to Insert Fixed Date into Excel Header
|
|
5
|
446
|
January 11, 2023
|
|
MS SQL Express install issues
|
|
0
|
124
|
January 11, 2023
|
|
Build a dynamic list of UPDATE statement values in SQL server
|
|
1
|
162
|
January 11, 2023
|
|
Use table from another instance
|
|
0
|
200
|
January 5, 2023
|
|
How to retrieve date for main ID depending on absence previously occurring id in other column?
|
|
8
|
224
|
January 5, 2023
|
|
How to list sum of values in the specific period
|
|
12
|
4021
|
January 4, 2023
|
|
Trying to group transactions by customer and variable date range
|
|
2
|
582
|
December 30, 2022
|
|
SQL dates comparision
|
|
4
|
292
|
December 29, 2022
|
|
Calculation in Query returns 0
|
|
3
|
253
|
December 29, 2022
|
|
How to return unique rows but in addition all columns
|
|
1
|
201
|
December 29, 2022
|
|
How to add sum,convert and datepart to Union
|
|
3
|
175
|
December 29, 2022
|
|
Sql - presentage from total
|
|
1
|
192
|
December 29, 2022
|
|
Return true/false based on criteria
|
|
2
|
179
|
December 28, 2022
|
|
Trigger for automatically date
|
|
4
|
223
|
December 27, 2022
|
|
Looking for smart algorithm or function?
|
|
3
|
187
|
December 22, 2022
|
|
Strip characters from text stored as binary image
|
|
1
|
161
|
December 22, 2022
|
|
I am stuck with the below sql code please help
|
|
4
|
194
|
December 22, 2022
|
|
Show the last call made prior to escalation
|
|
2
|
298
|
December 22, 2022
|
|
How to select records when table includes multiple rows for each record with multi-criteria
|
|
10
|
262
|
December 22, 2022
|
|
Total amount withdrawn by a customer query on highly active endpoint
|
|
7
|
347
|
December 21, 2022
|
|
How to activate trigger by taking any input from user?
|
|
1
|
127
|
December 21, 2022
|
|
SQL statement (including dates)
|
|
1
|
130
|
December 21, 2022
|
|
Need to find out tables
|
|
3
|
240
|
December 20, 2022
|
|
Embadded Select in another Select and using apostrophes / quotes
|
|
1
|
147
|
December 19, 2022
|
|
Conversion failed when converting the nvarchar value 'ALFKI' to data type int
|
|
1
|
887
|
December 19, 2022
|
|
Design a procedure that lists orders placed by customers with a customer name that includes externally entered characters
|
|
2
|
219
|
December 19, 2022
|
|
Combine two tables to create a table or view showing which coords are inside which polygons
|
|
2
|
417
|
December 17, 2022
|
|
Select newest record based on 2 criteria/groups
|
|
1
|
145
|
December 16, 2022
|
|
Calculate Daily/Monthly Energy consumption in SQL Server
|
|
2
|
1660
|
December 16, 2022
|