Viewing 15 posts - 16 through 30 (of 13,838 total)
Are you requesting an article? Because that's the forum you're in.
Or simply regurgitating a load of AI-generated waffle?
May 20, 2025 at 12:22 pm
thx phil, can they go deeper than 1 level? i mean the folders.
I just set up five levels, and there's no end in sight, so that's a resounding 'yes'.
May 20, 2025 at 7:08 am
OK, so all of the steps need to be configured as 'On failure: go to the next step'
Your final step should be one which collects details of any execution errors...
May 19, 2025 at 12:13 pm
Do you want the job to fail immediately, and stop, in the event of failure of any steps? Also, you want the e-mail to come from SQL Agent itself, is...
May 16, 2025 at 11:17 am
Yeah I did know we can do that but was hoping to understand more about why it is happening because some records are null and some are the blank...
May 13, 2025 at 12:58 pm
I really don't know. But for a quick fix, you could try
select NULLIF(cast(col as varchar(128)),'') as column_name
May 13, 2025 at 12:06 pm
OK. The source is SQL Server and it's a simple query?
SELECT col = cast(x as VARCHAR(50)) FROM tab1
sort of thing?
May 13, 2025 at 11:50 am
What is the target? SQL Server, Excel, CSV, ...
May 13, 2025 at 11:45 am
Thanks to all. I adapted Steve's code and it seems to work correctly. Now all I have to do is figure out how to use it in C#/LINQ!
Simple answer:...
May 12, 2025 at 7:55 am
They're called folders and what you suggest is now possible, even with just Pro, as far as I can see:
May 9, 2025 at 1:11 pm
That's me told. My 6,000 points arise mainly from answering QotD, but apologies for supplying everything in the wrong order and in the wrong format. I'll try to do...
May 9, 2025 at 1:05 pm
Also inexpertly provided. In future, please help others by providing your data in consumable format ... ie, one which can be pasted straight into SSMS. With nearly 6,000 points, you...
May 9, 2025 at 11:35 am
Nice question, but how about also giving us some consumable sample data to test with?
May 9, 2025 at 9:56 am
Can you mock up two or three rows of source data, along with an idea of what the 'parsed' results will look like?
You mention having XML stored in SQL Server,...
May 8, 2025 at 2:42 pm
Migrating your SSRS reports to Power BI Paginated reports is straightforward & sounds like a better solution to me. Or are you staying away from Power BI?
May 7, 2025 at 1:20 pm
Viewing 15 posts - 16 through 30 (of 13,838 total)