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 Rhinorhino 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. thegiraffe

    INSERTing a row for each day of current month

    not sure on any of the actual coding but could you dateadd -1 day from the first of the following month to give you the last day of the month and assign the last day (day(variable)) to a variable (eg. lastday). then assign a vairable as 1 (eg. curday) then do a for loop for curday to lastday...
  2. thegiraffe

    Using Many Triggers on one table

    Can do this in ASP but i'm struggling to get my head round it here i want to select from a table if code = 101 (easy) just two things, how do i refer to fields within a selected record. (it may seem simple but its different to me) if theres more than one record that match how can i cycle...
  3. thegiraffe

    Using Many Triggers on one table

    Ok, i see where you're coming from here. I'm thinking two tables, ie. table 1 code, description, notes (these being the info i need) table 2 code, next_code this way i can have table 1 100, enter data 101, check data 102, check email 103, etc etc etc table 2 100, 101 100, 102 so when 100 is...
  4. thegiraffe

    Using Many Triggers on one table

    Unfortunately we have purchased a system, and my job is currently to write that system to do what we need, I have thought about the structure and extra tables, but i cannot change anything major in theirs and I can't change their GUI to view my tables. Also although there are generally the same...
  5. thegiraffe

    Using Many Triggers on one table

    I have a table that i have all pending tasks held in, there are many different stages with the innitial setup of a client record so there are many triggers on this pending table. It is already becoming quite a lengthy trigger, lots of if CODE = 100 insert this pending for run if CODE = 101...
  6. thegiraffe

    Should be quite simple - t-sql

    Is there a way to do a IF NOT EXISTS () Just for future reference Dave Theres nothing worse than an idea when its the only one we have!
  7. thegiraffe

    Should be quite simple - t-sql

    Thats cool too, i'm sure i'll find them both handy along the way. Cheers Dave Theres nothing worse than an idea when its the only one we have!
  8. thegiraffe

    Should be quite simple - t-sql

    Thats brilliant cheers, i'm used to using VBscript statements in ASP, never even touched on @@RowCount before (i have a lot to learn). Thanks Dave Theres nothing worse than an idea when its the only one we have!
  9. thegiraffe

    Should be quite simple - t-sql

    ASP programmer trying desperately to program in t-SQL! I want to check if a certain record exists in a table when the trigger runs, just lacking the knowledge (and currently mental capacity as i'm ill) to find the answer. I have a pending table, as jobs are confirmed (deleted) i am setting up...
  10. thegiraffe

    Scheduled jobs - where!!!!

    Thankyou, Found them myself about 5 minutes ago by clicking around, boy is my face red!!! Cheers for the help. Dave Theres nothing worse than an idea when its the only one we have!
  11. thegiraffe

    Scheduled jobs - where!!!!

    Hi, as my recent posts may suggest i'm just trying to get to grips with t-sql and i'm trying my hand at most sections. I am currently trying to get Sql to check my database once a month and setup new pending records accordingly. I've created my stored procedure, I even managed to schedule my...
  12. thegiraffe

    passing variables between triggers and stored procs

    Sorry my bad, What you told me was kind of whet i needed to know, i've just been informed by someone else exactly what i need to do and i've picked that out from your code too (now i know what i need to be looking for in your code, as i said, its all new to me!) Basically the bit i needed was...
  13. thegiraffe

    passing Variable

    Before you have <%Language=VBScript%> at the top try <% response.write &quot;<script LANGUAGE=&quot;&quot;JavaScript&quot;&quot;>nam1 = &quot;&quot;&quot; & nam & &quot;&quot;&quot;</script>&quot; %> This should define the variable in javascript and insert the value of nam into it. My last...
  14. thegiraffe

    passing variables between triggers and stored procs

    I need to create many triggers on a table each checking for different things (or i could whack them in one...) but I need to call the same procedure from many tables for many different reasons with only minimal data differences. Such as we have many status's of records, If a record ref BI has...
  15. thegiraffe

    SQL keeps stopping?????

    Check you event viewer and see if theres some kind of relevant message to do with SQL in there. The only time i've had this problem is when i hadn't registered my server correctly! Dave Theres nothing worse than an idea when its the only one we have!
  16. thegiraffe

    passing Variable

    The only way i know this is to response.write it all to the screen. response.write &quot;<script language=&quot;&quot;JavaScript&quot;&quot;>&quot; response.write &quot;ID1=BobForm.usrNam.value;&quot; response.write &quot;if(ID1 != &quot;&quot;&quot; & nam & &quot;&quot;&quot;)&quot...
  17. thegiraffe

    passing variables between triggers and stored procs

    Newbie to programming within t-sql but i'm slowly understanding it. My problem We are using an external piece of software but (with permission) are deveoping the back end to work more with our needs. When a new contact record is entered into a table I want it to check for a few things and on...
  18. thegiraffe

    Date driven T-sql Stored Procedure

    Cheers, I kind of have something working.... Done what you said, i can pull info through with different criteria and stuff, still not sure how to set this to be date based, and I'm still playing with statements to try and update stuff. Still haven't got the big picture as to how to run and...
  19. thegiraffe

    Date driven T-sql Stored Procedure

    Right, i know it can be done now, my only problem is I'm struggling to piece together a stored procedure, i need to walk before i can run i think. Really really sorry, I just need an initial push then i think i should be cool. All examples of stored procedures seem way complex, is there an...
  20. thegiraffe

    Date driven T-sql Stored Procedure

    A little out of my league..... I want to write a trigger / stored procedure to run on a pre defined day of the month (ie. the first), every month. I want it to run only once a month checking information from a sales table and setting up records to a pending table if my criteria is matched...

Part and Inventory Search

Back
Top