Viewing 15 posts - 106 through 120 (of 1,415 total)
JEFF Do NOT go all SSIS on me 🙂 we all know it's Bulk insert with a formatfile or openrowset
Jeff's blood pressure just went up a notch...
January 31, 2020 at 4:10 pm
Phil, those are excluded from conversion...I'm just showing what is in the data. The only ones that would be converted would be the numbers with E+ in it. This...
January 30, 2020 at 7:56 pm
Yep. Another vote for ping. If you can't see it in your network, you can't connect to it. Also, when you ping, be sure to specify a...
January 21, 2020 at 10:18 pm
Yep. Another vote for ping. If you can't see it in your network, you can't connect to it. Also, when you ping, be sure to specify a port number...
January 21, 2020 at 9:12 pm
I have a question about the code being posted:
So you run an update, and if no rows were updated (reading @@rowcount), then you do an insert. What happens...
January 20, 2020 at 8:13 pm
I have a question about the code being posted:
So you run an update, and if no rows were updated (reading @@rowcount), then you do an insert. What happens if between...
January 20, 2020 at 7:42 pm
Good one!
The problem is that casting to int always removes any decimals, and with the example, 0.289 is actually stored as a value which, when converted with the maximum...
January 16, 2020 at 2:05 pm
Password managers are not a good idea. Sure, they let you use all the crazy random passwords per site, but they represent a single point of vulnerability. Hack them...
January 15, 2020 at 8:19 pm
Ooooo... interesting and very timely subject for me, Patrick. Do you have any favorite links on the subject of pulling rather than pushing?
I'll have to look. It's more...
January 10, 2020 at 4:04 pm
Do you have any favorite links on the subject of pulling rather than pushing?
Hmmmm ...
Nah thought I had one but no luck retrieving it.
I get better luck...
January 10, 2020 at 4:02 pm
Do you have any favorite links on the subject of pulling rather than pushing?
Hmmmm ...
Nah thought I had one but no luck retrieving it.
I get better luck when just...
January 10, 2020 at 2:21 pm
Accounting entries are not properly classified simply by a + or - sign. Nearly every financial event in a company ultimately effects some type of accounting entry. An employee taking...
January 10, 2020 at 11:30 am
Trying to trace some of this through cans ugly so putting the offsetting reversal "near" the transactions they are intended to reverse seems to make the reporting and tracing...
January 10, 2020 at 11:15 am
So can you do this or can't you? The ONLY question you have to ask, is if the OP's design allows negative numbers. If the OP NEEDS to...
January 9, 2020 at 10:24 pm
Good luck with that. Not sure third party tools make this better, but you're welcome to eval SQL Backup from Redgate if it might help
Is Redgate backup able to...
January 9, 2020 at 10:18 pm
Viewing 15 posts - 106 through 120 (of 1,415 total)