And providing this info in this format would really help:

declare @TestData table (

tdid int identity(1,1),

timedata char(9)

);

insert into @TestData

values ('0'),('02:19'),('-03:06'),('00:22'),('00:39');

select * from @TestData...

MtnMan92 (4/5/2013)

---

Lynn,

I apologize but I'm not creating any tables yet or inserting any data. Just running the query to be sure I pull in the data that I...

Would also help to have more than one negative value in your sample data. Hard to tell how multiple negative values should be sorted along with the multiple non-negative...

It would help to see what you are working with not just this vague decription.

Please read the first article I reference below in my signature block regarding asking for help....

Start here: http://msdn.microsoft.com/en-us/library/ms191443(v=SQL.105).aspx.

No, I am not refering to...

MtnMan92 (4/5/2013)

---

I know you guys are tired of hearing this and seeing this same question asked over and over (figured this out from reading your forums for days trying to...

Lacking further information this is the best I can provide. You will have figure out the rest.

declare @SQLCmd nvarchar(max),

@sparams nvarchar(max);

set @sparams...

Just one of those so simple ones. Happens at times.

Look at server sides traces.

Bottom line, there isn't enough informatiion in your posts for me to do anything. I don't know what an actually query is supposed to look like, I don't know...

I came up with this using a very simplistic setup:

declare @TestTab table(

tid int identity(1,1),

tdata varchar(10)

);

insert into @TestTab

values ('a'),('b'),('c'),('d');

with Top2 as (

select top...

sqlguy-736318 (4/5/2013)

---

I see objects in the table with a create date going back several years. When you create a temp table does SS store this table indefinitely?

Also, I seem...

Are you talking about tables like this #MyTempTable?

The following should work.

CREATE PROCEDURE [dbo].[Get_Ques_id_for_can](

@candidate_id varchar(max),

@Exam_id varchar(max),

@sec_id bigint,

@Q_id varchar(max) OUTPUT

)

AS

declare @table_query nvarchar(max);

declare @table...