Ok SoHelpMeCodd ,

...

Dear ChrisM@Work / twin.devil ,

...

Dear SSC-Forever ,

Really u r genius. u...

Dear Sean Lange,

Your Query is working awesome . but column names are showing like...

Thank u Luis Cazares ,

...

Actually ,

if particular amount will collected between 2 months means .., i need to divide them and...

Hi CELKO,

Its working. thank u for your valuable time.

Hi Luis Cazares ,

Thank...

Hi this code also work :

SELECT Value

FROM

#first_nonzero

WHERE %%PhysLoc%% >=

...

Actually This is an interview question.

Hi BWFC / Phil Parkin ,

Its working thank u very much for ur valuable time.

Dear BWFC & Dear Twin.devil ,

...

HI ,

U may use this coding Also .

select

a.emp_id , a.emp_name name_1...

DECLARE @a VARCHAR(max) = REPLICATE('a', 10);

DECLARE @b-2 VARCHAR(10) = REPLICATE('b', 10);

SELECT LEN(@a + @b-2);

Ans : 20

conversion type errors are display ..,

Actually in third part they give value 456

but if we give out put as varchar type '456' mean error wont showing.

eg:

DECLARE @tbl TABLE (...