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...
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...
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
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
How would I write a query to pull only the orders where sched_arrive_early = today + 3
So
select * from orders, stop where orders.id = stop.order_id and stop.sched_arrive_early = 't + 3'
Is it possible to rename columns for instance if I have a field called reason_for_leaving with the possible selections being AGT,AL, ATT, BKS, DIS, DL,DTI,EOB,FOL,FR
can I have it so if reason_for_leaving = 'AGT' then 'Agent and Driver Left' else if reason_for_leaving = 'AL' then 'Agent Left', etc.
Hello I have a bunch of records which the amounts of those are needing to be summed based on their source.
i.e.
sum(amount) where source = 'DRS'
or sum(amount) where source = 'CASH', etc.
so basically I have a group of records
SUMSOURCE
1000DRS
2000DRS
3000CASH
4000CASH
5000CASH
how would...
We have 2 tables, gl_ledger and gl_ledger_hist which we have done a UNION ALL with as
select * from gl_ledger UNION ALL select * from gl_ledger_hist
and it brings in our data from this, but we also need to join the data together with a third table, gl_account which has a different of columns...
I have three columns of values
1st column is all order numbers
2nd Column is all weights
3rd column is the orders I need(for a pivot table)
The first column has all the orders and the second has the weights for these orders but I need to somehow from the weights in the second column match them...
Is there a way to through a powershell script when wanting to count the number of received emails to only grab the initial ones sent to a user and not any replies, or CC's?
thanks for any help provided
Is there a way to setup a rule on someone's outlook client or through the exchange console if they are a member of a distribution group and someone emails into that distribution group it sends a reply back to that sender?
thanks
Hello,
Im I have two powershell scripts one to forward email and one to stop the forwarding to another address, but am trying to set up a scheduled task so that the script first script runs at a certain time to start the forwarding and another to stop it.
Both scripts when run manually work...
I have a field in one table, Customers which is basically a text field which contains:
443069 5/3/11 received bond pmt of 87.26 on 7/11/11
In my other table, shipments, I have a field recno, which contains the same number 443069
Is it possible to link two tables together in Crystal Reports...
at my page at www.meadowlarkco.com/customersnew2.php, within the customer referrals in my HTML which beings with the variable marqueecontent,
is it possible to open a new window with the links, similar to this...
at my page at www.meadowlarkco.com/customersnew2.php
in the customer referrals section how can I go about lining up the logos with the text next to them? Do I need to create a CSS for each?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.