I can't speak for others but relational databases aren't going away.  I also love the fact that I don't actually have to write loops in it do to the same...

• This reply was modified 3 years, 7 months ago by Jeff Moden. Reason: Change "are going away" to "aren't going away". Man, talk about phat phingering

Sure I will correct from next by typing the content here and code in code area.

Hi Jeff -I am using third party component which will connect to another third...

Hi All,

I have a requirement to update set of records to an external environtment which is connected via ADO .net

There are set of records in my table which i...

I don't know what you mean by "Feature Flag".  On the SQL side, knowing that is super important.  Databases are the proverbial "Center of the Universe".  If you don't think...

Was the backup it was trying to copy actually finished?  If it wasn't, there's your "sharing violation".

If you try to rename a file to what the current name is and...

I just figured out what line I was getting the error on:

Msg 468, Level 16, State 9, Line 244 Cannot resolve the collation conflict between "Latin1_General_100_BIN2_UTF8" and "SQL_Latin1_General_CP1_CI_AS" in...

I agree... that's a great simplification.  But it doesn't return all the rows with the unique number.

You basically said that you were using "Synapse SQL Serverless Pool".  There are a lot of things...

Yeah... that's just spam for an "Assignment writing" service to help people...

Here's the rendition I came up with.  It produces the same answer as Phil's.  The % of Batch in the Actual Execution Plan says that mine is 27% faster but...

Ok... now that I've read the post that I missed, I've added 'P6' to the list of PartNumbers with all '2's for 3 entries to test.

--Add 'P6'...

the goal mfrom asking question is to get result above without string aggreagte or comma separated suppose i have

p1 1,2,3

p2 2,2,2

both p1 and p2 both have same count and...

I still want to know why the OP wants to avoid the STRING_AGGREGATE() function.

I work with what I consider a large number of third party databases.  I still troubleshoot poorly performing queries.  I now have DBA acquaintances at those companies and they...

I can't...