TravisDBA (4/24/2012)

---

It does if you are a user. I'm not...

Speaking not only for myself, thank you for your support. We are glad that you have been able to find the answers to you your questions and we hope...

Also, it is good practice to explicitly declare the columns your are inserting into. Ran into this in a project at a previous employer. we changed the datatype...

You need to specify the columns of the table you are inserting the data into. Although your first colum,n is an identity column, it is being counted as one...

Only suggestion I have is to load the data into a temporay table. If you have any errors during the load, truncate the table and go get the next...

What I like about my code is that I made the Identifier column a computed column in my test Calendar table. Makes the column dynamic, it updates itself when...

capn.hector (4/23/2012)

---

Lynn Pettis (4/23/2012)

---

capn.hector (4/23/2012)

---

Lynn i continue to learn from you. my kludge looks awful compared to the datemath you did. {facepalm} for not realizing i could just...

capn.hector (4/23/2012)

---

Lynn i continue to learn from you. my kludge looks awful compared to the datemath you did. {facepalm} for not realizing i could just add 9 months...

Challenging

Take a look at this and see if you couldn't incorporate this into your calendar table. Using a computed column should dynamically update the identifier column each day. ...

Grant Fritchey (4/23/2012)

---

Lynn Pettis (4/23/2012)

---

Well, we could say it, but we would be lying... 😉

I had to show...

Well, we could say it, but we would be lying... 😉

I had to show him one thing, but...

Just from a cursory look at the code you posted (since we can't test it since you refuse to provide us with any useful information that could really benefit you),...

Great, now he is yelling at Grant.

Stefan Krzywicki (4/23/2012)

---

Lynn Pettis (4/23/2012)

---

How obscure can some questions really get?

ok.this is simple question but nee dhelp.

i need something like untill there is value the loop should go.

i cant give...