Viewing 15 posts - 1 through 15 (of 58 total)
Wow that's very useful, thank you Jeffrey!
December 16, 2020 at 9:31 am
Thanks Jeffrey. I should have been more clear - when I said I use the packages in jobs I meant that I am running them in SQL Server Agent Jobs. ...
December 15, 2020 at 9:01 pm
Thanks for the help guys. For some reason I thought I was running as admin since I'm logged in to an administrator account in Windows, but of course it's required...
December 15, 2020 at 8:15 pm
As a thought, rather than handling this in SQL, could you handle this in your import or export tool? Instead of having multiple "footer" fields, could you concat them...
April 17, 2020 at 8:50 pm
Dynamic SQL should work though, but you will want to be VERY careful with that. It would be possible for someone to do SQL injection attack doing that. I've...
April 17, 2020 at 8:42 pm
Well I have no sample data so that was a stab in the dark. Makes sense though! Maybe more iif's
Sorry about that. Here's sample data. Since as I mentioned...
April 17, 2020 at 8:33 pm
You could build the query using dynamic SQL, that way you wouldn't be referring to columns that don't exist in your query
Thank you - I think this gets to...
April 17, 2020 at 3:13 pm
What about if you break that out into IF statements instead?
Hmm interesting...so it would be a series of nested IF statements?
April 17, 2020 at 3:12 pm
"I'm scraping data ..."
What do you mean by this?
Your query is checking for the existence of columns in tables, and has nothing to do with data.
The scraping I referred...
April 17, 2020 at 3:08 pm
As an update, I've now done the SQL Server 2008->2014 upgrade in Windows 7 and then the Windows 7 to Windows 10 upgrade (keeping files and apps). All went well,...
October 31, 2019 at 3:33 pm
<li style="list-style-type: none;">
- script out credentials for the instance:
https://www.mssqltips.com/sqlservertip/5805/script-out-sql-server-credentials-and-proxies/
<li style="list-style-type: none;">
When I execute the script to get the proxies from sp_help_proxy in SQL Server 2008, SSMS...
October 29, 2019 at 10:55 am
Things to check that you may not realize are stored in the "system" databases:
hope this helps
Yes that is a terrific help, thank you Chris. I had been wondering how...
October 28, 2019 at 4:25 pm
In the event you don't have many custom objects in the system databases (hopefully this is the case), it may be better and safer to just script out re-creating...
October 28, 2019 at 11:40 am
Thanks so much for the replies folks and to bmg002 for the very helpful step by step guide. Yes it is just a testing/development box.
October 26, 2019 at 8:45 am
Thank you all very much indeed!
April 18, 2019 at 8:13 pm
Viewing 15 posts - 1 through 15 (of 58 total)