They can also be used on a view as long as it is a persisted view.

Hi

I thought you would be able to work out the easy part

select ' select softwaremanufacturer,productname,productversion' as c1

union

select ' ,'+c.name as c1

from syscolumns c inner join sysobjects o on c.id...

There are leading spaces in the select which are very important for the order in which the statements return

Hi The result of the following can be run as direct sql for solution

select ' select softwaremanufacturer,productname,productversion'

union

select ' ,'+c.name

from syscolumns c inner join sysobjects o on c.id...

Your right, but for the applications i use it for i.e. checking whether someone is the correct age to apply for insurance policies when contacting us my code is sufficient,...

Yes The 1 and the 0 are definitely the wrong way round, leap year's are a problem, but try using cast(DateDiff("d", DateOfBirth, getdate()) / 365.25 as tinyint) which is the...