Search the Community
Showing results for tags 'sql'.
Found 2 results
Hi community! I need some help to create a query to shows this fields , actually i worked in this query and i have some fields but i require the fields bellow: Field Table pri_phone_number ca_contact zloc_cnt usp_contact zip ca_location alt_phone_number ca_contact zbusiness_hrs usp_contact serial_number ca_owned_resource This is the actual query , but i dont know any of sql and i dont know wich related tables and their keys works to show the required field select ref_num, zmerchant_cnt, rc.sym as Rootcause, assignee, cr.tenant, convert(varchar(20), dateadd (ss, cr.last_mod_dt -21600, '1/1/1970') , 101) + ' ' + + LTRIM(RIGHT(CONVERT(CHAR(20), dateadd (ss, cr.last_mod_dt -21600, '1/1/1970'), 22), 11)) as [Last Modified Date], convert(varchar(20), dateadd (ss, call_back_date -21600, '1/1/1970') , 101) + ' ' + + LTRIM(RIGHT(CONVERT(CHAR(20), dateadd (ss, call_back_date -21600, '1/1/1970'), 22), 11)) as [Call Back Date] from call_req cr inner join rootcause rc on cr.id=rc.id Can you help me with this pls ? :C
Hello, first time board user so go easy on me. I need to create a report that shows the approvers for change tickets. From the ticket, I can get to the approver name by selecting, in order: Additional Info tab, Config. Items, and from there selecting the application name. That brings up the configuration item detail info which shows the approvers name. We user Crystal Reports 2008 for repoting, but I could use either Crystal or SQL if I understood the linking required. Any suggestions would be VERY appreciated as I'm stumped. Thanks much! mark