Viewing 15 posts - 6,586 through 6,600 (of 9,715 total)
Craig Farrell (1/31/2011)
In T-SQL, you'll build a staging table that holds all of the columns/rows.
This can be done in SSIS as well, and might be easier than the SSIS...
February 7, 2011 at 7:30 am
No. You need to look into error checking and rollbacks. Without that, your transaction code is incomplete.
Technically speaking (ACID test talk), if the statements fail due to syntax or server...
February 7, 2011 at 7:28 am
What types of login are the users using? SQL Server or Windows Auth?
If Windows, is user 1 actually logging out of the system when user 2 tries? Or are...
February 7, 2011 at 7:24 am
I would use the dreaded Dynamic SQL to build your email. Embed the whole proc and arguments into the dynamic sql, adding in the proper name, then execute it.
Depending on...
February 7, 2011 at 7:19 am
There are multiple types of snapshots in SQL Server. Please clarify which type you're referring to.
February 7, 2011 at 7:16 am
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
Viewing 15 posts - 6,586 through 6,600 (of 9,715 total)