Hey Andras Belokosztolszki,

I am really happy to see this quick reply,

I appreciate the way you answering to my topic.

Cheers!:)

Sandy.

Hey Peter ,

Just Check this,

I am getting the Output for only ID 3 , why so?

CREATE TABLE #temp

(

Id int,

tname varchar(10),

Email varchar(10),

Age int,

Salary int

)

INSERT INTO #temp

SELECT '1','aaa','1@abc.com',20,1000

UNION

SELECT...

Hey Andras,

Thanks a Lot,

I got my answer,

Cheers!

Sandy.

Hey Andras,

Still I have the doubt on this,

My question was:

Can I Add a Column in a specific position of a Table By

using SQL Script, Is it possible or not?

If...

Hey bbychkov,

Thanks for Helping in Script.

Cheers!

Have A Nice Day.

Sandy.

hi,

check this

CREATE TABLE #tb1

(

id varchar(10),

date datetime

)

----

INSERT INTO #tb1

SELECT 101,'01/01/2000'

UNION

SELECT 102,'01/01/2001'

union

SELECT 103,'01/01/2002'

union

SELECT 104,'01/01/2003'

----

CREATE TABLE #tb2

(

id1 varchar(10),

id_Plan varchar(10)

)

----

INSERT INTO #tb2

SELECT 101,'A'

UNION

SELECT 101,'B'

union

SELECT 102,'A'

union

SELECT 102,'B'

union

SELECT 102,'C'

union

SELECT 102,'D'

union

SELECT 103,'C'

union

SELECT 103,'D'

union

SELECT 104,'A'

-----

SELECT * FROM #tb1

SELECT...

hey sthanika,

Use --> Case....when in Select statement to perform this task,

e.i :

Select x, y,

case z

when 'a' then 'b'

...

hey Grant Fritchey,

🙂

Thanks 2 both of you,

for helping me in my SQL topic.

Cheers!

Sandy

John,

Thanks a Lot.

Cheers!

Sandy

Hey Grant Fritchey,

Thanks for your quick reply,

but i think it may be in different in column wise,

i mean to say that if table contains more than one column in...

I think code is correct and its working fine with SQL server 2005,

Cheers!

Sandy