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...

Anyone ?!? Also, just noticed that the problem occurs only when I have a connection open from within the network - it works fine from outside accepting multiple connections as long as no connections are open within the network. Any help will be much appreciated. Thanks

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...

Thanks but I'm looking for an automated solution also it needs to be an excel table and not just a worksheet \

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

Yes - that is what I did - instead of storing it as xml I am converting it to varchar(max) and adding the encoding info in the beginning. 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 ?

anyone ?!?

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 !

Thanks - it is an express edition so I don't think SSIS is included but the OPENXML works fine Thanks :)!

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...

here is what I did - GH1a: SUM({item},GH2) GH1b: SUM({item},GH1) - SUM({item}, GH2) GH2: D: GF2: GF1: this did the trick ! I'll try out your solution - Thanks

Hi: Just saw your reply - For each value in Group 1 there can be either one or two values in group 2. so the total(s) calculated at group 2 Footer needs to be displayed on Group 1 e.g Group 1 has 2 values in Group 2 - Value_A, Value_B in Group 1 (Header) I need to show Value_A Value_B Tx

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: Trying to implement the solution mentioned here here is the layout GH1: <grouped on column called 'placeInfo'> database columns GH2: <grouped on column called 'commodity'> database columns and graphs Details: supressed GF1: Subreport which contains a bar graph GF2: other stuff in...

Got the solution !! select ac - used from (SELECT COUNT(DISTINCT a.cnslt_id) ac 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) used FROM iplanrpt.vm_rpt_spek_epsd a, iplanrpt.vm_rpt_prgm b where...

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...

got it - I had to uncheck 'Automically Chart Options' and then in the options tab follow your suggestion - thanks !!