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!

Recent content by inarobis

  1. inarobis

    Have a flat result?

    Hello guys, I would like to have a flat result of this query result. This is my result doing my normal query with left join and inner join throught tables (PHONE, PERSON, EMAIL, ADDRESS ) Phone eMail City Fax Mariam 2135262...
  2. inarobis

    Modelisation problem?

    Hello SQLSister, Thank you very much for your time and advice. I will do as you advice me much more easy for queries. I was totally fixed on this problem of different type of answer and did not go forward to another solution. :o I put reserved word for table only for this first modelisation (I...
  3. inarobis

    Modelisation problem?

    Hello Guys, I have a question: I would like to build a flexible question tool. These are the main tables for the moment. /*This table is question table; Question ID, The kind of answer (Text, integer or list), QuestionType (this is for script), Question Text) CREATE TABLE...
  4. inarobis

    Run batch file from sql server into into share drive ???

    Thanks I will check that Concerning the sqlservice user I try to change the job's ownership but no way it doesn't work I will be doing more test as soon. Thanks a bunch ina
  5. inarobis

    Run batch file from sql server into into share drive ???

    First of all Thank you very much. When I launch from EM/Management/SQl Agent / Jobs my job I have no error message from this step (run batch file) but when I run it from Query Analyser I have that: Output = Null I have allowed full permission for this share to sqlservice and both service...
  6. inarobis

    Run batch file from sql server into into share drive ???

    Hello Guys, I have a problem with a job moving and zipping file to share drive What does my Batch? 1) Copy backup device (initially in D:/) into //SERVER/SHARE/Archived_Backups/ 2) Create new folder in //SERVER/SHARE/Archived_Backups/ 3) Move the DEVICE into this...
  7. inarobis

    IF EXIST (SET SELECT ) <> NULL -- Suggestions ??

    This is my new select with a join what I would like to do it is to select all the difference between #QT1 and QT and if in the table QT doesn't exist I would like to insert into it (sometimes the date doesn't exist in QT so I need to insert into the two record depends on the type) SO I would...
  8. inarobis

    IF EXIST (SET SELECT ) <> NULL -- Suggestions ??

    One more question how can I do something like this /* if this condition is not null */ IF EXISTS (SELECT DATE, VALUE_, S, T FROM WHERE QT1.SC = 7 and QT1.code= 1476 and (QT1.DATE and QT1.T ) not in (SELECT QT.DATE...
  9. inarobis

    IF EXIST (SET SELECT ) <> NULL -- Suggestions ??

    Thanks it is works if the code = 1476 but when I put this code in a Loop for each @CODEId do this TEST doesn't insert into. Why? Thanks again Ina
  10. inarobis

    IF EXIST (SET SELECT ) <> NULL -- Suggestions ??

    Hello Guys, I have question concerning IF EXISTS (this statement is not correct but I would like to test if this select statement is true, if it is I qould like to insert the @DATE, @VALUE_, @S, @T of table @QT1 into the table QT) I would like to do a test: DECLARE @DATE_ datetime DECLARE...
  11. inarobis

    String Manipulation (substring) Xpath Question

    Thank you again! Now things are much more clearer in my head now. Thank you for your help. Ina
  12. inarobis

    String Manipulation (substring) Xpath Question

    Thank you! :) I will try that. I am not very strong on xslt extension as here xmlns:r and did not understant the http://regions.data. Ina
  13. inarobis

    String Manipulation (substring) Xpath Question

    Hello guys, I have question about manipulation string with XPath I would like to know how can I transform something like this: North America in NOR_AME So The first three letter of the first word and others 3 letter of the second word. I have liste of regions: Asia ASI Pacific PAC...
  14. inarobis

    Query very slow - help

    Thank Arrowhouse and SQLSister for this help very cool because I could understant my mistake. I read some topics about indexes and now my query is very fast. Now i update and after i insert missing rows as SQLsister proposed to me and it works fine. I have question when I do left join I do...
  15. inarobis

    Query very slow - help

    thanks guys Maybe I need to read some books and documentations because I am not familiar with indexes in tables and do not kwon if the tables in system I am working on are indexed. :) Thanks
See more

Part and Inventory Search

Back
Top