It may not be the bet way to do this, but the following may help: (Set variable @a to 1 and you will get 1 row, leave it...

for me 1 & 2 return the correct age as I have had a birthday this year. For a birthday later in March then only Option 2 gets it...

you could try 'true' or 'false'. I don't know if this will work but...

This does the trick:

select isnull(a.SerialNo,b.SerialNo) as SerialNo

,a.Country as 'TableA.Country'

,b.Country as 'TableB.Country'

from Tablea a

full join Tableb b on a.SerialNo = b.SerialNo

order by isnull(a.SerialNo,b.SerialNo)

select vvm.External_Value

from v_valueconfigurationItem vvc

join v_valuebrand vvb on vvc.Brand = vvb.Text

join v_valuemapping vvm on vvb.ObjectId = vvm.InternalValue

Where vvc.Brand = 'Hewlett Packard'

ought to work

S

if you wish to view the data that has been added to the table but not yet committed you will need to execute a "dirty read" ie. select * from...

Why not use the following in a trigger?

create trigger <name>

after Insert, Update

as

If update(Your Columm)

    begin -- do your auditing

    end

else

return

Then you can audit only for those columns you are interested...

yes you can

You can use it in the same way as a temporary table or a permanent table.  there are limitations of table variables (see BOL for details) but they...

try

Set fso = CreateObject("Scripting.fileSystemObject")

and see if it works any better I don't think you need to reference the Server

S

According to Books Online, and an Execution Plan, there is no functional difference between the two expressions.  However <> is the ANSI 92 compliant version, so I suppose it is...

Hi,

Thanks for that, it helped me a lot.  Sorry for the tardy acknowledgement.

S

sorry,

That was the expected result set - I am trying to generate the final (Linked) column.  This is very much a small result set - as I say, we are...

I'm sure someone with a bigger brain than me could come up with a better solution, but the following does the trick.  you could turn the loop into a function...

I may be missing something, but I would convert to a decimal with a precision of 5 decimal places, so you end up with something like this:

set nocount on

declare @myTable...

This works in a fairly unpleasant sort of way:

declare @id int

select @id = min(id)

from #tab1

while @id is not null

begin

 insert into @tab

 select  top 2 a.Name,b.Company

 from #tab1 a join...