Viewing 15 posts - 241 through 255 (of 5,111 total)
It doesn't seem odd at all that you can't iterate through an undefined list of variables to me, if I'm honest. Scalar variables are defined as being individual values; they...
February 7, 2022 at 10:42 am
So you have 2 variables per table, 1 for the table name, one of the success? Then yes, you're going to need to update the script each time. Why not...
February 7, 2022 at 9:33 am
Just a test here... did anyone get an email notification of this post?
I got it, and I haven't been here in months. 😉
February 3, 2022 at 2:58 pm
I will admit, it "smells" a little like the left hand not talking to the right hand. I wonder if they would accept a PR on the documentation that links...
December 24, 2021 at 9:52 am
As I mentioned in my post the links are there but unless you have an active subscription you cannot download it.
Seems that they've put it behind a sign-in wall...
December 23, 2021 at 2:51 pm
you can download the older versions - see https://visualstudio.microsoft.com/vs/older-downloads/
I must admit, it really annoyed me how much they hid the old installs away; took me ages to find the...
December 2, 2021 at 10:59 am
So here I am with a new laptop, forced to download the latest version that does not support one of the core functions I perform at my work.... I...
December 2, 2021 at 10:54 am
One (stupid) idea. Use RAND with a seed, to create a known "random" number, convert that to a Hex value and then use that.
For example, take the following SQL:
November 18, 2021 at 5:19 pm
You spoke about Sand Dance early on. I've never been able to get this to work in Linux, so I can't count this as a positive. Unless someone else has?
November 18, 2021 at 4:16 pm
You have a very good vendor.
I've, personally, found that most are happy to accommodate if you reach out. I find more that people aren't willing to try asking, but...
November 17, 2021 at 2:59 pm
Good answer. Sounds like you've had to deal with this stuff before!
Yep, however, the answer for me was to talk to the vendor, who was more than happy to...
November 17, 2021 at 11:31 am
Sounds like it's encode problem, if I am honest. Perhaps, for example, you're opening the file expecting it to be encoded in UTF-16 and it's actually in ANSI-1252 or UTF-8....
November 17, 2021 at 9:57 am
Instead of concat could it show values in separate fields for the value of different tests?
example:
Oxygen_Value Diameter_Value
Thanks.
Sounds like you want a dynamic pivot now. Like asked for earlier, if...
November 11, 2021 at 2:20 pm
Honestly, I doubt you'll see the extension until after SQL Server 2022 starts hitting public preview, or even not till after it's released. The SSIS extension for Visual Studio 2019...
November 10, 2021 at 3:41 pm
It's creating both a UNIQUE CONSTRAINT and a UNIQUE INDEX. Firstly, this means that 2 (or more) rows cannot exist with the same values for the columns specified; in this...
October 28, 2021 at 4:15 pm
Viewing 15 posts - 241 through 255 (of 5,111 total)