Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by thisisboni

  1. thisisboni

    Update statement to rotate a table

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

    port forwarding allows only one incoming connection

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

    port forwarding allows only one incoming connection

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

    TSQL Query to Excel Table

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

    TSQL Query to Excel Table

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

    XQuery - Need to specify the XML encoding in the first row

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

    XQuery - Need to specify the XML encoding in the first row

    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 ?
  8. thisisboni

    TSQL Query result to XML as per XSD

    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 !
  9. thisisboni

    Load XML file to SQL Server 2008 R2 temp table

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

    Load XML file to SQL Server 2008 R2 temp table

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

    Hyper-V virtual machine's IP not shown in DHCP list

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

    GF2 total to be displayed on GH1

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

    GF2 total to be displayed on GH1

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

    GF2 total to be displayed on GH1

    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

Part and Inventory Search

Back
Top