Hi ,

you can pass variable using dynamic SQL.

declare

@Column_list varchar(max)

set @Column_list = '(MM_Title, MM_Author, MM_Theme, MM_Description, MM_Publisher, MM_Source, MM_Copyright, MM_Language, MM_Location)'

declare @search varchar(20);

set @search='test'

declare @sql varchar(max);

set @sql='SELECT *

FROM GEN_L_MM

WHERE...

Nice Question .Thanks

Nice question on set options

Thanks for new question.First time am hearing about this.

using Common table expressions (CTE).

Cannot able to understand properly may be

this query will work

declare @username varchar(10),@fromdate datetime ,@todate datetime;

select username,ACTION,COUNT(action) from table1

where username=@username and datetime between @fromdate and datetime

group by username,ACTION

...

Hi,

with cte this code will work fine.

with cte as

(select 1 as i

union all

select i+1 from cte where i<5

)

select 'ABC'+CAST(i as varchar) from cte

Happy new year to all

I got it from this link.

http://wiki.answers.com/Q/What_are_the_names_of_Santa%27s_reindeer&isLookUp=1#Q=What%20are%20the%20names%20of%20Santa%27s%20reindeer

Hi,

This sample may be helpfull.

declare @Rel char(100);

SET @Rel='surname'

declare @sql nvarchar(2000);

set @sql='Select Top 10 ';

SET @sql=@sql+' CASE WHEN @Rel=''surname'' then surname ELSE given_names end'

set @sql=@sql+' AS '+@Rel

set @sql=@Sql+' from person

group...

Happy and merry X-mass

Hugo Kornelis (12/22/2011)

You are somewhat right and somewhat...

Hi,

Before answering the question. i tested with test data like

declare @test-2 table(mm varchar(10))

INSERT INTO @test-2 VALUES ('TEST')

INSERT INTO @test-2 VALUES ('abc')

INSERT INTO @test-2 VALUES ('145.87')

INSERT INTO @test-2 VALUES ('1059.31')

INSERT...

Choosed third option.got it wrong. did not think about data.

in question they did not given any sample data.

I got it wrong.till now id id not worked on nested joins.thanks i leanred one new point today