kalxas

try this INSERT INTO cltClients (Field1, Field2, Save1, Checkin1, Sandbox1) SELECT Field1, Field2, Save1, Checkin1, Sandbox1 FROM cltClients WITH (NOLOCK) WHERE ClientNumber = @Template_Account;

Hi, if your problem still exists and you are using php for your website then try a conversion before display the database values with the mb_convert_encoding. I had the same problem and fixed it as you can see in the following example $area_name = $row['area_name']; $area_name = mb_convert_encoding($area_name, 'UTF-8', 'ISO-8859-7'); …

Hi mbarandao I think you don't really needs the GROUP BY ttlsent ASC because you are missing some rows I will give you an sql with all the rows SELECT email, fname, lname, ttlsent, ttlreceived, ROUND(ttlreceived / ttlsent * 100, 2) percentage FROM (SELECT cr.email, m.fname, m.lname, SUM(1) ttlsent, SUM(CASE …

try to post in the php section

Assume that you have a table to track every day yours employees records with working or absent, then try the following where er.working = 1 the employee worked the er.recordDate and er.working = 0 the employee absent SELECT er.employeeId, SUM(CASE WHEN er.working = 1 THEN 1 ELSE 0 END) working, …

to solve your problem you have to export the table schema and data and explain what do you want to do, no one can figure out from a not working sql what do you really expect! some solutions 1) in the 3th sql add and c.cand_id = p.cand_id 2) the …