Please provide your table definitions. Some test data, and desired output would be nice too.

See this link for some guidelines on how to do this: http://www.sqlservercentral.com/articles/Best+Practices/61537/

There is something wrong with a convenience function to make...

I'm with Matt on this one. As far as I know, it should always ignore the trailing spaces. DATALENGTH is the solution that you want for this.

For more on this and some really good explanations of how it all works and what options are avaialable to you, look in BOL (Book OnLine) under "Concurrency Control".

SQL already handles most of this for you. You shouldn't try to reinvent what SQL is already better at than almost any custom design could be.

All you have to...

Even shorter:

DECLARE @Int AS INT

SET @Int = 1

SELECT RIGHT('00000' + CAST(@Int AS VARCHAR(6)), 6)

Lost your link, Gus.

This query/view provides that information and much more as well: http://www.sqlservercentral.com/scripts/tables/62545/

matt stockham (8/20/2008)

---

From memory I think there is also a requirement to use the semicolon between some of the service broker statements and in some of the new 2008 functionality,...

Also, there is a current line counter in the status bar.

Technically,...

Chandru: can you explain how the code you are using meets your needs? It could be of help to others in the future.

Seggerman (8/21/2008)

---

If there is no pressing need to generate the numbers in SQL consider generating them in code

I found that the rand() function would repeat numbers, defeating the purpose of...

I think your response got lost, Jeff.

The performance of (+) is fine.

Why don't you want to use it?