Forum Replies Created

Viewing 15 posts - 1,621 through 1,635 (of 13,874 total)

  • Reply To: C# String.Split() using a multi-character delimiter in a script task

    Single quotes are for chars. Use double quotes for string literals ... it should work.

    February 9, 2022 at 10:55 am

    #3981489

  • Reply To: Does a while loop read all the records in a table? Resolved

    Great. How long does it take on your live table?

    February 8, 2022 at 4:54 pm

    #3981356

  • Reply To: Wondering if it would be better to use UNION when performing inserts

    Thanks for posting the link. I did not know about the 1000-row limit.

    February 8, 2022 at 10:30 am

    #3981284

  • Reply To: Best way to process a large XML file (2MB) or greater

    Have you tried importing a file into a table containing a column of XML datatype and then querying that? I have no idea whether it will be faster, but might...

    February 7, 2022 at 6:50 pm

    #3981173

  • Reply To: Wondering if it would be better to use UNION when performing inserts

    No need for UNION:

    INSERT [PW].[Contract] ([ID],[ProgramID],[PAContractNum],[PAContractAmt],[PAContractStartDate],[PAContractExpirationDate],[CreatedBy],[CreatedOn],[UpdatedBy],[UpdatedOn]) VALUES (1, 8, '15FHBFPP0115', 0.0000, '2014-07-01 00:00:00', '2016-06-30 00:00:00', 'some.person', '2015-02-11 00:00:00', 'some.person', NULL)
     ,(2, 8, '15FHBFPP0102', 0.0000, '2014-07-01 00:00:00', '2020-06-30...

    February 7, 2022 at 4:09 pm

    #3981155

  • Reply To: Accessing variables dynamically

    If your Script Task can access the .DTSX file corresponding to 'itself', it could read the variable names from it. Not pretty and not recommended, but not impossible either.

    February 7, 2022 at 11:21 am

    #3981095

  • Reply To: Refactoring an Entity Attribute Value schema

    Your existing method is probably the most practical. I considered other options and came to the same conclusions as you. I suggest that you stay well away from the XML...

    February 7, 2022 at 10:18 am

    #3981077

  • Reply To: Comparing nvarchar with string has started generating weird conversion error

    Jeff Moden wrote:

    It always happens that way with such "no one made any changes" such things. 😀

    It would be nice if you could post the actual code you're talking about so...

    February 6, 2022 at 5:24 pm

    #3980978

  • Reply To: Does a while loop read all the records in a table? Resolved

    Please take a look at this and see what you think

    DROP TABLE IF EXISTS #LastTimeTankDrained;

    CREATE TABLE #LastTimeTankDrained
    (
        Tank CHAR(2)
       ,LastDrain INT
     ...

    February 5, 2022 at 4:45 pm

    #3980895

  • Reply To: Does a while loop read all the records in a table? Resolved

    What the data represents is confusing me a little, can you expand on it a little, please?

    Take TankDate 1/1/2021 as an example. There are 6 rows, with DrainSeq ranging from...

    February 5, 2022 at 12:01 pm

    #3980874

  • Reply To: Recovering data from a forked database?

    Recovering the missing day's data might not be as difficult as you think. People here will help you.

    Approximately how many tables in the database, in total, are likely to contain...

    February 4, 2022 at 3:07 pm

    #3980741

  • Reply To: Recovering data from a forked database?

    I don't think I'll be telling you anything that you don't already know ...

    If the 'missing' data exists only on the crashed server, you have to wait until the crashed...

    February 4, 2022 at 2:22 pm

    #3980723

  • Reply To: Convert JSON Schema / Format to Schema / Format that can be read from SQL Server

    Glad to help. I learned a few things along the way too.

    If you have more questions, please post back ... it was a good challenge.

    February 4, 2022 at 9:30 am

    #3980631

    • Viewing 15 posts - 1,621 through 1,635 (of 13,874 total)