you could run profiler and see what queries are hitting that table.

I'm not sure what patch you are referring to. All we did was update the OS on our boxes using TZEDIT.exe to tell the OS when to make the...

Thanks Sergiy, I've alway just looked at the fields I am querying when building the indexes and not the data in the fields. I'll have to pay more attention...

karthikeyan (10/31/2007)

---

Hi Example,

I have faced the question mentioned in the subject text box. I said to those peoples,' SP will not return any value and function should return value'.Am...

If I understand correctly you want

select distinct testid,column1,column2,...column30

into TableB from TableA

select distinct testid,column31,column32,...column60

into TableC from TableA

This will put rows with unique data in testid and the first 30...

IF you are doing this in a web page then use the format function in vbscript.

A columncan only return one data type. You could kludge it by returning the value as a varchar and using string manipulation to return what is left or right...

look up crosstab query or pivot table here in the forum. There are tons of examples.

declare @a float

set @a = .77272721

select @a

select convert(decimal(9,2),@a)

select cast( @a as decimal(9,2))

I'm not sure what the example shows but the OP asked

Doesn't that identify IDs that have PRI gaps? And assumes that PRI is an int in a varchar field.

I don't really see the missing sequence in your example. The ID doesn''t look unique and the priority apprears to be a char field. Here is a thread on...

I did that. I fixed the last error which appeared to be a wierd character carried over. The first error "Near ASC" is real. I took out...

If it never has more than 200 records in it how many adds and deletes are going on? If you are continuously adding and deleteing records you are probably...

Jeff--

It throws errors

Server: Msg 156, Level 15, State 1, Line 27

Incorrect syntax near the keyword 'ASC'.

Server: Msg 208, Level 16, State 1, Line 12

Invalid object name '#yourtable'.