Search results for query: *

tried something like update payee set email = email + '\; user@somain.com', email_summary = 'Y' where id IN (select id from drs_payee where factoring_company_id = 'OTRCCHIL')

ok, just tried the above with your suggestion and it didn't seem to work, doesn't recognize Chr as a built in function name

thank you for the response, what is Chr(58)?

just looking to find out how to write the above script putting a semicolon between the current email and the address added instead of a comma.....thanks for any help provided.

so I guess in between the email and the user@domain.com which we're adding it needs to be a semi colon instead of a comma, I'm writing it as such but its complaining saying terminating quote not found update payee set email = email + ';user@domain.com', email_summary = 'Y' where id IN (select...

yes if the email is null

problem is I don't want to overwrite the email fields which I just appended the email to the ones which already had an email as the first script just updated email with fields which already had an email in it, the ones which were empty nothing was added

That seemed to work fine...thanks...how would I write this if the email is currently blank? thanks

I have 2 tables, payee and drs_payee. I'm trying to update the email in payee but add to the email address which is already in that field. I want to just update this email and set the field email_summary = 'Y' when the field factoring_company_id = 'OTRCCHIL' from the drs_payee table. Problem is...

yes, using static...we got it figured out....using the above did work just didn't wait long enough for the policy to apply. This can be closed.

Looking for a group policy to set primary and secondary dns settings to push down to end users' machines...currently have setup a login script batch file with the following but it is not updating...any help would be appreciated. @echo off set dnsserver=primary ip set dnsserver2=secondary ip for...

got that removed along with a couple other things and think I got it....thanks for the help

Im trying to remove the whitespace after the title and the Meadow Lark Companies link.....this is for an email signature...but when I send the email there is a gap of whitespace in between it....could someone take a look at this as I'm not sure exactly what to remove to get rid of this...

Hello we have exchange 2010 setup on Windows Server 2008 R2 Hyper V, and have 20 GB of memory assigned to the VM, but the physical memory always about mid day gets up to the 97-99 % range, I understand the store running high utilizing as much memory as available, but what else could be causing...

I have a formula CONCAT('0','order_id') and when I run this is adding the zero to the beginning of order_id but is also adding 15 trailing zeros...is there any way to remove these? thanks

yeah, basically IFNULL is performing the same as ISNULL I beleive

ok, IFNULL is actually what I'm using, currently have IFNULL('daystopay',30) so if days to pay is null the value needs to be 30, but what do I do I the 'daystopay' is not null and I want to show the value of 'daystopay' thanks everyone

I'm using ifnull as I need to know if 'days to pay' is null set it equal to 30 but then I also need to pull thr value of 'days to pay' if it's anything else also Thanks

I have a field 'days to pay' and when it is null want to show the value = 30. so I have IFNULL(`daystopay`,30) but if its not null to show whatever the value is in 'daystopay' Can someone tell me how to do this? thanks

got it :) stop.sched_arrive_early between getdate() and dateadd(dd, 3, datediff(dd, 0, getdate()))