> In our case, it messed us up because SSDT is whitespace sensitive and was trying to find a column with that name, including the space at the end. Since one was not found, it was throwing a build exception. But then after testing, the code ran fine, only to realize this behavior. So in order to get a successful build, the space needs to be removed, even though the code itself is valid and working.
Meanwhile, in low-key news of only minor significance, it seems Russia is going to announce tonight it will annex four regions of Ukraine, and change the status of the Special Military Operation, potentially to an Anti-Terrorism Operation, which would allow at least partial mobilization of reserves, and some moves to a wartime economy.
SSDT is based on a very old version of SQL Compare (Redgate). It didn't get any love for several years. They are now porting it into ADS, and it's called a "database project".
@PaulWhite Beef was still involved, let's not get too crazy. I used eggs to make meatballs, wrapped in bacon. Used rice flour instead of wheat. I was able to eat them with the egg in it so that's great news, I can eat high temperature baked eggs now!
@ypercubeᵀᴹ Muscat grapes are delicious; I've had some of that wine before and it's definitely sweet. Hopefully one day I make it there, especially that island :)
i have an sp to delete data from grandchildren tables .
But I need to change the cursor and use a temp table or while loop instead of the cursor. I have tried but was not working can somebody help.
Sp added below
CREATE Procedure spDeleteRows
/*
Recursive row delete procedure.
It deletes all r...
@Charlieface it's your post, do what you like with it. The edit you objected to has been removed. Continue as if it hadn't happened. Don't know how to communicate this point more clearly
I'm actually curious to see if chat does become read-only during this work. Doesn't often happen that way
> "Important: Cumulative Update 31 is the last cumulative update for Microsoft SQL Server 2017. SQL Server 2017 is transitioned to extended support after October 11, 2022." 😥
Five years gone just like that
@ErikDarling I regret searching for that reference
i have an sp to delete data from grandchildren tables .
But I need to change the cursor and use a temp table or while loop instead of the cursor. I have tried but was not working can somebody help.
Sp added below
CREATE Procedure spDeleteRows
/*
Recursive row delete procedure.
It deletes all r...
