Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

I have some problem with this query as it doesn't return any difference between table1 and table2 even if table2 is less upto date than table1 ina

Thank you for this help. I will be trying it. Every week I need to update this table from informations coming from a xml file that i transform in a temp table. So there is the checks for "insert into" and for "update" as I need to do an update of rows whose value is different from table1...

Hello Try that ALTER TABLE <table name> ALTER COLUMN F_USER nvarchar(50) NULL ina

Hello guys, I have a query that works fine but it it really really slow. Could someone help to make this operation a little bit more viable. :o The table1 is identical and more up to date than table2, so it consists to check if a date exists in the table2 and if the date doesn't exist table2...

Hello George, Thank you a lot for this help, really help. Now I am working on it. Thank you once again Ina