Seems like too much effort to me. If you are using identity why do you care what number it is? What are you going to do when you 10k rows...

There are way too many possibilities and too few details provided to be of much help. Take a look at this article http://www.sqlservercentral.com/articles/SQLServerCentral/66909/%5B/url%5D.

This is called a PIVOT. Jeff wrote a couple of great articles about this very topic.

http://www.sqlservercentral.com/articles/T-SQL/63681/%5B/url%5D

http://www.sqlservercentral.com/articles/Crosstab/65048/%5B/url%5D

Good question and certainly a learning point for many people. For this reason alone the question was a good one.

It is unfortunate about the answers. I too was not sure...

Cadavre (2/1/2012)

---

Sean Lange (1/31/2012)

---

You could always just add a little string manipulation and still keeping is a lot easier to read.

SELECT

CAST(((DATEDIFF(minute,StartTime,EndTime) - BreakPeriod) / 60) AS VARCHAR(5)) + ':'...

Eventually the connection will timeout and be reusable. You need to add some code to close your connection. The example I gave you for the footer is a great way...

If you simply want to remove the tab you can use replace.

replace(ColumnWithTabs, char(9), '')

That help?

You didn't really give anybody much to go on here. You select from a view and join to a function multiple times. My guess is whatever is causing this is...

Now of course you still have the issue of timeouts. Do you have long running sql processes? Stored procs that take a few minutes, that sort of thing? You can...

Yes pooling will reuse a connection that is not being used. You should (as you pointed out) explicitly close your connections. It sounds like your environment uses a number of...

Well you were correct that you wouldn't be able to explain it clearly. 🙂 I certainly got lost three of four time through the explanation. However there is hope. The...

Like I said I suspect you have carriage returns in your data. Did you evaluate your data to see?

select * from table where address like '%' + char(13) + '%'...

You don't have to wrap every field in a function. If your queries are parameterized, which they should be anyway, then it is a non-issue.

I didn't think it was anything other just a 16 digit number but of course I could be wrong. I think he is just wanting this number to put on...

You could always just add a little string manipulation and still keeping is a lot easier to read.

SELECT

CAST(((DATEDIFF(minute,StartTime,EndTime) - BreakPeriod) / 60) AS VARCHAR(5)) + ':' +

LEFT(CAST(((DATEDIFF(minute,StartTime,EndTime) - BreakPeriod)...