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

    Extracting Log in name / computer details in SQL

    Hey, Thanks all for these I have found the default trace option within SQL which gives some of the functionality that i was after however this doesn't really go into the detail that i needed. I have also found that you can script traces from profile which might be another way of going...
  2. CAFCrew

    Extracting Log in name / computer details in SQL

    hmm...thanks for this :). I am coming to the same conclusion.. i have been looking through the master db to see if there are any sp's in there that would help..haven't found anyway of actually working out who is doing what tho Thanks for taking the time to reply though. I appreciate it.
  3. CAFCrew

    Extracting Log in name / computer details in SQL

    HI All, We are building a application for users to make changes to the DB so we are building in some audit functionality to record who is doing what. The guy that is doing the application has been away so i was wondering whether there was any way that i can capture the log in information from...
  4. CAFCrew

    Cursor problem...not picking up all data in the next fetch.

    Hi, I am confused at your response, but thank you nonetheless for taking the time to look. The code that you have highlighted is part of the set based update that is grouping by idcol etc (fair point, the other columns aren't really needed...shouldn't really be creating a problem tho) the...
  5. CAFCrew

    Cursor problem...not picking up all data in the next fetch.

    HI All, After a little while out of the game i am getting back into coding in SQL, however i seem a bit rusty.. This cursor is not picking up the new @Auth code when it picks up the next @idcol of the next record in the loop can someone help me...i am sure its something really stupid but its...
  6. CAFCrew

    Create a table using a while loop

    cool. All seems to make sense :D Thanks again for this. Very helpful. Matt
  7. CAFCrew

    Create a table using a while loop

    Thanks Mufasa, I have had to slightly edit it to return the 1-23 as hours as it was putting them in the minutes, but apart from that small change it works perfectly. The : "substr('0000'||y,-4),x);" was a bit confusing. I am not sure what this is doing? I understand what you are setting...
  8. CAFCrew

    Create a table using a while loop

    Thats impressive. I dont really understand how it works though? I wrote code to temporarily do this and there were hundreds of lines of it! Thank you so much for this, its so much neater this way Matt
  9. CAFCrew

    Create a table using a while loop

    HI Everyone, I am fairly new to Oracle development having come from the world of TSQL and am struggling with the syntax slightly. I need to create a table that will find out a maximum ID from another table, then create a row for every ID from 0 - the maximum for every hour in the day. i.e...
  10. CAFCrew

    setting pagenumbers in subreports / Drill down reports

    Ignore that Lbass, I have had a play around with this, and it has worked :D Thank you very much. CC
  11. CAFCrew

    setting pagenumbers in subreports / Drill down reports

    HI Lbass, Thanks for this. That is what i am saying, but unfortunaltey I have already tried a selection of these type formulas, but they dont seem to work. Everytime you drill down the totals still appear. I need to find a way of convincing it that its not the last page, but then need a...
  12. CAFCrew

    setting pagenumbers in subreports / Drill down reports

    Hi guys, In the report footer section of a sub report I have a total based on the figures on all of the report. The sub report also provides a drill down of information contained on the main report that i want to appear at the end of the report should the user only want to see the top level...
  13. CAFCrew

    Simple Variable query

    Thanks Willif, i have done just that :D Apologies Dagon, i didn't realise that this was so important. I am truely very embarrased.I will try and stop this from now on.
  14. CAFCrew

    Simple Variable query

    Hey Mufasa (Dave of Sandy, Utah, USA), Thanks for this. This is exactly what i was after. There are a few subtle little difference with the way that the syntax is used and the error messages seem to be even less helpful than the ones thrown up by SQL!! The help pages of the program that i am...
  15. CAFCrew

    Simple Variable query

    p.s. i realise that there are errors in the logic of the above code, its just an example to give you an idea of the way in which i want to use the variables. Thanks again Matt
  16. CAFCrew

    Simple Variable query

    HI All, i am this is a very basic question but i am new to oracle syntax after 5 years of SQL and i am finding it hard to adapt. I am trying to work out how to use variables in oracle to do something similar to : declare @CompanyName char(100) declare @RMTID set @CompanyName = (select...
  17. CAFCrew

    Formula for sorting data in a bar chart error. Crystal XI

    Thanks Dan, no other responses as yet. Thanks for the tip on the software, but i think that its unlikely that the company will purchase more software based on this one problem. I will forward the question to business objects and if still no joy i suspect the client will be told that we are not...
  18. CAFCrew

    Formula for sorting data in a bar chart error. Crystal XI

    Hi Guys, I have a problem in Crystal XI that is very irritating. I am trying to do a conditional formula for the sort order on a Bar chart and am failing. If you run the report and then navigate into the formaula editer and create a formula then when you save and close the data changes to...
  19. CAFCrew

    Cursor question

    wow......thank you sooooo much for this. Your a total star :D I cant tell you how much i appreciate this....it was driving me mad
  20. CAFCrew

    Cursor question

    really...that would be handy. Its only SQL 2000 i am afraid. My company seem reluctant to upgrade for some reason! Thanks tho :D Matt

Part and Inventory Search

Back
Top