I think it should work ...

SELECT COL2 COLLATE SQL_Latin1_General_CP1_CS_AS, COUNT(COL2 COLLATE SQL_Latin1_General_CP1_CS_AS)

FROM #test

WHERE col2 IN ( 'AB', 'aB', 'xy' )

GROUP BY COL2 COLLATE SQL_Latin1_General_CP1_CS_AS

my query unexpectedly took 15 minutes to run and I cancelled it after that ..

then I came to ssc and an easy one to start the tuesday ...

felt relieved ...time...

Lokesh Vij (9/17/2012)

---

Me too got this question wrong...

Took a wrong...

nice question ... I got it wrong anyways.. was suppose to mark the another answer 🙁

I need coffee ...

thanks for the question..

well, basically deadlock happens when one process is blocked by another process..

(Edit : and vice versa)

you can check the processes using sp_who2 . that might give you some information to...

could you provide the sample data ?

i.e. what is existing and what is required , ddl would be a great help to under the problem more clearly.

Lokesh Vij (9/13/2012)

---

An easy one for Friday!

I love using Rollback [after specified time].....to warn developers to log-off from the database otherwise they will automatically be logged-off after specified time...

I think I missed something .

nice question . get to learn about the column sets.

thanks

Use varchar . and don't save the formatted data in the database.

I had faced this issue , and it was a hell of a mess when a new company was...

sorry, couldn't go through the whole code ..it's too big for a quick look;

was this initially taking less time , and now you are facing the issue with sp or...

nice question ;

one more observation :

-- t1(id int,data varchar(50)) ; t6 table doesn't exist

create procedure usp_testing

as

select a.id,a.testing from t1 a

inner join t6 b

on b.id = a.id

go

this doesn't throw...

shikhar_0511 (8/27/2012)

---

Actually when i run this on wamp server it shows following error

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your...

select * from #testtable

where id is null or name is null or sal is null

union all

select * from #TestTable

where name =''

use column name instead of * ;

and I assume...

asranantha (8/26/2012)

---

hi friends i have a small doubt in sql plz solve

i have a table that table contains some nullt values and some spaces.

how to seperate what ever...