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...

I stand to be corrected, but the pattern appears to be as follows

• P1 is the only PartNumber that has PartValue in (1,2,3,4), therefor has its own UniqueNumber

...

If that's true, then you might have to apply the COLLATE clause.  See the following search for more information.

https://duckduckgo.com/?q=COLLATE+(Transact-SQL)

Hello Community,

When I execute the attached code I get the following error:

Implicit conversion of varchar value to varchar cannot be performed because the collation of the value is unresolved...

Don't be so sure.  We had a similar problem with a "wonderful" web service that someone...

@Grant ,

Awesome... I don't know how you...

so, hypothetically, I am the boss. I used to be technical; but that was long time ago. I am responsible to the users for the performance of the application...

I'm in the same boat.  Why would P4 have the same "unique" number as P3 and P5 have the same "unique" number as P2??  I'm just not seeing your "pattern"...

Do you have an example where the master data doesn't equal the imported data?  If so, please don't post it as a graphic... post it as readily consumable data.  One...

Other than my "fun" response above, the reason why I study it all is because of two things.

1. I work with huge numbers of rows and I don't ever want...

Do NOT let users have direct access to xp_CmdShell...  Write a stored procedure that uses xp_CmdShell with the correct proxy and EXECUTE AS OWNER in the proc.

NEVER EVER let users...

Why bother?  It's funny... there must be a disturbance in the force because I've been asking myself the same questions a whole lot lately.  For me, it all boils down...

The error always occurs in the Excel Data Source at the start of the data flow.  Only ever there, but which file it fails on is random.   Often it...

Good Morning. I made a view with select in SQL. I need the negative numbers to be in green color, and the positive ones in red when I run...

That's incredibly kind feedback, Zidar.  Thank you very much. I truly appreciate it and, like any author, feedback like yours and the others on this thread helps keep us going.

Shifting...