Mike,

Read the link. It is an article on how to post a good forum thread so that we are able to help you more effectively. If you...

Search this site for 'split' and you'll find a number of split functions.

pvnlaks.mscis,

What makes your problem similar? Are you having problems with the FTP part or the XML part? I would suggest starting yourself a new thread with a...

The first question I'd ask is, can you import the data directly into Oracle using Oracle utilities? When I worked with Oracle, there was a utility called SQL*Loader that...

Good solution Lynn. For some reason, I was thinking that the termcd values were not all known, hence the need for a pivot as I was actually thinking of...

DBCC FREEPROCCACHE removes the stored execution plans from cache. I don't think this actually 'frees' memory from the SQL Server process. If you've read otherwise; please post the...

The query to pull back the data with the aggregate values is quite simple.

SELECT Unique_ID, tempcd, COUNT(*)

FROM TableA

WHERE calldate > DATEADD(dd,-7,GETDATE())

GROUP BY Unique_ID, tempcd

It looks, though, like you...

Mike,

Here's a good link that'll help you get better help with your questions.

http://www.sqlservercentral.com/articles/Best+Practices/61537/

This may be a silly question, but does the Addresses table have an IDENTITY column?

Enterprise Manager is not a user tool. It is an administration tool. Don't give a plain-Jane user EM.

SQL Server will grab as much memory as it can (up to the sp_configure 'max server memory (mb)' setting). It will not release it without re-starting the service. ...

You must drop the FK and then add it again after the TRUNCATE.

What Antonio has posted is as good of an answer as you'll get without us knowing more about your tables. Since you're a new poster, check this link out...

Or, you could use QA and run a sp_configure:

sp_configure 'max server memory (MB)', 1024

GO

RECONFIGURE WITH OVERRIDE

Just an observation here, but why not just leave the GUID value alone when you move the row to another table? Wouldn't this help you with relating the data...