Viewing 15 posts - 16 through 30 (of 1,314 total)
The fact that AddressLine has a sequence attribute leads me to believe that multiple address lines are possible.
So I added a sequence="2" node to the XML, before sequence="1". So you...
April 23, 2019 at 8:04 pm
DontSaveSensitive is what I use. All passwords should be provided through configurations.
Preferable some kind of configuration that doesn't leave it sitting there in plain text, such as command-line configuration in...
April 10, 2019 at 4:34 pm
The table is a heap, so there is no guarantee that DELETE TOP 100000 will delete rows in date order. You also may run into issues with the space used...
March 26, 2019 at 1:41 pm
You could create a script source component to handle multiple formats.
In the PrimeOutput method, open the file and read the first row with the column headers. Deduce from...
March 22, 2019 at 1:12 pm
It is possible to do it while only evaluating each condition once.SELECT Results = CASE
WHEN td.OnlyColumnProvided NOT LIKE '%RR%' THEN 'N/A'
WHEN td.OnlyColumnProvided LIKE '%MM%'...
March 22, 2019 at 12:52 pm
I assumed the author intended the INSERT to be a valid statement, for example the Codigo column could be an IDENTITY column. And that the @Contador variable was declared somewhere. ...
March 21, 2019 at 3:50 pm
There is no difference in the underlying value, the double data type is still using the same IEEE standard format with the same number of mantissa bits. The difference is that...
March 20, 2019 at 12:52 pm
I don't know where to start with trying to close another user's Excel app. Even if you tried some dark sysadmin magic to close the process remotely, it's probably going...
March 12, 2019 at 12:20 pm
Instead of using [Sheet1$] as the table name, can you create a named range in the template spreadsheet (starting below the header row) and use that for the table name? ...
March 11, 2019 at 2:44 pm
You need to clarify whether the "INSERT #xml EXEC sp_OAGetProperty" is returning NULL, or whether the table is indeed getting an XML value but "yourXML.value()" results in NULL.
If...
March 11, 2019 at 1:10 pm
So depending on your Management Studio version, some times answer 1 is correct even if the server is SQL 2017? Sounds like 82 of us deserve a point.
March 8, 2019 at 2:39 pm
You can find the second and later versions in sys.numbered_procedures.
Wouldn't this behavior depend on which version on Management Studio you're using, rather than the SQL Server where the...
March 8, 2019 at 11:32 am
You can't create a script task in a data flow. You can create a script component. But if you're using a flat file source, the script component would be downstream...
March 6, 2019 at 12:09 pm
If you create a template Excel file with the desired formatting, and create a named range where you want to write the date, you can use the range name as...
March 2, 2019 at 12:11 pm
The tags were OK, but the XML header said it was UTF-8 and there were illegal characters in it (not in proper UTF-8 encoding).
Specifically the fancy e in efficiënt. I...
February 27, 2019 at 1:25 pm
Viewing 15 posts - 16 through 30 (of 1,314 total)