Viewing 15 posts - 16 through 30 (of 33 total)
Ian Scarlett (8/11/2009)
Try this instead
DECLARE @CALL int
SET @CALL = Call_Num From Table_2
DECLARE @PC nchar(10)
SET @PC = Schedular_PC From Table_2
DECLARE...
August 11, 2009 at 7:17 am
and this would work bearing in mind that the table to be changed had approx 56,000 rows and the post code table would have approx 3500 rows?
March 11, 2009 at 9:29 am
oh ok i see the logic there - the only issue i can see is that i dont have a definative list of all of the post codes - i...
March 11, 2009 at 7:45 am
thats great guys thank you for your help i think i'll be able to cope - there's just one last thing that baffling me - how will i transfer the...
March 5, 2009 at 10:01 am
ok cool, well in that case what i'm after is a trigger to cope the fields from one table to another lol
March 5, 2009 at 9:22 am
pants lol, oh ok so still use a trigger to populate my new table and then somehow auto send the email from there?
March 5, 2009 at 9:14 am
mmmmmmm ran:
sp_configure @configname = 'Database Mail XPs'
returned:
Msg 15123, Level 16, State 1, Procedure sp_configure, Line 79
The configuration option 'Database Mail XPs' does not exist, or it may be an advanced...
March 5, 2009 at 9:04 am
Jack Corbett (3/5/2009)
The code you posted is missing a space between sp_configure and @configvalue.
I ran it exactly how you gave it to me and it returned an error so i...
March 5, 2009 at 8:45 am
Hi Jack,
Running:
sys.sp_configure@configname = 'Database Mail XPs'
Returned:
Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near '='.
March 5, 2009 at 8:37 am
thanks Jack ill go and check it in a sec, the info that we would like to be in the email is as follows:
Subject: Insafe Helpdesk - New Call Logged...
March 5, 2009 at 8:33 am
oh ok lol i misunderstood - there's no problems with it at all.
March 5, 2009 at 8:12 am
well..... at the moment we kind of don't have an official one lol, i've asked the question but it may take a while for someone to come back to me,...
March 5, 2009 at 7:43 am
hi gail, nope nothing set up - any suggestions as to what is the best way?
March 5, 2009 at 7:34 am
Viewing 15 posts - 16 through 30 (of 33 total)