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

  1. jtarry

    Display Date Range As An Integer

    select statement select date1, date2, date1 - date2 from table required result: 28/02/11, 27/02/11, 1
  2. jtarry

    Display of field problem

    Thanks, just what I wanted John
  3. jtarry

    Display of field problem

    Hi I have a table: Part Serialno AA X01 AA X02 AA X03 etc want report to show on one line X01, X02, X03, etc Thanks
  4. jtarry

    List large list fields in a tabular format

    I need some advice. I require to present table information Table contains BOM parent BOM Child Qty 1234 AAA 1 1234 BBB 3 1234 CCC 6 1235 AAA 2 1235 CCC 2 etc etc etc I need to display this info...
  5. jtarry

    Convert datetime to integer

    Have have resolved my problem with DateDiff() function by inserting into a varable Thanks
  6. jtarry

    Convert datetime to integer

    I wish to update a table with an integer showing the difference between two dates. update table set fieldint = date1 - date2 Thanks
  7. jtarry

    Update Records from a second table

    Thanks
  8. jtarry

    Update Records from a second table

    I have tables containing supppart supp spart sqty 0100 AAA 0 0200 AAA 0 0300 AAA 0 0100 BBB 0 0200 CCC 0 order opart oqty AAA 1 BBB 1 CCC 1 I wish to update first table to show supp spart sqty 0100 AAA 1 0200 AAA 1 0200 AAA 1 0100 BBB 1 0200 CCC 1...
  9. jtarry

    Copy a File with a Date Stamp

    thanks
  10. jtarry

    Copy a File with a Date Stamp

    Hi, I want to create a batch file to copy another it location with a datestamp. Eg From: C:\mydoc\DATA.txt To: C:\mydoc\archive\DATA220610.txt The date stamp (220610) can be in any format. Thanks
  11. jtarry

    Insert total quantity based on number of transactions

    Hi, I have two tables Table a contains Part Number A 3 B 1 Table b (transactions) Serial Part Qty 1 A 2 2 C 1 3 A 1 4 B 2 5 A 1 6 A 2 7 A 1 8 B 1 I need to produce a...
  12. jtarry

    Error "Memory could not be Read" Running Some Crystal XI reports

    It is a memory issue. Old PCs with little memory the report doesnt run at all. New higher spec PCS the report works ok, but after a time and ther apps run it stops working. I was wondering if there are issues with particular versions of Crystal XI?
  13. jtarry

    Error "Memory could not be Read" Running Some Crystal XI reports

    I have some crystal reports which work sometimes but other times dont and get a microsoft message "Memory could not be Read". Log off PC and it then will load again. This happens on all PCs at various times. Any ideas to the problem?
  14. jtarry

    Select All Records Before Today In An SQL View

    Thanks, so simple when you know
  15. jtarry

    Select All Records Before Today In An SQL View

    Normally I would use: DECLARE @today AS datetime SET @today = getdate() select * from table where sdate <= @today This will not work in a view, what is the alternative. Thanks
  16. jtarry

    Email Crystal XI Reports without Purchasing Web Server

    I would like to overnight send report to users via email. I wish to distribute information from sql 2000. Is there a way of doing this without the purchase of the expensive web server?
  17. jtarry

    Insert Muliple Records into a Table with a Serial Field

    Thanks all sorted
  18. jtarry

    Insert Muliple Records into a Table with a Serial Field

    This is the insert statement I am trying: There is a serial number field in the table, I dont select it in the insert. insert into mastshed (mastpart,mastdate,mastqty,mastref,mastsale,mastitem,mastord, mastadj, masttype, mastissue, mastshdate, mastcommit, mastissueno) select...
  19. jtarry

    &quot;Insert&quot; trigger to insert muliple lines into 2nd table

    I have a table which contains a quantity value (say 3) table 1 Part Qty AAA 3 I want to insert into table 2 via a trigger Part Value AAA 1 AAA 2 AAA 3 thanks
  20. jtarry

    Select statement show partial field SQL 2005

    Thanks nicearms for your help as well

Part and Inventory Search

Back
Top