I got this to run in 5sec but when i hook this up to a crystal report it takes 4 min to run for the first time, 5+min in the...

I didnt get nay reply for this..

is this kind of weired question? guys let me know if have encountered such problem.

when i read in msdn it says

READPAST, NOLOCK, and READUNCOMMITTED are not allowed

but if i do this i get no error.

INSERT INTO table (field)

select field

FROM table2 WITH (NOLOCK).

is there...

any help?

OK I got that.

need to have count(*) after the group by column we need.

like

SELECT officename,count(*) as CountOfOffice FROM Emp

GROUP BY officename

both temp tables already has some aggregated values in that, now am trying to group them by empid.

NO, tht will not do.

it gives error for many columns

Column '#temp2.EmpIDis invalid in the select list because it is not contained in either an aggregate function or the GROUP BY...

No its just on the server am doing my updates?

but the other machine has sql server 2005?

I tried enabling network access settings of MS DTC but still getting the same error.

how cud i fix it?

Any HELP?????????

I am already using a Linked Server why do i need to go for OPENROWSET which opens a different connection again.

thanks for the reply.

How can i use OPENROWSET in this scenario, i never worked with it.

I get this error

[OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]

OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d00a].

Msg 7391, Level 16,...

Steve Jones - Editor (6/26/2008)

---

What are you trying to do? You can create a temp table and assign the output of the proc to it.

Can you not perform the join...

ALZDBA (6/24/2008)

---

did you try to split the "UNION ALL"

So to rewrite the full query using the TT table

and then perform a union all using the full query with the...