Viewing 15 posts - 1,786 through 1,800 (of 13,849 total)
Hi Phil,
yes, I debugged the code and see that when the file with the name FARAN comes the package is down. Looks like this code doesn't work good.
Did you...
October 31, 2021 at 12:38 pm
To improve efficiency, I'd suggest you add columns to your data to track DateCreated and DataModified.
What is the reason for using XML in the data transfer?
Why do you want to...
October 31, 2021 at 12:36 pm
That's true, Phil... but I don't keep the results of Dynamic SQL in source control. I don't keep the code that gets stored in cache that I interrogate with...
October 28, 2021 at 4:35 pm
It's algebra which could be directly calculated, no?
1555201/2^x=800
2^x=1555201/800
log10(2^x)=log10(1555201/800)
x = log10(1555201/800) / log10(2)
x=10.92481343
The number of times it would need to be "applied" before it crossed the 800 barrier would be...
October 28, 2021 at 1:35 pm
Michael L John wrote:I'm with Phil. Why are you doing this?
I can't speak for Ron but sometimes it's necessary to see, for example, the full monty for dynamic SQL.
Presumably you have...
October 28, 2021 at 8:35 am
Is this a SQL Agent job, or something else?
October 27, 2021 at 6:20 pm
May I ask why you are doing this? There are other tried & tested ways of generating DDL.
October 27, 2021 at 3:59 pm
Phil - that helps limit each printout to 4,000 characters but in my case the string is 11,698 so it breaks it into three separate lines. The script I'm...
October 27, 2021 at 3:50 pm
Here is one way.
DECLARE @x TABLE
(
FileName VARCHAR(50) NOT NULL
,CreatedDate DATE NOT NULL
,FileSendingDate DATE NOT NULL
...
October 27, 2021 at 3:24 pm
Is this the final version, or are you going to continue gradually drip-feeding additional requirements?
If so, please skip to the end and provide the final version now, to avoid wasting...
October 27, 2021 at 2:53 pm
Here is a chunk of code I've used in the past that may help you, where @SQL1 was previously declared as NVARCHAR(MAX).
DECLARE @CurrentEnd...
October 27, 2021 at 2:35 pm
Are you referring to the output generated by the SQL PRINT statement?
October 27, 2021 at 2:23 pm
Scott's solution was correct, with the possible exception of the ordering of results. Here is code to prove it.
DECLARE @x TABLE
(
FileName VARCHAR(50) NOT...
October 27, 2021 at 2:19 pm
Well you could do two sets of replaces, so something like replace all the numbers with a letter first then replace all the letters with the new number 🙂
I...
October 23, 2021 at 11:35 am
Removed
October 22, 2021 at 2:13 pm
Viewing 15 posts - 1,786 through 1,800 (of 13,849 total)