what's the datatype of the destination table?

if the destination is INT or DECIMAL(10,0) you would loose everything to the right of the decimal point due to implicit conversions.

the minimum size...

lots of stuff doesn't look right here.

if you EVER call that proc more than once, it will fail because it creates a permenant table, but never drops it.

depending on how...

anjaliv (7/13/2011)

---

Lowell's solution worked. Thank you!

I am creating a table in a stored procedure I have written. But when I call it from the above query, it returns an error...

are you concatenating strings, and one of them is null?

you know the old SET @string = Firstname + ' ' + LastName,

where ofirstname might be null or something?

that's good news! i was also either a hardware /100%CPU pegged issue, or thinking maybe somebody dropped the indexes in the database, if everything was running slow would be the...

well it depends on your proc whether will work correctly or not, but you can call the proc via a 3 part naming convention, and explicitly naming the database and...

the general, wave of the hand, "it's all slow" is really hard to pin down.

One of the first places i'd look is statistics. updating at a minimum the statsitics of...

if that server has the SSMS tools installed with SQL 2005, you'll see that issue;

it's the GUI that decides to show the missing indexes, even though they might actually exist...

is the new 2008 server an express version? is it a defaul instance or a named instance?

have you been able to connect to it before?

have you eliminated any networking issues...

the error's pretty clear. the temp table you are inserting into doesn't match your select *.

either create a table explicitly for your select *, or you have to identify the...

what a great job posting everything we might need; thank you for the actual execution plan!

i see a few places where the statistics are a little off; usually an order...

also express editions don't accept allow remote connections by default; you'll need to right click on the server in SSMS, go to Properties,a nd then Connections:

is there a clustered index, maybe on customer_id? can you give us the actual CREATE TABLE definition so we don't have to guess?

the actual execution plan, saved as a .sqlplan...

post the actual execution plan you looked at and let us peer review it with you;

trying to guess at performance from pseudo code won't get much other than guesses.

what are...

i ran the provided data thru my data formatting macro so we can have sample definitions, but we are still waiting for indexes and actual execution plan, which will tell...