The table name can't be a variable in the CREATE TABLE statement, so you'll have to use dynamic sql:

DECLARE @sql varchar(max);

SET @sql = 'CREATE TABLE dbo.' + QuoteName(convert(char(10),'2010-09-02 14:56:09.840',101)) +...

Just to ensure there's no confusion, NUMERIC(19,4) and DECIMAL(19,4) are the same... or as BOL states it

loki1049 (9/2/2010)

---

Thanks Wayne, I will look into that post. I don't want to go into dynamic SQL as I don't think it should really be used. I'm not a fan...

This code will:

1. update any records in the main table that match...

The money datatype is essentially numeric(19,4). To add a fifth decimal place, you'll have to change this to numeric(20,5).

For example:

if object_id('tempdb..#temp') IS NOT NULL DROP TABLE #temp;

CREATE TABLE #temp (MoneyField...

If you have SSRS available, I'd set up a report that is based off of the login, and have each user schedule to run it.

If you want to do this...

SELECT st.name, sip.rows

FROM sys.system_internals_partitions sip

JOIN sys.tables st ON st.object_id = sip.object_id

ORDER BY st.name

Just drop the tables, add them, add the data, add the FKs. 😛 😉 :w00t:

Steve Jones - Editor (9/2/2010)

---

Jas n,

Wh t bo t t s as a p...

Looks like we made today's quote, just figuring out how to do that...

No.

loki1049 (9/2/2010)

---

Is this the only work around? I was hoping for something more straight forward, maybe I'm just expecting too much. This kinda complicates the "All" option as well as...

I don't think you're doing anything wrong. However, it sounds like the last table has a 1>Many relationship, and there are multiple records matching for the join condition.

You either need...

This should handle your insert. Make sure you test it in a transaction first, take appropriate backups, etc.

-- update the existing entries based on the ID column.

UPDATE survey

...

mfowler12 (9/2/2010)

---

WayneS (9/2/2010)

---

mfowler12 (9/2/2010)

---

I was able to import the data by using the DTSWizard. It was on a different drive.

So, how do I link the tables so that the data...