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

  • Users: inarobis
  • Content: Threads
  • Order by date
  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 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...
  3. 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...
  4. 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...
  5. 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...
  6. inarobis

    Query very slow - help

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

    IF true Update -- help

    Hello, I have two identical tables (same structure) but one table is more up to date of the other one. I would like to tableA.date = tableB.date update the tableB.value if the tableA.value <> tableB.value for tableA.date = tableB.date So I would like to do if it is possible : if (...
  8. inarobis

    How to do sql statement with except

    Hello all, I would like to have all the elements belong to this record = 'Geo' but not the element = 'USA; Any idea? Ina This is my query ================ select distinct record.element as element from record where record.Type = 'Geo' except (select record.element as element from...
  9. inarobis

    Group by with Xquery

    Hello guys, I have this Xquery statement and I would like to do a group by date but unfortunately doesn't work well Someone knows it? Any suggestion? <TEST> { for $i in doc("transformXQUERY.xml")//TableID/TableRoom let $A := $i/A let $B := $i/B let $cs-group :=...
  10. inarobis

    Select Group by issue

    Hello I have this data and I would like to group them Have these record Date ID A B 12.07.2005 1 450 12.07.2005 1 124 12.07.2005 2 340 12.07.2005 2 145...
  11. inarobis

    xsl:key with condition? question

    Hello Guys, I am new to this forum and to xml too and I have a problem: I would like to loop according to two parameter 8key) the roomName and price date but I do not know how to do that? I got this result with my xsl file that with my xls transformation: ... <TableRoom>...
  12. inarobis

    Get the same Id in nodes

    Hello Guys. So This is my xml file and I would like to have the same ID in TABLEID and TABLEROOM <?xml version="1.0"?> <root> <Rooms> <Room> <RommName>Suite</RommName> <Informations> <I> <Currency>USD</Currency> <Information>Internet</Information> </I> <price> <A Date="31.01.2005">...
  13. inarobis

    apply-templates problem

    Hello guys, I am newbie and I am blocked in this issue about apply-templates...Could someone give me suggestion how to solve that xml file <root> <Item1> <Currency>USD</Currency> <Information>Internet</Information> </Iteml> <Rooms> <A Date="31.01.2005"> 100</A> <A...
  14. inarobis

    Change text value / with _

    Hello all, My name is ina and I am newbie in xsl and I would like to know how can I change it <Style> <Strategy> <Strategy_Style>Geo\Asia</Strategy_Style> <Strategy_Style>Geo\America</Strategy_Style> <Strategy_Style>Geo\Europe</Strategy_Style>...
  15. inarobis

    Set up a condition in a query

    Hello guys, I have a question about a sql query so I have these 5 tables there are 5 tables Room, RommRent, DBSource, RoomType, RoomRealCode SELECT Room.idCode, RoomRent.Label, MAX(chambrerent.[TimeStamp]), RoomRent.TreeID FROM RoomRent INNER JOIN DBsource ON RoomRent.DBSource_ID =...
  16. inarobis

    Restore Process Problem - Help

    Hello guys, I need super help :( I would like to restore a database and I tried everything! use master RESTORE DATABASE Test_prod from disk= 'e:\MSSQL\BACKUP\TESTSANDBOXBACKUP.BAK' WITH RECOVERY -- Apply the first transaction log backup. RESTORE LOG Test_prod from disk=...
  17. inarobis

    join between two databases

    hello, I have question about how to join to table from different databases. How Can I do a map table between this two databases? For example (in two different software) table 1 database 1 clientcode table1 database 2 clientNameCode I would like to obtain this two data in one table how to...
  18. inarobis

    Mapping table between 2 databases

    Hello all, I have one question about mapping table: So I have 2 table in two different database: table1/database1 (id ClientCode age ) table2/database2 (id ClientName adress ) I would like to do a mapping table between my 2 tables in sort the 2 database can communicate together table3 (...
  19. inarobis

    problem with a stored procedure

    Hello guys, I have a problem with a stored procedure in sql server. I would like to execute this query declare @sSQL varchar(255) SET @sSQL = 'SELECT TOP 1 [value], date, name, [times] FROM (SELECT value, date, times, name FROM view...
  20. inarobis

    Need help with a max query

    I have this view: SELECT MAX(DERIVEDTBL.[Time]) AS Time, DERIVEDTBL.[Value], DERIVEDTBL.Date, MIN(DISTINCT DERIVEDTBL.Name) AS name FROM (SELECT * FROM f_view -- another view WHERE (Date =...

Part and Inventory Search

Back
Top