The error says there may be errors before that one; could you provide those too please, or confirm there are none (I doubt there won't be).

On a different nit-pick to what has already been discussed, it's helpful to post your code as text, not as an image. Other users can't highlight the text within your...

It isn't simply that your intellisense hasn't updated is it? I can't appear to replicate your issue on SQL Server 2012; if i use the User created with the Login...

I assume you mean the AD Logins on your SQL Server and not from your Domain controller (if the latter, you're on the wrong website)? What about the users affiliated...

I suppose, if you're going to have more hcolumns than you've let on, you could do something like this:

DECLARE @category sysname = 'lamp';

DECLARE @sql nvarchar(MAX);

Is this not just a case of...?

DECLARE @category VARCHAR(50);
SET @category='lamp';
IF @category = 'lamp' BEGIN
    SELECT id,
          [name],

So, with the extra sample data uncommented, what output are you expecting? Could you explain the logic behind it?

Thanks.

You should know by now that you need to post consumable sample data and expected results. I'm sure there's a way, yes, but help us help you. When you post...