Splitting a group up into multiple groups using a score for how many times an item should appear in…
3 hours, 39 minutes ago
By: Rob Reid-246754
Please assist in transforming this mysql code to tsq please?
2 days, 7 hours ago
Is the SQLCMD.exe supposed to be installed when SSMS is installed on a workstation?
I've been t…
4 days, 6 hours ago
I have a peculiar problem I am trying to find a solution to. We have developed a process …
4 days, 16 hours ago
I am designing one query where I have to convert the value from one currency to another. The…
5 days, 5 hours ago
What is the best way to sort a query based on defined priorities in another table.
I have my…
1 week ago
(select STRING_AGG(cg2.ind_name, ', ') within group (order by cg2.ind_id)
from dbo.ind_lp cg2 with…
1 week, 4 days ago
By: Phil Parkin
I'm working on improving my knowledge of query optimisation and reading execution plans. I'm u…
1 week, 5 days ago
I wonder if I can select multiple domain based attributes for one member record and if so, …
Need help with query. I want the output to be display in single row. We have 2 rows for each ID for…
2 weeks ago
By: SQL Server
I have a problem with email sending via SQL Server. I need to count the number of minutes i…
2 weeks, 6 days ago
By: Jeffrey Williams
Have a requirement of case , pagination in Order by clause. It looks something like this. But getti…
3 weeks, 4 days ago
I have this query. I am trying to understand why I have to GROUP by all of the fields in m…
By: jcelko212 32090
Hello, I would like to minus from rows. 'Other Cost' minus the rest of the rows.
select 1 Period,'M…
Im breaking my head on this. It runs in 2 ms but just has high reads n cpu sometimes. What can be d…
By: The Dixie Flatline
Viewing 15 topics - 1 through 15 (of 1,249 total)
You must be logged in to create new topics.