Easy question ,

Srikant

Check for null value . If column contains null value then might be distinct will not work

Use lookup task

Syntax will look like ,

delete b from b where not exists(select 'x' from a where a.id=b.id)

Easy but tricky question,

Srikant

Try this

select top 2 * from (select row_number() over (order by id ) row , * from tab)t where row>2

Good Question,

Srikant

Try This

DECLARE @t TABLE(

accountno INT,

period VARCHAR(10),

amount INT)

INSERT INTO @t

...

Try below SQL,

DECLARE @t1 TABLE(

id INT,

name VARCHAR(10))

DECLARE @t2 TABLE(

id INT,

soc VARCHAR(10))

INSERT INTO @t1

...

Just chnage the permission of the user(asp) and seen the result. might be the problem with user define data type

Good question , thanks

select tab2.name from

Tab1 CROSS JOIN tab2

you can use full Join to get the result

Yes, you can do it balalalalala

For True and flase value for haschildren

WITH samplehierarchychart (personid, position, parentpersonid, LEVEL, haschildren,sortkey)

AS (

-- Create the anchor query. This establishes the starting point

SELECT a.personid,

a.position,

a.parentpersonid,

0,

haschildren=Cast('\' + Cast(a.personid AS VARCHAR(10)) AS...