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

    Program fails when using scheduler

    Hello, we have a program running on a windows 2000 server. This programs loads data from excel files into a database. The program needs an excel addin to work properly. This addin in enabled in Excel and the addin is located in the user profile (lets call it X) which is used to start the...
  2. AtomicWedgie

    SQL teaser return 5th item

    Hi, as long as the valus are distinct this should also work. Then at least the order of the numbers should not matter. select * from (select top 5 * from #teaser union all select top 4 * from #teaser) x group by id having count(*) = 1 Atomic Wedgie i also tried select top 5 * from #teaser...
  3. AtomicWedgie

    Joining a table to two fields

    Damn, doesn't that work anymore in SQL 2005, that sucks. I totally find it impossible to read the ansi syntax. Well maybe the code was better then but the prinicpal idea of using aliasses was the clue. Regards, Atomic Wedgie
  4. AtomicWedgie

    Joining a table to two fields

    Gee, just because Crowley16 rewrites my solution in ansi syntax he gets credits and me not :-(
  5. AtomicWedgie

    Joining a table to two fields

    select * from players as playes1 , players as players2 , games where players1.id = games.player1_id and players2.id = games.player2_id
  6. AtomicWedgie

    Do not show value in Excel graph

    Thanks GlennUK, works great Atomic Wedgie
  7. AtomicWedgie

    Do not show value in Excel graph

    Hello, I have a graph which has a formula (IF) as input. However if the formula returns no value it is still represented as a 0 value in the chart. If the formula returns no result the item should also not be shown in the graph. Can anybody tell me how to fix this. Thatnks in advance, Atomic...
  8. AtomicWedgie

    Difficulty in understanding sql syntax

    Hi, I have some SQL statements that were developped by someone else and I am having a very hard time in understanding what the syntax does. Could anybody enlighten me? UPDATE Table_X SET Field1 = (SELECT avg(FIELD1) FROM Table_B WHERE Table_A.FIELD2 =...
  9. AtomicWedgie

    Load data in Excel

    Hi, tried it but doesn't seem to work. Thanks anyway
  10. AtomicWedgie

    Load data in Excel

    Hello, I have a result from a query which I want to load into an excel file. The problem is that in my result I have an 18-digit number. Excel reads this as a number (1.9098090920-E09 or something) but it should regard it as text. Is it possible to create the query in such a way that Excel...
  11. AtomicWedgie

    How old is a person

    select datediff(yyyy,[date of birth], getdate())
  12. AtomicWedgie

    Single row results

    SELECT N.ANSOS_ID,N.NURS_NAME, S1.STAFF_SHIFT AS 'SHIFT1' , S1.START_TIME AS 'START1' , S2.STAFF_SHIFT AS 'SHIFT2' , S2.START_TIME AS 'START2' , S3.STAFF_SHIFT AS 'SHIFT3' , S3.START_TIME AS 'START3' , <==problem right there FROM NURS N...
  13. AtomicWedgie

    SQL Puzzle #... 9?: Make 28 out of 4 values

    Hi SQLDenis, your solution: select 4*(5+6/3) is indeed interesting considering the allowed values are 2,3,4 and 5 Regards, Atomic Wedgie
  14. AtomicWedgie

    eliminating duplicate rows

    select distinct code, account, amount from ( select CodeMaster.code, BCM.Account, Fund.fundID as procureID, 'Cntr&ObjCdFcAmt'=Convert(nvarchar(20), ((select Sum (amount) from Fund FC join CodeMaster COM on COM.coaID = FC.debitCOAID join...
  15. AtomicWedgie

    SQL Puzzle #... 9?: Make 28 out of 4 values

    how about this select ((5*2)-3)*4 Regards, atomic wedgie
  16. AtomicWedgie

    Select based on various conditions

    Hi, maybe a bit dirty but I think this should also work select line, dept, pr, et from table where et is null union select line, dept, pr, max(et) from table where line & dept & pr (if you have id, replace with id) not in (select distinct line & dept & pr from table where et is null) group by...
  17. AtomicWedgie

    Declare variable for in statement in where clause

    '4','15','22','23','26','28','32','39'
  18. AtomicWedgie

    DTS package editing

    Hello, look at Workflow (On completion, On Success, On Failure). Regards, Atomic Wedgie
  19. AtomicWedgie

    Question on value

    Hi, what if you put the HAVING cb.CurrentBalance <> [balance] in the WHERE/AND AND cb.CurrentBalance <> [balance] AND cb.CurrentBalance <> 0.00 and then reomove the having completely Regards, Atomic Wedgie
  20. AtomicWedgie

    SQL server Database Backup

    Hi, maybe you will be more succesfull with your question when posting in the Setup and Administration forum? Regards, AW

Part and Inventory Search

Back
Top