To the best of my knowledge this is totally incorrect.

Fetch the data from where? If there is no copy of the data, it must come from the table -...

There's also the following:

Catalog views return information that is used by the SQL Server Database Engine. We recommend that you use catalog views because they are the most general interface...

INFORMATION_SCHEMA views are perhaps not so much in vogue as they were:

http://sqlblog.com/blogs/aaron_bertrand/archive/2011/11/03/the-case-against-information-schema-views.aspx

A view does not contain any data - it is just a query stored in a view object.

So, if anything, it will make performance marginally worse, not better.

There is no...

In fact you don't need the WHERE clause:

SELECT D.a, A.a, A.b

FROM D

LEFT OUTER JOIN A

ON A.a = D.a And A.b=1

...but you've fixed it. Anyway - there are a...

You need to put the condition in the join clause:

SELECT D.a, A.a, A.b

FROM D

LEFT OUTER JOIN A

ON A.a = D.a And A.b=1

WHERE A.b = 1 or A.b is null

I think this will do it:

-- Data (corrected column names):

if object_id('tempdb..#Position') is not null drop table #Position;

create table #Position

(

PosId Int,

ReportTo Int,

EmpId Int,

IsVacant Int,

LevelNo Int

);

insert into #Position values (1, 0, 123,...

That's correct.

This is a good technique for converting rows into columns. It was posted by someone else on SSC a few days ago. If you want to convert many...

Good to hear it's working!

schema-names you mean to add this [dbo] in front of every object?

That's right. MS might make this compulsory in the future, so it's good to...

Having said that ----

This works - d/k if it does exactly what you want:

DECLARE @command nvarchar(100)

DECLARE @par nvarchar(100)

...

I read it as: the book/page/entry data refers to the original hand-written books, and the data is just required to print on the certificate so it can be referred-back to...

I'm not sure why you've got 3 quotes each side of 'U'. You only need 1 quote - then it works:

declare @par nvarchar (10)

set @par='U'

...

If you add a NULL into a string, the result is NULL, so you need to handle the nulls individually like this:

ISNULL(first value, second value) - returns the first non-null...

What exactly is the problem?