Viewing 15 posts - 1 through 15 (of 24 total)
Excellent, thank you Des!
September 25, 2019 at 2:20 pm
Thanks everyone, much appreciated.
April 17, 2019 at 11:38 am
Thank you both, much appreciated.
April 11, 2019 at 8:34 am
Thanks Rob, that works a treat 🙂
February 14, 2019 at 8:00 am
Genius!! Thank you both.
February 14, 2019 at 7:51 am
Hi Rob
Many thanks for your reply and apologies for the late response from me.
That works great! However, I wish to produce an output for ALL serial numbers, so...
February 14, 2019 at 6:58 am
Thank you, Jonathan
Yes, I did mean to write that - thanks! First day back after the Christmas break and the brain isn't yet functioning!
Many thanks
January 8, 2019 at 8:15 am
Hi both
Thanks for your help.
Jonathan - Yes, mailingtype is a primarykey on the mailingpreferencetable
Michael - the exact error is:
Msg 2627, Level 14, State...
January 8, 2019 at 7:50 am
Brilliant, thank you 🙂
October 29, 2018 at 4:59 am
Many thanks Jonathan - that works perfectly!
October 15, 2018 at 8:09 am
Here is my SQL:
select distinct cast(c.serialnumber AS INT), c.firstname, c.keyname, c.addressline1, c.addressline3, c.dateofbirth, c.donotmail, c.donotcontact, m.mailingtype,
GETDATE() AS [todays date],
DATEDIFF(YY,dateofbirth,GETDATE()) -
CASE WHEN...
October 15, 2018 at 7:40 am
Very true and I will definitely learn. Deadlines are looming this week unfortunately 🙁
October 10, 2018 at 7:49 am
OK, thanks John.
I think that's above my SQL knowledge unfortunately. I'll do it the manual way 🙂
Many thanks
Jon
October 10, 2018 at 2:48 am
Thank you everyone. It turns out that Lynn's answer r.e. the triggers was the one 🙂
Best wishes
Jon
September 18, 2018 at 9:30 am
Viewing 15 posts - 1 through 15 (of 24 total)