Viewing 15 posts - 286 through 300 (of 382 total)
Sorry, forgot to mention that the instances are on different servers.
And all I am doing is moving data from server1.instance1.table to server2.instance2.table
Sorry about the confusion.
Fraggle
October 31, 2008 at 11:35 am
Well that is a start. That gets me all of the column headers. Now how to I get the properties for all of those columns and expoert those...
October 27, 2008 at 2:42 pm
Seth,
Sorry, I missunderstood your post. I though you were also talking about the attendies only being from Florida and how you were disappointed with that. Now that...
October 26, 2008 at 11:19 am
Didn't realize that Jack. Thanks for the clarification.
Fraggle
October 26, 2008 at 11:16 am
Pretty sure this isn't a Florida only forum. However, to my knowledge, SQL Saturday are Florida only. It does have similar counter parts in other states that go...
October 26, 2008 at 10:22 am
I am sorry you missed Steve Jones. But don't worry that you missed Jack. I could hear someone snorning in the next room throught the concrete walls. ...
October 25, 2008 at 8:43 pm
Jeff,
Alright, now that I have had a little time to ponder the imponderable as my dad would say, I figured out how to add X number of business days to...
October 24, 2008 at 7:10 pm
No, I hate it, but there are times where 1) you can use nothing else or 2) you are on such a time crunch, you do it to get it...
October 22, 2008 at 9:36 pm
Actually, I figured it out about an 30 minutes before the end of the day today.
SET @StartDate = getdate()
SET @EndDate = @StartDate + 15
SET @BizDays15 = (SELECT (DATEDIFF(dd, @StartDate, @EndDate)...
October 22, 2008 at 6:42 pm
Jeff/Forum,
I love the simplicity of the function, and the fact that it does return the number of business days between two dates. However, what if I needed to...
October 22, 2008 at 9:22 am
Thanks Jeff. I am sure I will be here even more using the reference from this site even more than before.
Fraggle
October 16, 2008 at 11:32 pm
So funny story. The very next day, I was offered a position as a SQL Server 2005 Developer/Analyst/Administrator. 45/45/10% work respectively. I figured it was a good...
October 16, 2008 at 6:41 pm
It wasn't the typing that was the issue. It was the phone call I took while replying that caused the performance issues. 😀
Fraggle
October 3, 2008 at 9:26 am
Always love when I post and while I am writing someone else post the same thing. LOL.
Fraggle
October 3, 2008 at 7:32 am
Viewing 15 posts - 286 through 300 (of 382 total)