Steve Jones - Editor (8/19/2010)

I need to install it and play with it. Haven't done it so far since I...

You know, the people that help out here are all un-paid volunteers, so please HELP US HELP YOU. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables...

I would suggest:

1. Using a Common Table Expression (CTE), get all the values of the table. Utilize the row_number function to assign row numbers to each row, starting at one...

I don't think you need to worry about using SSIS - you can drastically speed this up in T-SQL.

First, make this change to the first 3 functions to quickly create...

I would suggest adding the email addresses to a temp table, then do the update by joining on that.

i.e.

CREATE TABLE #tempEmail (EmailAddress varchar(100))

INSERT INTO #tempEmail

SELECT 'asdf@snarf.com' UNION ALL

SELECT 'qwerty@reddit.com'...

Attn: all User Group presentation coordinators. I've been working on converting my article on Comparing Table Variables with Temporary Tables[/url] into a presentation. If you're interested in having me do...

CirquedeSQLeil (8/17/2010)

I find out who did it...

CirquedeSQLeil (8/13/2010)

Brandie Tarvin (8/13/2010)

CirquedeSQLeil (8/13/2010)

Gianluca Sartori (8/12/2010)

Paul White NZ (8/12/2010)

David Benoit (8/12/2010)

I haven't had a...

jcrawf02 (8/12/2010)

You can do this with a single query only if you're...

I thought that to use a configuration file, that you had to specify it in the SSIS package itself? I thought that was how it knew to load it.

You are going through a very rough way of doing this.

I'd not worry about the system databases. Instead, I'd worry about the data in them that is needed to bring...

I agree. Makes me wonder if this might have been something that was discovered in one of the older versions of SQL... 6.5/7 and you know how people hang on...

You know John, the people that help out here are all un-paid volunteers. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables affected, and INSERT statements to...