Thanks Sharma for your reply can you explain with an example my query is like this can you explain by modifying the below query

"select COUNT(date),date,country from advertisementhits where transactionid='9P853908BJ2391528521"' GROUP...

DECLARE @username varchar(30),

@s-2 VARCHAR(MAX)

ok this is the query

SELECT @username = 'kiranyadav.n@gmail.com'

SELECT @s-2 = ISNULL(

Hi thanx for ur response i have added ur code

ISNULL( NULLIF( LTRIM( RTRIM( [state] ) ), '' ), 'false' )

in the place of state its giving error that

"Incorrect syntax...

Hi Ramesh i have little problem in the colum of state i have some null values in the place of the null values i want to get 'false' so i...

Thanx a lot for ur explanation.

Hi Ramesh Thank u very much ur guys r so great its working great with little modification its came with execute(@s) but i didnt understand some code especially at

FROM ...

Hi everybody after searching a lot i have used the following code to retrive the logged users information the below code is working for only one record i.e., its retriving...

Hi Ramesh thanx for ur response yes @r line is not working can u suggest me how to retrive the data from second table i mean the table...

Hi i am passing string at run time and getting the spaceid's for that user but below code is giving

user as output pls verify this code and send me

DECLARE @user...

Thanx for ur response it is generating spaceids of related siteid but i want to get this data at run time without declaration and also i want to display the...

Thanx for reply yes i am working on reports in my db all the users have similar fields like state,city,country i want to retrieve only logged user report wen he...

Hi i want to place the data like this

for(int i=3;i<=5;i++)

{

select

adid,state,country

from

...

Hi

thanx for ur immediate response in my db i have Table1,Table2,Table3 tables i want to retrive data using select statement first i want to retrive data from Table1 after finishing...

Hi

i am retriving data using myeclipse7.1 editor in this editor ISNULL(STATE, 'all') or COALESCE(STATE, 'all') these functions are not working.wat can i do.

Hi

select NULLIF( STATE, 'null') AS state FROM T1 i have used this it is giving empty string in null values but i want to replace the string with 'all'

can u...