Viewing 15 posts - 6,601 through 6,615 (of 9,725 total)
Lowell, that's brilliant code. Even though this wasn't my question, I may have to keep your solution in my SQL files for future reference. @=)
February 7, 2011 at 7:12 am
I am curious, though. Why would anyone burn data files on DVD? There are more reliable and much better storage options available that allow for bigger files. These options will...
February 7, 2011 at 7:10 am
1) Only pull the columns and rows you need from the source (instead of everything). -- In other words, Filter, Filter, Filter.
2) Run the package when little-to-no other traffic or...
February 7, 2011 at 7:06 am
FYI: Port 1434 is the default UDP port.
On my local box, I have two Dev servers installed (2k5 & 2k8). Looking at my SQL Server Configuration Manager, both servers have...
February 7, 2011 at 7:01 am
karthikeyan-444867 (2/6/2011)
I have installed sql server 2005 in my home machine. when i open management studio, it is prompting to choose the server name (By default nature). I didn't create...
February 7, 2011 at 6:48 am
anilkullam, as this is an old thread, you are more likely to get assistance if you start your own new thread and use english to ask the question instead of...
February 7, 2011 at 6:45 am
We can't see (or at least I can't) your tables. Can you repost?
EDIT: Please post table DDL (the create scripts with all keys and indexes). Pictures don't help us help...
February 7, 2011 at 6:39 am
As Jeff said, post both queries (with comments on what each is supposed to do) so we can help you combine them together or offer other advice.
February 7, 2011 at 6:39 am
Hugo Kornelis (2/7/2011)
Toreador (2/7/2011)
I wonder why they are withrawing this procedure?
If I have to make a guess, it is probably because over the past years, there has been a consistent...
February 7, 2011 at 6:34 am
Toreador (2/7/2011)
I always use sp_change_users_login in these circumstances...
Ditto. I did get the correct answer, but that's not been my first choice of resolution in these instances.
Toreador (2/7/2011)
February 7, 2011 at 6:32 am
If you have any IT experience at all, the certs are iffy as to whether or not they'll help you get the job. If you have no official IT experience,...
February 7, 2011 at 5:28 am
Craig Farrell (2/4/2011)
StartDate = CStr(DATEADD("m", DATEDIFF("m", 0, Date) -4, +2))
EndDate = CStr(DATEADD("m", DATEDIFF("m", 0, Date) -3, +1))
ReportDate = CStr(DATEADD("m", DATEDIFF("m", 0, Date)-2, +1))
This query gives the...
February 4, 2011 at 12:33 pm
I know you won't get back to this until next week, but I'm posting this before I forget. ActiveX tasks will be removed (or already have been removed) from SSIS...
February 4, 2011 at 12:25 pm
Toreador (2/4/2011)
Brandie Tarvin (2/4/2011)
The trick is that date doesn't actually exist in some countries, including the U.S.
But given that the date does exist in many other countries, SQLServer is completely...
February 4, 2011 at 10:56 am
Viewing 15 posts - 6,601 through 6,615 (of 9,725 total)