My output would be

for 2015 if I select date_year=2014-2015 prior yearthe count would be 3 (for id 20,40 and 50)

for 2016 if I select date_year=2015-2016 current year the count...

Thanks Sir,

its working fine for few columns but I do have more then 5 columns in my sql and its not giving the proper ranking using DENSE_RANK function so what...

Thanks Sir for your help 🙂

Thanks All for your help it worked for me 🙂

Thanks Sir for your reply its working for me thanks a lot

Thanks Sir for your solution it worked.

but getting error while executing my code by adding your solution for getting country name.

"Invalid length parameter passed to the LEFT or SUBSTRING function"

I...

Its effective Sir ! but is there any way to write the SQL for concatenate multiple records and show in on column?

Many Many thanks Sir....

its worked heartly thanks 🙂

I will give an example Sir,

I hav three databases A,B,C

I have table called ABC which I have created in database A

after that I have created synonym for table ABC in...

actually Sir i am merging one database objects to another database,

so i have to generate create synonym script dynamicaley and then execute that create synonym script.

First SQL that u provided...

I had droped that synonyms and creted synonym scripts using above sql scripts but I have to execute that create synonym script dynamically.

How to do this Sir?

Thanks Sir,

its worked for me but its created synonym but I have to execute that created synonym scripts as well

Ho to do this Sir?

Hi Expert,

thanks for your help.

Its worked for above sql.

But same logic I have used in my SQL,its giving me beloe error

"Invalid length parameter passed to the LEFT or SUBSTRING function"

Hi Expert,

thanks its worked for me...

sure In future I will take care about this

realy thanks Sir

Hi Expert,

thanks its worked but that was very complex.

cant we do directly with using that tmp table?

we need count of that name coulmn values