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 Wanet Telecoms Ltd 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 jjlbmcnews

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

Part and Inventory Search

Back
Top