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