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 derfloh 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: *

  • Users: NSMan
  • Order by date
  1. NSMan

    case to determine which field from which table?

    I'm not sure I understand what you're trying to do, but if I am understanding right, you have three tables you're selecting on. Assuming all of them are joined later in the select statement, would this work? select account.account_id, account.ndc, account.startdate, case when...
  2. NSMan

    What are the advantages to converting to a multi-table design vs one h

    Our company currently provides several software systems that utilize SQL Server as a back end. Up to this point in time, our data structure has been stored in one huge table with generic field names (Field001, Field002, ect.). There is no way to make our software work with more fields...
  3. NSMan

    How can I print new groups on odd pages?

    Sorry, I'd created a formula and set the @nspage to the pagenumber. That worked! I owe you big, I get to go to bed before tomorrow morning now, mucho gracias!
  4. NSMan

    How can I print new groups on odd pages?

    I've got a report that is grouping on the first left character of a field. I've got a "New Page Before" on my group header. Each time the next group starts on an even page, I want to skip another page and so the beggining of each group is printing on an odd page. I've tried putting a formula...
  5. NSMan

    Duplexing with custom paper sizes...

    I'm trying to duplex 11X14 paper on a Savin MLP32, and the printer is just printing the even pages. Any idea on how to make printers duplex custom paper sizes?
  6. NSMan

    Idle Time

    Don't know if this will help you or not. Select * from phone Results phonelog --------- 441 442 443 444 447 448 449 select a.phonelog as StartIdleTime, min(b.phonelog) as EndIdleTime from phone a, phone b where a.phonelog<b.phonelog group by a.phonelog having...
  7. NSMan

    Margins &amp; Duplex

    Hopefully this is just a stupid problem with a simple answer. I am trying to use a Crystal report to print 11X17 duplexed paper that will go into books. On the left edge of the page, (binding edge), I need about a .8in margin for the binding. The problem is, when I print with a .8in margin on...
  8. NSMan

    Copying and deleting files with wildcards issue

    I'm no sql guru like most of the folks around here, so take any suggestions with a grain of salt... Does a path to each of these files already exist inside your sql table? What is the criteria for the files you want to copy? Everything from a specific directory, everything from a specific...
  9. NSMan

    An aggregate may not appear in the set list of an UPDATE statement...

    Oh yeah...derived tables...thanks! About the grouping on a1, it was just an empty field, and I figured that might be what was hanging up the update statement...
  10. NSMan

    An aggregate may not appear in the set list of an UPDATE statement...

    update parent set parent.a1=count(child.id) from object parent, object child where parent.typ=2 and child.typ=4 and parent.id=child.link1 group by child.link1, parent.id, parent.a1
  11. NSMan

    An aggregate may not appear in the set list of an UPDATE statement...

    Grrr....Apparantly SQL doesn't like the idea of using aggregate's in an update statement. I'm using the following select statement to select a count of children records, and link them to parent records. Problem is, when I try to run an update off of this statement, SQL politly informs me that...
  12. NSMan

    Wierd SQL...

    correction, the two tables look like this... object2 ----------------- id|count 33 1 34 2 35 3 imglinks ----------------- ilinkid|objidref|count 23 33 1 24 33 2 25 33 3 and I'm able to update my objidref field based on the id in the object2 derived table with...
  13. NSMan

    Wierd SQL...

    I believe I just got it. It isn't pretty, but basicly I just do a count on both the imglinks table, and the userdata, (object) table with a criteria that filters out my newly scanned images, and then links the ilinks table to the object table using the running count of my ilinks records, and...
  14. NSMan

    Wierd SQL...

    I'm trying to so something with SQL that I can't quite get a handle on. I have a program that is supposed to be able to handle batch scanning. When it scans multiple pages, it links them all to one record that may be defined in scripting code, but it doesn't support linking each individual...
  15. NSMan

    How can I make QA say 1/2=.5 instead of 1/2=0?

    Well, that isn't the exact syntax :p I'm working with a datastructure that doesn't make a whole lot of sense to somebody who has never deal with it. Basicly it is one hudge flat file called object, with 50 different fields which allows the table to store completly different data types into one...
  16. NSMan

    How can I make QA say 1/2=.5 instead of 1/2=0?

    *Beats head against desk repeatedly* Thank you very much!
  17. NSMan

    How can I make QA say 1/2=.5 instead of 1/2=0?

    Maybe I oversimplified my question. I'm actualy trying to do a count, divide the result into 100, do another count based on groups, and figure out what percentage of the whole count a group consists of. A simplified version would look something like this... select count(id)/(select count(id)...
  18. NSMan

    How can I make QA say 1/2=.5 instead of 1/2=0?

    I know this sounds like a dumb question, and I am currently looking through the SQL Books Online, but I figured somebody out there might have a quick answer for me...
  19. NSMan

    Getting a column list using QA?

    Talk about quick service! Thanks!
  20. NSMan

    Getting a column list using QA?

    Is there a way to select the property of a table, and have Query Anylyzer return a list of columns that exist in the table?

Part and Inventory Search

Back
Top