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: jjlbmcnews
  • Order by date
  1. jjlbmcnews

    Generating an insert statement

    Ah, did I mention that this was in Oracle?
  2. jjlbmcnews

    Generating an insert statement

    I need to generate a number of insert statements using the results of a select statement. Basically I have the following statement - insert into table1 select table1.column1, value1 from table1 where table1.column2=value2 and table1.column1 not in (select table1.column1 from table1 where...
  3. jjlbmcnews

    Generate multiple statements

    Hi, I need to issue a number of insert statements and I know theres a way to generate all the statements dynamically so that I don't have to type each statement but I can't for the life of me remember how to do it. I know its something like select 'abc' = 'insert into table1 (field1, field2)...
  4. jjlbmcnews

    Scheduled DTS job never completes

    It shouldn't be getting hung for resources as this server is not being over used, also the DTS package executes fine. Yes, I've refreshed the EM several times and it doesn't make a blind bit of difference.
  5. jjlbmcnews

    Scheduled DTS job never completes

    Hi, I have a DTS package that I have put together that pulls data from Oracle into MSSQL 2000. The actual package works fine as I'm able to execute it and it completes. I then schedule this package to run at a specific time every night and it executes but it never completes. The status just...
  6. jjlbmcnews

    XP and Printing Issues

    Hi, We're having a strange problem with printing from XP. Basically we've got an application that prints multiple files, this all seems to work fine and the machine spools with out a problem however it never actually invokes or the printer or sends the job to the printer. Has anyone ever seen...
  7. jjlbmcnews

    Re: Redirect a direct access URL

    Hi DaZZleD, I've posted this in the ASP forum.
  8. jjlbmcnews

    Re: Redirect direct URL

    Hi, Some of our clients use what we call outlogins, which contain the credentials required to log directly into our site. Bascially the scripts look like this - <html> <body onload="document.logon.submit()"> <form method="post" action="http://www.mysite.com/application.exe/login"...
  9. jjlbmcnews

    Re: Redirect a direct access URL

    Hi, Some of our clients use what we call outlogins, which contain the credentials required to log directly into our site. Bascially the scripts look like this - <html> <body onload="document.logon.submit()"> <form method="post" action="http://www.mysite.com/application.exe/login"...
  10. jjlbmcnews

    More efficent way to do the following...

    Hi, I'm looking for a way to do the following in a more efficent way within a stored procedure. Basically the SP will return certain rows depending on the filters, it was all done originally as dynamic SQL but had to be reviewed due to performance. I've managed to rewrite most of the SP using...
  11. jjlbmcnews

    Inconsistent query performance

    Thanks for the reply, I think I have competing tasks! Whats the best way to trouble shot these?
  12. jjlbmcnews

    Inconsistent query performance

    Hi, This is a really stupid question but I'm completely baffled. I have a query that runs, some days it takes a couple of hours to complete and some days it takes six hours to complete. I can't work out why, I've ran traces and all sorts of stuff but I can't explain why it performs better on...
  13. jjlbmcnews

    Does anybody know whats wrong with this query?

    That doesn't work, I still get the same error.
  14. jjlbmcnews

    Does anybody know whats wrong with this query?

    It can't be that line as when I take the @Time section out the @Sector section works fine, its got something to do with the @Time section but I don't know what.
  15. jjlbmcnews

    Does anybody know whats wrong with this query?

    Hi, I'm trying to run this query but it keeps complaining about Line 90 incorrect syntax near 'IN'. I can't see whats wrong, can anybody else? CREATE PROCEDURE [dbo].[HgGetDistributionListjjl] (@Date varchar(11), @Sector varchar(8000), @Time varchar(200), @Country int, @Language int, @PubType...
  16. jjlbmcnews

    Problem with query

    Hi, Can any one tell me what is wrong with this query as I can't see what the QA is complaining about! I keep getting incorrect syntax near >. DECLARE @Country INT DECLARE @Language INT DECLARE @PubType VARCHAR(1000) DECLARE @CountryID INT DECLARE @LanguageID INT SELECT Account AS...
  17. jjlbmcnews

    Re: IF....THEN....ELSE

    Hi, Don't think I can as it basically looks like this - DECLARE @Country INT DECLARE @Language INT DECLARE @PubType VARCHAR(1000) DECLARE @CountryID INT DECLARE @LanguageID INT IF @Country <> 0 OR @Language <> 0 OR @PubType <> '' BEGIN SELECT Account AS 'BriefCode', Custom1 AS 'Status'...
  18. jjlbmcnews

    Re: IF....THEN....ELSE

    Hi, I have a stored procedure that depending on various conditions executes differently. Now I really can't get my head around how this will work, basically I have a standard SELECT query, if one or any of three conditions are true I want the select query to perform a JOIN to another table and...
  19. jjlbmcnews

    sysprocesses and waitresource column

    Hi, Does anyone know how to decode the waitresource column in the sysprocesses table? I need to determine what this means and I haven't found any documentation on it, can anyone offer any assistance?
  20. jjlbmcnews

    How can I stop replication replicating deletes?

    Hi, I use transactional replication to replicate some data from one DB to another. Problem is I require one of the tables to only have INSERT and UPDATE commands replicated, not DELETE commands, I have done some studying but I can't see away to do this. Can anyone offer any advice/assistance?

Part and Inventory Search

Back
Top