After installing VS2022, go to Extensions and install the

SQL Server Integration Services Projects 2022

extension. That should get you going.

Because it's a CROSS JOIN, but I only want to subtract...

• This reply was modified 1 year, 9 months ago by Phil Parkin.

Well, if REPLACE(e.eligibility_ud,'-01','') is a very common operation in your system, you could create it as a PERSISTED COMPUTED column.

You could also see what happens if you replace that inner...

You could create a database project in VS and then import the database structure into that. Doing so will create the individual files you need (though not with IF EXISTS...

Given your >13,000 points, I need to confirm with you whether this is a joke?

Actually  i want  to do  sum of qty in subitem_id 203 and 299 and subtract it form item_id 103 group by item_id.

OK, based on this description, try this

            
February 5, 2024 at 12:08 pm
            
#4373534

            
            
                                                
        

Nice try, but there are a few issues.

1. You have not included a CREATE TABLE, but I was able to get that from your proc definition a few posts earlier

...

I tried pasting that into SSMS and hitting F5, but got a parsing error.

You clearly have not taken the time to read the article to which Jeff directed you. Or,...

This expression will do that:

right(F,3) == "\" \""? replace(F,"\" \"","\""): F

OK, just to be clear, are you saying that you want to change this

"1234-28" "

to this

"1234-28"

?

Still using SSMS 18.x since my second most important Addon (besides Redgate SQL Prompt) with the name SSMSBoost seems to be deprecated and there is no version that works...

Note also that there is a difference between an empty string ("") and NULL.

Please try this:

REPLACE( F , "\"", "" )

Once again, if you want coding assistance, please provide consumable sample data for us to experiment with.

This semi-join version of the UPDATE might perform better

UPDATE pt
SET LastModifiedDateTime = @dt
FROM PlayersTypes pt
WHERE EXISTS
(
    SELECT 1
    FROM @TableTypePlayersTypes ttpt
...