Couple of basic things ...

Generally you don't want to worry about formatting on the database side. The db should just be storing the date as a date ... the...

Lutz is 100% correct. Using case statements will have superior performance and readability. If you don't understand how to implement and you need to see a fully coded...

Jeff Moden (6/8/2010)

---

Unless I'm missing something, this problem is impossible to solve because there's simply nothing to guarantee the order of the data. There has to be a date...

joefreeman (6/8/2010)

---

I'm sorry Paul and really do appreciate your help. When you're so close to a problem sometimes it's hard to verbalise all the intricacies. If you can...

Use the tags that say 'code="sql"' (4th from the bottom) and it will look much nicer.

Please provide table definitions and sample data so we don't have to guess about those things.

Actually, before doing that, spend some time reading this great article[/url] posted by Jeff Moden. Then, if you still have questions feel free to post them here, but do...

I can think of two ways:

method #1

select ClientName, [Home], [Work], [Cell]

from #tempContactNumbers

pivot

(

MIN (ContactNumber)

FOR ContactType IN

([Home], [Work], [Cell])

) pvt;

method #2

with cteTemp(ClientName, Home, Work, Cell)

as

(

SELECT

...

If you're getting the error "Login failed for user 'NT AUTHORITY\IUSR'", then your app is not using the account that you set up. It's passing along the user credentials...

Why would you want to store text as an image?

There is a lot of information about SQL Server Profiler in Books Online. Just look up 'profiler' in the index.

Profiler will allow you to set up a trace, by...

Whatever you're using (vb.net) ... print your SQLstr to see what it's actually sending to the SQL Server. I'm guessing that it is not resolving Me.DropDownListDept.SelectedValue.ToString to what you...

This isn't a SQL question, this is a VB question but I'll do my best to help you ...

You can reference multiple tables within a dataset. Where your dataset...

You say the question isn't about how to pivot (and Paul linked an article for you about that anyway), so this is just a matter of limiting your records as...

The FK constraints are more of a data integrity issue than a performance issue. The big thing is to make sure you have appropriate indexing on your tables or...