ColdCoffee (3/23/2012)

---

I find the column name is incorrectly mentioned

Select col1, col2,col3 =

case col3 when > 0.7 then 0.7 else col3 End

That "equals" sign was missing.

Is that it or am...

Have to go with the standard answer here, it depends.

It depends on how your current data in the source system is stored, how it is stored in the target system....

I can't figure out this part. I see a possible missing single quote (') after field2 on the line prior to the EXECUTE.

Why is this dynamic, there is not...

I have a dumb question, why all the dynamic sql when it seems that it all can be run normally (for a better term). I don't see anything in...

SS999 (3/23/2012)

---

One of the source tables have Clusterd index and other table has 1 Unique,Non-clustered and 12 Non-Unique, Clustered indexes. I tried using the estimated execution plan which suggested me...

We will need the DDL (CREATE TABLE statement(s), including INDEX definitions) for any source table(s), some sample data for the source table(s) (a series of INSERT INTO statements) (not a...

My 13 yr...

My staging tables were nothing more than a copy of the source tables. Their sole purpose was a landing place for the data when it was pulled each night...

Have to ask, did you down load the correct version of the sample database? Also, have you gone back to the site where you got the file and checked...

msmithson (3/23/2012)

---

Lynn Pettis (3/23/2012)

---

msmithson (3/23/2012)

---

Lynn Pettis (3/23/2012)

---

Just as long as the developer knows that if he hoses his system he is on is own, ensures that all required software is...

Just thought I'd share this little tidbit:

Also just for some background (or laughs, or horrors depending) our systems administrator is also our DBA and thinks its perfectly ok for our...

msmithson (3/23/2012)

---

Lynn Pettis (3/23/2012)

---

msmithson (3/23/2012)

---

Lynn Pettis (3/23/2012)

---

Just as long as the developer knows that if he hoses his system he is on is own, ensures that all required software is...

TGIF! The weekend is almost here (or is for some)!

Check the site where you downloaded the files. They may have some additional info there that may help.

msmithson (3/23/2012)

---

Lynn Pettis (3/23/2012)

---

Just as long as the developer knows that if he hoses his system he is on is own, ensures that all required software is installed and running...