Jeff Moden (6/17/2011)

---

Sriram.RM (6/16/2011)

---

u might wanna try this!!!!

SET ROWCOUNT 1

DELETE YOURTABLE

FROM YOURTABLE A WHERE (SELECT COUNT(*) FROM YOURTABLE B WHERE A.COLNAME=B.COLNAME) >1

WHILE @@ROWCOUNT >0

DELETE YOURTABLE

FROM YOURTABLE A WHERE (SELECT COUNT(*)...

Hi..

Firstly... it would be great if you can give the DDL scripts for the tables along with relations/indices etc. and the scripts to insert the...

u might wanna try this!!!!

SET ROWCOUNT 1

DELETE YOURTABLE

FROM YOURTABLE A WHERE (SELECT COUNT(*) FROM YOURTABLE B WHERE A.COLNAME=B.COLNAME) >1

WHILE @@ROWCOUNT >0

DELETE YOURTABLE

FROM YOURTABLE A WHERE (SELECT COUNT(*) FROM YOURTABLE B...

Sorry for the delay in reply... u can use the query i posted earlier to achieve the same result... made some modifications to it...

DECLARE @FLAG INT

DECLARE @CLUB_ID INT

DECLARE

you can use Upper()/Lower() function to overcome issues related case sensitive issues or look at collation...

you can check this out

link to get the features/differences of various editions...

I believe you should have come across this already...

Im not sure where do you want to use session values from the .net code... you want to pass it to some procedure or to a query?

Not sure what he actually wanted.:doze:.. i just modified the query what he had given... :hehe:

your query would not find if it contains special charecters.... try this..

SELECT COUNT(*) VAL2 FROM

(

SELECT COLUMN_NAME FROM TABLE_NAME WHERE (C1 NOT LIKE '%[^A-Z]%'...

In case you require it in the table structure, you can go for computed columns... more details from MSDN

http://msdn.microsoft.com/en-us/library/ms191250.aspx

My bad.. Missed it out somehow...:(

same article quoted by 2 people with a time difference of one min!!!

Please see the article below written by Jeff Moden on running totals...

http://www.sqlservercentral.com/articles/T-SQL/68467/

found a work around..... thought might be helpful to others.

Add an empty result set at the top with the same structure as the select statement, this will return the metadata...

Aplogies.. removed the post... read it wrong...