Topics
Started by
Posts
Last post
(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 my…
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
I'm having issues using the xml value method to convert an XML COlumn to values and the answers I'v…
2 replies
Why is this not working? Field 'EmpNo' not contained in either an aggregate function or the GroupBy…
2 replies
Hi, In order to avoid redundant rows, I have to make the following changes to my SQL code : …
7 replies
Not looking for any code, just ideas. I have a series of queries which run regularly, which return …
10 replies
I have a table like below: CREATE TABLE #Test (Category_ID INT, [Type] VARCHAR(2),Student_ID INT, S…
3 replies
Hello, Looking for help combining two interval tables together. The tables are pretty simple... Ta…
5 replies
Viewing 15 topics - 316 through 330 (of 1,544 total)
You must be logged in to create new topics.