One of the worst assumptions I run into all the time is "The rules belong in the business logic layer, not the database", which is always followed with, "why do...

Paul White (4/7/2009)

---

G², the first guy sounds quite cool, but from the second experience, I would guess you had a...

Try changing the query to something like this:

SELECT

Campus.CampusName,

Student.StudentID,

ISNULL(home.zip, company.zip) AS Zip

FROM

Campus

...

I don't understand what you're trying to do with the "INTO" command. It's not a command all by itself, but that's how it appears in your proc.

Also, I think...

As predicted, I'm going to suggest doing this kind of pivot operation in the application, not in the database. It's faster, easier, more flexible, and more secure.

If you absolutely...

If I'm not mistaken, SSIS can directly call C# DLLs. If I am mistaken, take a look at CLR procs and see if one of those will do what...

Charles Kincaid (4/7/2009)

---

I'm almost of the opinion that the brackets around identifiers would be better required. It might speed the parser. We surround strings with single quotes and...

Stephen crocker (4/7/2009)

---

From my first post when I asked the question the Select statement works after the few minor fixes, I get the exact results I was expecting. However...

I don't think patindex can do that one for you.

You could throw a multi-character wildcard in there, after the first number and before the "mm", but that might get you...

I suspect "parameter sniffing" is your likely culprit. There are good articles on that if you look up that phrase in Google/Live/Yahoo/Dogpile/whatever.

This should do what you're asking for. It's very similar to what was already suggested, but has a From clause missed in the prior post that might make a...

There are various User_Name functions in SQL Server.

user_name()

system_user

Are two of them. Try those, see which one gives you what you want.

Can you change those to Float data type? Or expand the range for the Numeric?

Can you upload the execution plan it's using?

Another thing you can do is import into a separate table, then insert from there into the final table. That'll get rid of your duplicates and your gaps. ...