To create three rows against each row

[Mateen]

@JeffModen

The question now is... do you understand how the CROSS APPLY works to do the unpivoting and relational multiplication so you can do it again if you ever need to?

Now I know hundred percent.
Great.

[Mateen]

I love you.

[Mateen]

When you experts paste your output , it is clear and vivid.
Mine (post# 1)dim and blurry and not clearly readable.
Please guide.

[yosiasz]

Please send 29.99 for dba glasses.
What os are you running on? If windows just print screen, then paste in paint and crop only desired image, resize to make bigger if necessary

[Mateen]

@yosiasz

Got it.
Thanks.

[JeffModen]

@Mateen

When you experts paste your output , it is clear and vivid.
Mine (post# 1)dim and blurry and not clearly readable.
Please guide.

I just use the "Snipping Tool" that's built into Windows.

[Mateen]

@JeffModen

I just use the "Snipping Tool" that's built into Windows.

I was not aware of snipping tool.
I saw a youtube video how it works.
Its easy , brief and handy.

Thanks