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!

Register Log in
  • Congratulations Chriss Miller 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. awholtsIT

    SQL Transactional Replication

    We're are going to be using transactional replication for bi-directional data flow between our ERP at one physical location and our e-commerce store at a secondary physical location. There is a tunnel between the two locations to support secured data flow. We're having much heated debate...
  2. awholtsIT

    How to Select into from one server into another server

    If I needed to include a where clause, would it be added as such; INSERT INTO [LinkedServerName].[DataBaseName].[schema].[TableName] (field list here) SELECT (field list here) FROM TableName WHERE field = 'criteria here'
  3. awholtsIT

    How to Select into from one server into another server

    SQL Server 2005 Standard I need to copy specific records from server 1, table A into server 2, table A. (2) physical servers with there own instance. The tables are identical between the servers. I need to copy records from one into the other to recover lost data. I've been playing with...
  4. awholtsIT

    Help with Query looking for single record to be returned, but getting

    Thank you, That is exactly what i'm looking to accomplish. Thanks again, Andrew
  5. awholtsIT

    Help with Query looking for single record to be returned, but getting

    I wrote the following query wanting the results to be one row with a sum for column1 and column2 as the fields. However, I'm getting 20 records results with a sum by the field ledgertrans.accountnum. Appreciate some assistance with getting the desired result. Thank you, Andrew...
  6. awholtsIT

    if then statement help

    Thanks That helped. Thank you very much again, Andrew
  7. awholtsIT

    if then statement help

    SQL 2005 I'm trying to eliminate a division by zero issue. Can someone assist with proper syntax for a statement like; if sum(Field 1)[denominator] = 0 then 0 else sum(field 2)[numerator]/sum(field 1) [denominator] Fields 1 and 2 also need to be summed. I keep getting an invalid expression...
  8. awholtsIT

    joining item master to item Location issue

    That was it. Many thanks for your help. Andrew
  9. awholtsIT

    joining item master to item Location issue

    SQL 2005 Table A (Item Master) Table B (Item Location) There is 1 record for every item in the item master TABLE A. There are 3 records for every item in the item location table, TABLE B. I want to join the (2) tables and have the results be just 1 record per item where the quantities in...
  10. awholtsIT

    joining sales header table to (2) different sales line tables

    SQL 2005 we have a situation where we have a master sales header table that holds all sales records, however, we have (2) sales line tables, with unlike data structures that hold the aggregate of the sales lines that are associated with the headers. table A = sales header (3 records, 2 from B...
  11. awholtsIT

    Which to use, Nested Case or Nested If?

    That worked perfectly. Many Thanks!! Andrew
  12. awholtsIT

    Which to use, Nested Case or Nested If?

    Not sure the best practice for accomplishing this requirement in a select query; I want to query FIELD 1 in Table A if FIELD 1 = ABC then query another field for it's value if FIELD 2 = XYZ then 2 else - 2 else 0 the result of this query...
  13. awholtsIT

    How to aelect subsets of query - Not TOP

    The data will eventually be imported into an accounting application that requires that the import file be an Excel file format. So the query results will have to be broken into 3 separate Excel files due to the limitation of rows in an Excel file. I don't know how to programtically isolate the...
  14. awholtsIT

    How to aelect subsets of query - Not TOP

    I have a query set result of 135,000 records that I need to get into Excel. Excel is limited to about 65,000 rows. I'm aware of the TOP function where I could select the TOP 65,000, leaving me with the remaining or bottom 70,000 records in the query results to get into a second Excel file...
  15. awholtsIT

    Query Help

    I'm having a problem with the syntax. I have written the following; select b.field1, case when b.field1 > 0 then b.field1 else null as b.field2 end case when b.field1 =< 0 then b.field1 else null as b.field3 end from MyTable I get the following error message; Msg 156, Level 15...
  16. awholtsIT

    Query Help

    I want to query a column from a table, evaluate the value in that column (column 1). If the value in column 1 is > 0, input that value into column 2, if the value in column A is < 0, input that value from column 1 into column 3. ex: column 1 column 2 column 3 -5...
  17. awholtsIT

    How to create a Global Distribution List with external email accounts

    I want to create a global distribution list that will include both, corporate email accounts from our GAL, and also, a few external email accounts. ex: A distribution list with both corporate staff and staff from a consulting firm that we are working on a project with. Appreciate your...
  18. awholtsIT

    Linking inventory master table to sales order history

    I want to link my inventory master to my sales history to display sales by item (sku). The issue is, I want to return all items from the inventory master, even if they have no sales. (Not have a corresponding record in the sales history table). Once I link the two tables, all items without...
  19. awholtsIT

    Crystal 8.x Varablize Grouping?

    I finally get it. Works perfectly as desired. Many thanks to you both. Andrew
  20. awholtsIT

    Crystal 8.x Varablize Grouping?

    Thanks for the reply. I need a little hand holding with the parameter and formula. Do I need to create a single parameter {GroupParam} that incorporated all 3 fields, or 3 individual parameters that the formula will call? {GroupParam}? If a single, how do I do that? Thanks again, Andrew

Part and Inventory Search

Back
Top