Try the below script.

WITH CTE_First(Num_key, Name) AS

(

SELECT 1, Name FROM abc_test WHERE num_key = 9

UNION ALL

SELECT 2, Name FROM abc_test WHERE num_key = 7

UNION ALL

SELECT 3, Name FROM abc_test WHERE...

Praveen, Did you use Mike's solution? Is that what you were looiking for?

You can check the characters ASCII by using ASC function and if the value is not between to English chars ASCIIs you can replace it with required values. 65 to...

There might syntax errors in the below code as at present SQL is not installed in my system. But just try the below script after fixing the syntax errors.

WITH CTE_First(Num_key,...

Ok. So, My doubt is what should be the num_key value of these 3 names? 'RIBI', 'GB', and 'TRF'

How about table parameter? If you can fill the months in a table and pass it as a table parameter, you can give a WHERE condition IN (SELECT month from...

But Kiran, Num_key values are different in your expected result and original table value. Do you want to replace it with 1, 2, and 3?

Oh. Sorry. I read the below in one link. So, It should work online.

"Setting the optimize for ad hoc workloads to 1 affects only new plans; plans that are already...

Hope the below link helps. There is a good explanation about it.

http://blog.sqlauthority.com/2009/03/21/sql-server-2008-optimize-for-ad-hoc-workloads-advance-performance-optimization/

xp_cmdshell is another extended stored procedure. 'Dir' is the place you have to put the parameter for that sp. You can use DOS commands like DIR, CD, DEL, COPY, etc......

Which settings?

When there is an exam, we need to dig through little more to cover them. Obviously that will improve your skills as you know things are much deeply. Go for...

Can you try this?

SELECT 'filename_' + REPLACE(CONVERT(NVARCHAR(20), GETDATE(), 102), '.', '-')

Regards,

Shaiju CK

Are you getting any error? Also there is no code like sp_executesql or EXECUTE command to get the data from database to @WSPrice1 variable.

Regards,

Shaiju CK

Atleast they should come up with some screens which they are going to develop. If that is also not there, you might required to chase Business Analysts and Developers to...