I am unclear of the requirement , friend! Can you please follow the instructions on this article and provide with a better question and a clear desired-result, it would be...

It all depends on your SET_ANSI_NULLS setting..

but for starters i give u this:

-- NULL COUNT

SELECT COUNT(*) FROM TABLE

WHERE COLUMN IS NULL

-- NOT NULL COUNT

SELECT COUNT(*) FROM TABLE

WHERE COLUMN IS NOT...

Walter, your SET statement must come before the DECLARE CURSOR

Like:

set @searchname = 'TTDSLS951100'

declare mycurs cursor...

Azzu, here are some links describing APPLY clause ; all the qustions you asked is explained in detail in the link ; i had given the link to the first...

I guess, every recursive CTE must contain a primary anchor select, an UNION ALL and a secondary clause that will reference the name of the CTE.. recursion happens this way...

Hey there, try this:

;WITH

duplicate (a, b,c) AS

(

SELECT isnull(a, '*') a , isnull(b, '*') b , count(*) c

FROM dbo.t

GROUP

BY a, b

)

SELECT t.a, t.b

FROM dbo.t t

left join duplicate d

on isnull(t.a,...

Got a question bro, do we have to retain only the first occurence of a duplicated character in that string?

see as i was saying this, and as there was sample data in readily...

Jan Van , think u probably missed...

As this is fairly simple to construct, i myself created the sample data and scripts and the code.. in future, u can follow what Jan Van said and post data...

Hey there, try this :

DECLARE @Fathers TABLE (FatherId VARCHAR(10), age INT)

INSERT INTO @Fathers

SELECT 'Father1', 12

UNION ALL SELECT 'Father1', 17

UNION...

I really cant understand your request, Lucky! Please provide us sample data, sample tables and a clear-desired result.. Please read thro this article on how to post data so that...

Hey there, Whats the relation between ABC and XYZ ?

My cent is on the SQL Server Profiler.. THis will clearly let you know the exaclt T-SQL statement being run.. I am not big-shot in Profiler, so probably our other...

skcadavre (6/7/2010)

---

ColdCoffee (6/7/2010)

---

skcadavre (6/7/2010)

---

ColdCoffee (6/7/2010)

---

If your request is what Sckadavre is saying, then this might help you! This code doesn use a self-referencing CTE, but assuming your string contains only...