I suppose if all you wanted was the max price from all the rows in the table or for a selected item, and you HAD to use CASE, you could...

Glad to help. Sorry I don't know the answer to your follow up about setting it up on XP.

I think I did once install Win 7 64bit on VirtualBox 32bit...

You only need to fill those in if you want the VM to access/be accessible to/from the internet.

If you do, open another dos command prompt on the host and type...

Ok, so if you want them to be fixed, just change them to use fixed ip address and type in the details you just found.

As long as you dont have...

Because you are working behind a router at home, I am assuming that your router acts as a DHCP server (Dynamic Host Configuration Protocol).

This means it assigns IP addresses automatically...

Ok, let me try to explain.

CONTEXT_INFO is a place to store a value in your connected session specific to your SPID.

You can think of it like a note stuck on...

Argh! No!

I said replace CONTEXT_INFO() with that, not CONTEXT_INFO. they are different!

ALTER TRIGGER [dbo].[UPDATE_EMAIL_IN_HEAT] ON [dbo].[CONTSUPP]

FOR DELETE

AS

DECLARE @ci VARBINARY(128)

--next line had to be a separate statement,...

although actually it may be better to do this:

where firstname LIKE '[!-/:-ÿ]%'

which is the set of printable ascii characters excluding 0-9

edit: when i said better i was referring to my...

Best not to do it with IN.

Try using LIKE

where firstname not like '[0-9]%'

BTW: I just found this article on MSDN that gives a fuller discussion of this topic:

http://code.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?title=AuditOrBypassTriggerExecution

My mistake - I hadn't realised you were on an older version, SQL2000 didn't have CONTEXT_INFO() as a function.

You can still do this though:

Anywhere we used CONTEXT_INFO() replace with

(SELECT...

UPDATE yourTable

SET yourDateColumn = DATEADD(year,1,yourDateColumn)

WHERE someColumn = someValue

Or something like that - depends what you want to do really...

Can you clarify how you are accessing the reports over the vpn please?

Are you using a browser on the remote client to connect to the RS site?

Are you using...

set statistics_time on;

Does this help at all?

;with upvt as

(

SELECT DISTINCT*

FROM @tab as [root_element]

unpivot (a for c in ([elementA],[elementZ])) upvt

)

select distinct 1 as tag,null as parent,root_element as [root_element!1!value],null as [elementA!2!value],null as [elementZ!3!value]

from upvt...