Askquestions - You have been starring at this for far too long, Now note what you entered.

DBA John Bullock J. Bulllock ...

Nothing much to do this evening so I will post your table structure the way you should have done it in order to receive a tested answer.

CREATE TABLE #T (title...

Search Amazon .... Karen Delaneys Inside Microsoft SQL Server 7.0 (Mps)

Hard Cover available as new for 0.01 .. thats right for 1 penny. Plus my search returned 30 additional...

For what it is worth, here is how to return what you desire using T-SQL

SELECT DATENAME (mm ,GETDATE()) + ' ' + CAST(DATEPART (dd, GETDATE()) AS

VARCHAR(2)) + ', '...

Without using SSIS read this for an explanation and sample code.

http://technet.microsoft.com/en-us/library/bb522522.aspx

If you want to use the MERGE statement in an SSIS package refer to:

http://technet.microsoft.com/en-us/library/cc280522.aspx

norbertackerman

You will be likely to get a tested answer if you post the table definitions and some sample data along with expected results following the method given in...

GilaMonster (10/6/2010)

---

Tom.Thomson (10/6/2010)

---

In my experience that is the normal frustration you should expect if you have a "project manager" in the loop who is neither a devloper nor a user...

Steve Jones:

However you're lucky. I've worked in quite a few shops where the DBAs did their own thing, and ignored or did not communicate with developers. I've also seen many...

Just have to throw my 2 cents in and help the count along ....

Now how many members of the thread will be coming to SQL Saturday#60 in Cleveland......

Well you going to tell the rest of us .. how?

Is this what you are seeking?

http://quickfacts.census.gov/qfd/index.html

or here to download a pipe delimited file via FTP

http://factfinder.census.gov/servlet/DownloadDatasetServlet?_lang=en

Might I suggest that you examine the MERGE statement. You can start here:

http://technet.microsoft.com/en-us/library/cc879317.aspx

And then if you have difficulties, repost including sample data, desired results, and the T-SQL statement(s)...

Deleted by poster ....

Try this site see if it helps.

http://connect.microsoft.com/SQLServer/feedback/details/581640/trying-to-use-openrowset-to-import-2003-excel-file-into-64-bit-2008-r2-sql-server

Your experience is most unusual to say the least.

Using Goggle I uncovered 5 or 6 retailers (NOT Amazon).

Selected CDW Direct, excepted a 5 day delivery lead...