Viewing 15 posts - 226 through 240 (of 432 total)
If the second table has a trigger that writes to itself, what would stop it running to infinity if it didn't error out at 32?
When the trigger does not generate...
August 1, 2022 at 4:00 pm
The easiest approach is a recursive cte. I tried to come up with a non recursive solution. I found one that works with this data, but it makes assumptions about...
July 29, 2022 at 10:20 pm
Whether STRING_SPLIT() works for you is not dependent on your SSMS version. Instead, it depends on the version of SQL Server engine you are running against and the Compatibility...
July 28, 2022 at 9:23 pm
Need the sample data in a directly usable format, not in a picture, which we can't write T-SQL against.
Show me how to make this better, if you don't mind....
July 28, 2022 at 5:34 pm
I don't fully understand what you're saying, but have you tried using a for each loop based on the values of an SSIS object variable? Typically this is used for...
July 25, 2022 at 9:09 pm
or a script task with a Thread.Sleep().
Cheers for that. I assumed there was a better way of adding a delay, but never looked into it.
July 25, 2022 at 3:52 pm
- How do you get the package to automatically try the failed file again?
- Do I need to set the MaxErrorCount on the Data Flow or the Package?
I put...
July 25, 2022 at 3:03 pm
If your query contains Team = 'Illinois', those are the only rows that will be evaluated.
Lag(Score,1) over ORDER By Score) will give you the next lowest score, regardless of team...
July 22, 2022 at 9:50 pm
If it is in a for each loop, you can make it try again on failure.
There are instructions here: https://www.mssqltips.com/sqlservertip/3575/continue-a-foreach-loop-after-an-error-in-a-sql-server-integration-services-package/
The key points are:
July 22, 2022 at 6:14 pm
You can definitely set up a single column source and create a derived column based on the first two characters and then do the conditional split. I believe you can...
July 21, 2022 at 4:01 pm
Does this do what you need?
UPDATE a
SET a.Value1 = b.Value1,
a.Date1 = b.Date1
FROM Table2 AS a
JOIN...
July 21, 2022 at 1:51 am
Not sure what you mean "Please correct the script so that it has the right columns with the right data"
.
I meant correct any mistakes I may have made in...
July 20, 2022 at 10:37 pm
I had a go at creating some sample data based on your text files dumps. Please correct the script so that it has the right columns with the right data,...
July 20, 2022 at 9:03 pm
The first suggestion was to explicitly cast or convert the Report column to xml or to try varchar/nvarchar. Have you tried that? Does something like this work? or give a...
July 19, 2022 at 10:42 pm
why its geting data from dbo table but not from user1?
The previous statement about schema scope was incorrect, the user default schema is ignored. The compiled code first looks...
July 19, 2022 at 3:19 pm
Viewing 15 posts - 226 through 240 (of 432 total)