I appreciate the fact that the OP was very honest about his question. He did not try to disguise it. I believe he needs a bit of hand holding. The...

Try this:
SELECT
        DF.LineNumber
        ,DF.MFN
        ,Years.TaxYear
        ,Tax.Value
    FROM
        @DisplayFields DF
        CROSS JOIN (SELECT TaxYear FROM @tax GROUP BY TaxYear) Years
        LEFT OUTER JOIN @tax Tax...

Hi Chandrasekar Subramaniam,
We understand your intent was noble. Congratulations on your job.
Respect for Jeff. I have read his posts and articles ever since I joined SQLServerCentral. He has...

Dear Mr Chandrasekar Subramaniam,
Please be polite. You are the one asking for help. A good mentor is not one who gives answers to your questions, but the one who...

Paul White (3/1/2010)

Ah...

I've been using GUID as PKs, but this is a novel way of using it. Great.

Nice post.

Just out of curiosity/ignorance/inexperience, may I ask you where are we likely to write 50000-100000 lines of Dynamic SQL. I only have ~2 yrs of exp with SQL, that...

Why would you like to do that!

Perfect

Thanks a lot, Raj.

Adish

Thanks Grant, I will try that out. Maybe I should be looking for the solution on .Net forums also.

Adish

It was only important to set one trigger as 'Last'. The order of others was immaterial. When I said 'a sequence', it seems I did not use the appropriate word...

Thanks bitbucket and RBarryYoung, both the links were helpful.

Hi

The column Display is a computed column

The column Number is int

The expr used in the column properties for Computed Column Specification is:

(coalesce(CONVERT([nvarchar](20),[Number],0),'Not Assigned'))

or

(coalesce(CONVERT([nvarchar](20),[Number],0),' Not Assigned'))

or

(coalesce(CONVERT([nvarchar](20),[Number],0),' ...

Hi Guys

It looks like there was some old data in the table which made it appear that the display was not correct.However, the code is working fine. But there is...