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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. rotaxmax12

    Second drop down list populates with all 0 for DataValue field

    I have a data entry form that you select a primary and secondary contact. The first drop down list populates just fine, but the second drop down list is loading with all 0 (zeros) in the DataValue field. I see this when I View Source on the page. This is happening when the page is building. No...
  2. rotaxmax12

    Rectangles and Lines cause blank page

    I have a report that the request is to print a border around the body. The body is about 1.5 pages long for each detail section. When I add the vertical line in the report generates a blank page then prints the data. How can I stop this from happening? I have tried drawing a line that is 10...
  3. rotaxmax12

    Report Wrap

    I am working up a report that a customer would take from a spreadsheet and copy and paste into a word document for presentation. The report in Excel yielded 8 rows, but 17 columns. In order to present the report, they copied the first 8 columns and pasted them in the report, then copied and...
  4. rotaxmax12

    Creating hierarchyID as part of bulk insert

    I have to migrate data from one table to a master table that uses HierarchyID data types. I can establish the parent, but I am not sure of the SQL syntax to be able to find the next node based on the parent. I used this to initially seed the database: WITH updateHID AS (SELECT struct.Id AS...
  5. rotaxmax12

    Flat file (denormalized) into a normalized DB

    I am trying to build an SSIS package that will be used to seed a new system. I have a flat file that we have to concatinate five fields to create the primary key. I tried to use the Aggregate tool, but as I need to load a total of 30 columns, in order to have all of the data pass through the...

Part and Inventory Search

Back
Top