I think the problem you have here isn't in relation with ANSI SET.

that warning implies that your query is not completely done. You should to consider NULL values in the...

Permissions (From books online)

DBCC INPUTBUFFER permissions default to members of the sysadmin fixed server role only, who can see any SPID. Other users can see any SPID they own....

please give us some detalis of the comparison you have to do... however i think sp is better

the best thing you can do is to add a field with the "path" of each node

something like this:

001.001.001.001.003

then your life will be easier. the key is to make...

I think subquery is too slow.

You could try something like this.

begin tran

create table a (clientid int, Unitbalance numeric(21,0),Dates datetime)

insert into a values (123, 999, '20080101')

insert into a values...

I certainly recommend a stored procedure.

i dont understand prety much what you really want to do. can you explain exactly what you need?

if what you need is that a common user can see the SQL...

what Gila said also make sense. it is something that you have to consider when using dynamic sql

perhaps doing a dynamic EXEC of the big query you could obtain the same efect than doing another SP, even better because in the dynamic query the variable would be...

I had the same problem once but i barely remember what i did 😛

Anyway you could try to put that variable into a @table and to make the join in...

Tank you very much!! i'm actually testing this posibility to ensure it works for me.

it seems that you are trying to pass the FormNameCode of each row to the function and hoping than sql makes some kind of UNION of each result set to...

Ann M (5/28/2008)

---

I have data that looks like this:

ColA ColB

A 56432

A 65557

B ...