Hi Rob,

The problem with your first query is that you missed to add the join condition for the CustomerID. In result, you're getting a cross join between all the rows...

You might want to check the books section on this site. There are some that might help.

Troubleshooting SQL Server: A Guide for the Accidental DBA by Jonathan Kehayias and Ted...

Does this help?

http://blogs.msdn.com/b/ramoji/archive/2008/10/16/how-to-open-dts-packages-in-sql-server-2008.aspx

If you only need those 3 levels, just keep it simple. 😉

SELECT p.TeacherId AS userID,

s.UserID AS student

FROM #temp p

JOIN #temp s ON p.UserID = s.TeacherID

WHERE...

There is one free built-in tool.

http://msdn.microsoft.com/en-us/library/ms188055.aspx

You can read on how to do it in the article linked in my signature. 😉

Sean Lange (6/10/2014)

---

below86 (6/10/2014)

---

Having a consistent naming convention for fields. I am as guilty as anybody at not doing this, but it is driving me nuts now. Years...

Or you could use a single data type such as a (var)char.

SELECT CASE WHEN decimals = 0

THEN...

That's because 16 is the full length. From those 16 positions you need to substract 4 for decimal positions. That gives you 12 positions on the left and 4 positions...

A CASE statement can only return one type of data. All possible returned values should be the same. Imagine that you have something more extreme such as

select case when datatype='int'...

Hi welcome to the forums,

bcp only allows to export to a text file (regardless of format or extension). If you want to use it, you'll need to have the intermediate...

That can be a problem and you might...

I would go with the format file. That way you have a little more control on what it's happening.

Jeff Moden made a great article for starters on this (it helped...

Why do you have so many columns?

It's normal that you get an error if you're using distinct and ordering by a column that's not returned in the select.

You should use...

So...