One of the things I don't like about certifications is that can be very expenssive specially if you plan for more than one and I do agree that so far...

I am not sure why is that happening to you I am geting 1654 records back from that query

and as long as the numbers and letters like "001A" are zero...

OOPS!

My previous post was wrong! Didn't read the isntructions correctly

Keith,

As you already discovered it is not posible to use dynamic sql inside a function

Can you offer an example of what you...

How about ?

select

group1, group2, xref, sum(value1), sum(value2)

from

(select x.Xref, d.group1, d.group2, d.value1, d.value2

 from @x x left join @data d on x.xref = d.xref) Subq

group by

group1,

group2,

xref

I posted something to get you started not the real deal!

As you can see ron_k already posted some of my errors. I didn't test the query but if you need...

I am not going to comment about this design but you should consider changing it

On the other end I posted the query for...

Dave you got it!

The idea is that some storeprocedures have being SAVED (compiled) with those options in different settings, sp_dboption works at the database level, any new will get it...

this can get you started

Update Tbl

 set

      Type_1     = Left(AddrInstr,1)

           , Type_1_ID  = cast(substring(AddrInstr,2,3-charindex(';',AddrInstr,3)) as int)

    , Type_2     = case when AddrInstr Like ';P;'...

Unfortunatley Query Analyzer Object Browser uses sysobjects directly.

The only way would be to rename sysobjects, create a view that uses sysobjects and filter by user permissions and of course  the name would be...

Lee,

Let me simplify your life a little:

Create a view with Referal and Referal_Reference that looks like the example you posted. Then go from there

Cheers!

Glad I can help

Create Table TTT( FieldName varchar(20), Value varchar(20))

insert into TTT (FieldName, Value ) Values ( 'name1', 'david')

insert into TTT (FieldName, Value ) Values ( 'name2', 'jeff')

insert into TTT (FieldName, Value )...

For some reason (it has happened to me ) reapplying sp3 seems to "cure" these kind of problems sometimes

create table #T ( data varchar(255))

insert into #T

exec master..xp_cmdshell 'ipconfig'

select substring(data, charindex(':',data,1)+2, len(data) - charindex(':',data,1))

from #T

where data Like'%IP Address%'

hth