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

  • Users: ratinakage
  • Content: Threads
  • Order by date
  1. ratinakage

    INSERT SELECT from multiple tables

    Hi there, I am wanting to run an insert that uses two values form two select statements. I think it should be clear what I'm trying to do. Basically get the two contact IDs for the first two values (and 4 for the relationship_type_id and 1 for is_active). INSERT INTO civicrm_relationship...
  2. ratinakage

    SP 2007: Is it possible to filter library by major version?

    Hi all, We would really like a filter (button or checkbox) that when viewing a library, you could switch on and off depending on whether you wanted to see major versions only or major and minor versions. So, for example, you would see version: my_doc_1.0.docx my_doc_1.1.docx my_doc_1.2.docx...
  3. ratinakage

    Need some help with my scrolling marquee. Only works after mouseover.

    Hi guys, I am pretty new to Javascript. I pulled some code of a tutorial website to make a scrolling marquee, then adjusted it to the size of my images. It seems to work OK. The only problem is, it only starts working when you put your mouse over it. I need to start scrolling automatically...
  4. ratinakage

    Disable a job step?

    Hey guys, I know you can disable a SQL job. What I want to know is, if anyone can think of a clever way to disable a job step? Basically, I want to create a big SQL job with all the steps disabled. Then as the users of my app turn certain things on, the job steps should become activated (or...
  5. ratinakage

    Simple OPENXML parsing question

    Hey guys, If you could run the following SQL command: I am trying to extract two Addendum elements from the xml string. DECLARE @string VARCHAR (50) SET @string = '<Request><Addendum>Addendum1</Addendum><Addendum>Addendum2</Addendum></Request>' DECLARE @xml_xml_ptr INT EXEC...
  6. ratinakage

    How to insert a 'Ñ' by using it's CHAR value.

    Hi guys, My sql programming it not the best. What I want to do is insert the String 'Ñ' into a table. But the OSQL parser I am using keeps turning this into a 'N'. Does anyone know another way to insert this string? Perhaps by means of Char or Asci values? Let me know. Thanks G
  7. ratinakage

    How do I update the last jobstep of a job?

    Hi all. I am trying to update the last job step in a job, before adding a final job step to the end of the job. In the below example, the last job step number is 5. but this is not always the case. Is there a way to ask SQL to update the last job step?? Thanks. exec msdb..sp_update_jobstep...

Part and Inventory Search

Back
Top