Search results for query: *

There is a table with the following test data PrimaryId EquipId Worker Queue 1 1 Worker1 1 3 1 Worker3 3 2 1 Worker2 4 4 1 Worker4 7 Need to write the update the table which will rotate the Workers such that after the update statement the data...

Hi: I have a Belkin N1 wireless router - I have enabled port forwarding for a port that forwards it to a web server machine. The issue is whenever a person gets on a connection of the application the application cannot be viewed by another person. Not sure what the issue can be - any help...

Hi: Is there a way I can get the result set of a query into an excel table ? Thanks

Hi: I have a tsql result set stored in the dB an xml column using XQuery (FOR XML) it is missing the encoding information <?xml version="1.0" encoding="UTF-8"?> How can I add this to the column ?

Hi: I need to generate an XML feed as per an XSD from the database. It is a SQL Server 2008 Express edition. I saw some samples with OPENXML and XQUERY but could not find anything that conforms to an XSD. Any help in the process will be appreciated !

Hi: we need to get an xml file from an sftp location and load it to a table. below is a sample xml file <?xml version="1.0" encoding="UTF-8"?> <Inventory xmlns="http://xyz.com"> <Stock WarehouseId="0" SkuId="787935679937"/> <Stock WarehouseId="0" SkuId="787935679944"/> <Stock...

Hi: I have a Hyper-V Server box in which I have 2 VMs I would like my IP to be forwarded to one of the VMs in that box on checking the DHCP list of my router - I could not locate the IP of the required VM I am able to RDP into the VM from within the network How can forward the IP from the...

Hi: I'm on CR 10 - need to display a group total in a header section - here is the report layout GH1: GH2: D: GF2: @totals_to_displayed GF1: @totals_to_displayed needs to be displayed on GH1 How can this be achieved - Any help will be much appreciated ! Thanks

Hi: I need to copy a database from SQL Server 2008 to SQL Server 2005. Since '08 .bak cannot be restored in '05 I have created a .sql file by 'Generate Scripts' with Data option. This file is about 12Gb. When I'm trying to open this in SQL Server 2005 I get this message - not enough storage...

Hi: I have the following 2 queries: SELECT COUNT(DISTINCT a.cnslt_id) FROM iplanrpt.vm_rpt_cnslt_ctrct a where a.bmsdmn_nm = 'ABILIFY' and a.ctrc_status_ds = 'Active' SELECT count(distinct a.srch_cnf_spek_hcp_id) as "used" FROM iplanrpt.vm_rpt_spek_epsd a, iplanrpt.vm_rpt_prgm b where...

Hi: I'm using Crystal 10 I have a bar graph and I need to call out (mark with an arrow or even specify a different color where as keep all other bars same color) for a specific value / bar in the graph. Is there a way this can be done ? Please let me know if the requirement is not clear...

Hi: I have Crystal Reports V10 and backend dB is SQL Server 2005 I need to schedule the same rpt 'n' times where n is the distinct # of items in a database table. the rpt will take the value of 'n' for each run and will need to produce 'n' different pdf files What are some possible...

Hi: I need to build a test server (Windows server 2008/2003) with Windows AD on it. SQL Server 2008 will also need to reside in that server. since the main purpose for this is test / education I am looking to use the same box as a windows 7 desktop using some virtualization (VMWare etc...)...

Hi: For a given report there is an input parameter of type Number and 'Allow multiple values' checked. The report is running fine but if one has to enter a lot of parameters then it has to be done one by one !! Current Record Selection is {V_RPT_EVENT.PRGM_ID} = {?Event ID} Is there a way...

Hi: I have a Dell Inspiron 630m - factory HDD - was 40Gb EIDE upgrading to - 120Gb EIDE I want to use the 40Gb as a backup / external HDD - I was wondering wether the enclosure also are EIDE / SATA etc.. - I find IDE and SATA enclosures but not sue which one to go for - any advise /...

environ: CR10, SQL Server2000 Below is the report design (section wise) that works proper. RH - PH - GH1 - tableA.col1 GH2 - tableB.col1 //initialize flag GH3 - tableB.col2 // compute flag Details balanace // display this row if flag <> 1...

Hello: I'm on CR Pro 10 and SQL Server 2000. I need to group on a runtime formula (one that uses 'whileprintingrecords') I was wondering if there is a way this can be done. Please let me know if you need more details. Thanks

Hi: Environ: CR10, SQL Server 2000 This is for a receiveable report report on receivable by receivable owner and payer Payer is divided into primary payer, secondory payer etc.. if primary payer = 'XXX' and secondary payer = 'YYY' then report the receivable as one row with recieveable from...

Environ: CR10, Oracle 9i table in dB called THROUGHPUT_DATA with columns indicator, ticket#, date, yyyy_mm indicator is either c or R C = create, R = resolved Backlog for each month = ticket created prior to that month and resolved after that month or is still not resolved. say...

Hi: I'm on CR 10 and Oracle 9i in a table I have a varchar field as 'yyyy_mm'. It contains the4 digit year value and the month value separated by '-' eg: 2006-02, 2006-11, etc... I was looking to find the number of days that month for that year had ... that is ... for 2006-02 ... it is 28...