Yes, it would be good to use DDL rather than your idiosyncratic way of outlining the problem. But at the same time, if you are clear on the issue at...

PRINT produces a kind of message - a string - rather than a recordset, so it doesn't have columns in the sense of fields. You could mess around with padding your...

Well I'm very sorry to be so boring. And that was before I was older and duller! Imagine the paroxysms of ennui I could induce in you if I ever...

In version 8 and above there is also an undocumented trace flag, 1123581322, which activates the experimental allow_vocal_interface option. this permits you to submit ANSI SQL statements...

Yes I remember when I had my first DBA jobs I would send poeple messages saying: You have attempted to perform an illegal operation. Please step away from the...

OK good luck.

(in case you are not happy with the response so far-)

http://www.sqlservercentral.com/forums/messages.aspx?forumid=20

>Why you need "*30" in "Group by" ?

You don't; you need it in the SELECT, and in the absence of countervailing reasons, I always try and ask SQL to...

No... it's because the 'nested triggers' server option is on, which it is by default, i.e. normally triggers do trigger each other.

Setting 'recursive triggers' off at db level doesn't...

It's probably not that. The optimiser normally knows to add the same where clause

to each half of the union before evaluating them.

But if the code you've posted reflects your tests, then...

select dateadd(mi,datediff(mi,0,fax_date)/30*30,0) half_hour_start, count(*) cnt

from @sample

group by...

1. upgrade the NT4 machine to WIN2K before migrating the databases

OR

2. uninstall SQL8 from your WIN2K machine and install SQL6.5, then migrate the databases, then upgrade from 6.5 to 8.

If you do the last one, make sure that the files are removed once processed, or the job will keep rerunning.

I imagine once every 15mins or so would be often...

>when I debug the SP, I pass '' which ends up as '''' in the SP

Can you post the code you use to debug the sp? I think you...

The triggers are triggering each other, anyway. you don't need two triggers:

CREATE TRIGGER trigger_both ON MyTable AFTER INSERT, UPDATE

AS

UPDATE MyTable

SET

LastUpdateDate = GETDATE(),

Tim Wilkinson

"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant