|
Sql stored procedure to select top 1 from multiple tables and update 1 table in one query
|
|
1
|
341
|
January 12, 2023
|
|
Group By or CTE?
|
|
5
|
209
|
January 12, 2023
|
|
How to Insert Fixed Date into Excel Header
|
|
5
|
450
|
January 11, 2023
|
|
MS SQL Express install issues
|
|
0
|
126
|
January 11, 2023
|
|
Build a dynamic list of UPDATE statement values in SQL server
|
|
1
|
168
|
January 11, 2023
|
|
Use table from another instance
|
|
0
|
201
|
January 5, 2023
|
|
How to retrieve date for main ID depending on absence previously occurring id in other column?
|
|
8
|
226
|
January 5, 2023
|
|
How to list sum of values in the specific period
|
|
12
|
4094
|
January 4, 2023
|
|
Trying to group transactions by customer and variable date range
|
|
2
|
599
|
December 30, 2022
|
|
SQL dates comparision
|
|
4
|
297
|
December 29, 2022
|
|
Calculation in Query returns 0
|
|
3
|
254
|
December 29, 2022
|
|
How to return unique rows but in addition all columns
|
|
1
|
202
|
December 29, 2022
|
|
How to add sum,convert and datepart to Union
|
|
3
|
178
|
December 29, 2022
|
|
Sql - presentage from total
|
|
1
|
196
|
December 29, 2022
|
|
Return true/false based on criteria
|
|
2
|
180
|
December 28, 2022
|
|
Trigger for automatically date
|
|
4
|
224
|
December 27, 2022
|
|
Looking for smart algorithm or function?
|
|
3
|
193
|
December 22, 2022
|
|
Strip characters from text stored as binary image
|
|
1
|
163
|
December 22, 2022
|
|
I am stuck with the below sql code please help
|
|
4
|
195
|
December 22, 2022
|
|
Show the last call made prior to escalation
|
|
2
|
302
|
December 22, 2022
|
|
How to select records when table includes multiple rows for each record with multi-criteria
|
|
10
|
267
|
December 22, 2022
|
|
Total amount withdrawn by a customer query on highly active endpoint
|
|
7
|
348
|
December 21, 2022
|
|
How to activate trigger by taking any input from user?
|
|
1
|
128
|
December 21, 2022
|
|
SQL statement (including dates)
|
|
1
|
130
|
December 21, 2022
|
|
Need to find out tables
|
|
3
|
241
|
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
|
888
|
December 19, 2022
|
|
Design a procedure that lists orders placed by customers with a customer name that includes externally entered characters
|
|
2
|
220
|
December 19, 2022
|
|
Combine two tables to create a table or view showing which coords are inside which polygons
|
|
2
|
421
|
December 17, 2022
|
|
Select newest record based on 2 criteria/groups
|
|
1
|
145
|
December 16, 2022
|