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

    How to Extract Data from MYSQL in XML format

    I would like to use PHP to extract data from MYSQL and have it stored in XML format in much the same way as a dot net dataset stored data from a database. The reason being I want to use XSLT to format my data for display. Does anyone know if this is possible and if so could they point me in...
  2. StoneDeCroze

    INSERT Performance

    Hi All, I have two tables and I want to insert data from them into a third table. Question: Am I better to write two inserts statements e.g. INSERT INTO table3 (field1, field2) SELECT field1, field2 FROM table1 and INSERT INTO table3 (field1, field2) SELECT field1, field2 FROM table2 OR one...
  3. StoneDeCroze

    Which of these is faster?

    Hi Guys, Anyone know whis of these will be faster: @ASWN is a DECIMAL(18,6) @ID is an INT IF @ASWN > 0 UPDATE table SET field1=@ASWN WHERE ID=@ID or UPDATE table SET field1=@ASWN WHERE ID=@ID AND @ASWN > 0 Logically they are the same: The first results in the execution of one or two...
  4. StoneDeCroze

    Performance Boost (using tamp tables)

    Y'all prolly know this, but having just found out for myself I thought I'd share a performance snippet. I needed to create a running total - found the SQL for that okay - but the performance was pants, so with a bit of fiddling ... My Tip (works for me anyway). 1) SELECT the data into a temp...
  5. StoneDeCroze

    Client Data and Transaction DDL

    Hi all, For a purple star can anyone tell me if there is a public DTD for describing a Client's information including transaction history (cash and stocks)? I really don't want to go re-inventing the wheel. Kind regards Peter
  6. StoneDeCroze

    Permission to open view not table

    Hi All, Is it possible to set up permissions so a user can open and see data in a view, but not open and see data in the underlying tables? I have tried denying access to the tables and granting to the views, but this doesn't work. The overall effect is denial. If it can be done, can someone...
  7. StoneDeCroze

    Security on Win2k

    Hi All, I would like users to only be able to view data through views and NOT directly from the underlying tables as I want to filter out certain records. However, if I set denydatareader on the table the users are get Access Denied when they open the views (even if they have read permissions...
  8. StoneDeCroze

    DELETE FROM in a stored procedure

    MS SQL 7 Has anyone else encountered a problem whereby a stored procedure hangs when you issue a delete statement that for some reason has nothing to delete? e.g. If I issue the following in a stored procedure (silly example I know ) it hangs: DELETE FROM sometable WHERE 1=2 I am having to...
  9. StoneDeCroze

    Cross Database Query

    Hi all, I am using MS SQL 7 with two databases Question: is there a performance issue in creating a view in one datase base that accesses data in another? i.e. is SQL quicker doing this from Database1 or Database2 or is there no difference? SELECT * FROM database1.dbo.DATATABLE I have done...
  10. StoneDeCroze

    Which of the following is the fastest at variable assignment

    Hi All, Got a fairly long procedure that I am trying to speed up in anyway possible. Can any one tell me which is faster out of the following: SET @Variable = 0 SELECT @Variable = 0 I reckon it's the first one, but I would like to know for sure. Thanks Peter
  11. StoneDeCroze

    Problem importing xml.dom and xml.minidom

    Can anyone help? If I run Python interactively any or all of the three following lines work: import xml import xml.dom import xml.minidom However when I create a script and run it, the only one to work is: import xml The other two produce the following error: Traceback (most recent call last)...
  12. StoneDeCroze

    Python Script in an SQL DTS Package

    I would like to write the scripts in my SQL DTS packages in PYTHON. I have selected the right language from the list and written a few lines - but I always get the same error: "ActiveX Scripting was not able to initialize the script execution engine." Any ideas?

Part and Inventory Search

Back
Top