Not enough info. We don't know how #emp_temp is formed, it structure or where @col_name and @orderby come from.

I take it @orderby is Desc or ASC, and @col_name is...

Interesting method, it shows the ids and then how many are missing after it. So it doesn't list every one just how many are missing after id 2 and such:...

Itzik Ben-Gan wrote the best series of articles for this in SQL Magazine

http://www.sqlmag.com. They were great.

This will do it one statement using a function. Assuming the following table:

Create Table Testit (

Case_No char(10),

Case_Line_No int,

[No] int,

Remarks char(20))

go

Insert into Testit(Case_No, Case_Line_No, [No], Remarks)

values('1000003', 10000,...

Its all varchar, so why don't you just run the select but put len around everything and see what is larger than the field size. Truncate error means the data...

hoo-t i have to level with you, I was amazed at how simple I could make it. It was all those math courses in college I think.

It sounds data related. I just want to see what data types we are talking about in key indexes...

Could you post the create statement for the table and index?

To find out what is going on, go into Table Design, make the change then script the changes. There is a little scroll button at the top of this screen...

Space can be confusing sometimes that for sure.

But you need to take into account that your database is set to grow. The default to grow by 10% to an...

Make sure fields you filter are indexed and then

Books on Line, Configuring Linked Servers:

"Indexed Access

SQL Server can use execution strategies that involve using the indexes of the Index...

Error 169 is A column has been specified more than once in the order by list. Columns in the order by list must be unique. Which is odd. Usually you...

Sweet. Better living through TSQL.

Just use replace and get rid of ~:

Table1 inner join Table2

on Replace(Table1.userid, '~', '') = Table2.userid

usage syntax is Select dbo.RoundToBase(16 + 5, 5)