wolfkillj (7/23/2013)

---

Sean Lange (7/22/2013)

---

sqlfriends (7/22/2013)

---

I have a database that imported some students' info from a text file.

When importing into the raw table, the studentID is set as varchar(9).

Then we select...

OK I like the idea of a temp to hole the order of the class names. I would instead create a table that contains a value to sort by and...

This looks an awful lot like homework. What have you tried so far?

You can easily use convert to force the formatting.

Declare @StartDate date = '2013-01-01'

select @StartDate, REPLACE(CONVERT(varchar, @StartDate, 110), '-', '') as IntVersion, CONVERT(varchar, @StartDate, 110) as DateVersion

The real concern is that...

There could several causes of this but the most likely is parameter sniffing. http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/%5B/url%5D

Can you post the proc? We may want to see the tables and index schemes but let's...

Careful now. Do not get stuck in the...

I realize that my example above is not really accurate because once a foreign key is established you can't change the datatype and the datatypes must match when creating the...

chugghin (7/22/2013)

---

Well, I tried setting it up for a test. The field is limited to 18 characters, but I can't even set it to 50 or 25...basically, can't go one...

Learner44 (7/22/2013)

---

Hi Sean this is WONDERFUL solution, i believe in my current situation.

Just wondering, once account number chages with update, it makes permantaly chages.

if admin want to refer back to...

L' Eomot Inversé (7/22/2013)

---

dwain.c (7/17/2013)

---

Brandie Tarvin (7/17/2013)

---

WHOO HOO!

Not only did I just teach myself how to use MERGE (never had time or reason), but I managed to use it correctly...

TryingToLearn (7/22/2013)

---

as a first step i fixed the loop, used variable for count. I tried before(and failed) and will try again to use row_number, and will also try the load...

matt-996958 (7/22/2013)

---

Thanks, I was able to get rid of the Create/Alter error with a GO in the .sql file. I am still getting the strange "Incorrect syntax near 'n'."...

IMO = In my opinion

Did you fix the loop or fix the code so it doesn't need a loop?

Most likely whatever is in your .sql is missing a go somewhere.