select * from table

where BalanceOld is not null AND CurrencyNew is not null

you are right .

given xml is only sample.

actual xml I pass through variable. '@Key1sentenceKey1wordsXML.'

Ok. Thanks

select table_name,column_name,data_type,maximum_character_length,is_nullable from information_schema.columns

this query gives you details and from them you can generate script as per your requirement..

but I think u r choosing laborious work.

Use information_schema.columns table you get most of from it

like table_name,column_name,max of length,is_nullable through which u can generate script easily..

I have generated the sample code but actually in last select statement select fields names come from another dynamic table which one is based on physical table...............

dont worry i have...

Ok.thanks My work is done.

thanks to you and Gail.

I cant I have also tried same with temporary table but i can not

create table #tbl(id int identity,index_value_table_name nvarchar(max),index_value_column_name nvarchar(max));

declare @var nvarchar(max);

set @var='mynk'

alter table #tbl

add column + @var + nvarchar(max);

select...

Thanks its working.........

and you are right I have not tried your code.

also u r right I have not give sample for my query in good manner.....

Next time i will take...

yes but you have created table t not @t....

I have problem with table variable @t.......

table variable can't be updated as shown by me or u.

DECLARE @t table (offset int IDENTITY(1,1), foo nvarchar(50),number int)

INSERT INTO @t (foo) VALUES ('one')

INSERT INTO @t (foo) VALUES ('two')

INSERT INTO @t (foo) VALUES ('three')

INSERT INTO @t (foo) VALUES ('four')

I have...

I have seen first time PARTITION BY NULL

good one............

Thanks.

it works but i am triying to eliminate two table scan of same table...

ie. exact solution is

select name,count(name),(select count(*) from temp)

from temp

group by name;

but this one takes two table scan...

Ok.

Its works.........

Thanks all

there should be

book intersect employee

left outer join

book intersect employee intersect department