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!

Search results for query: *

  • Users: jjlbmcnews
  • Content: Threads
  • Order by date
  1. 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...
  2. 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)...
  3. 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...
  4. 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...
  5. 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"...
  6. 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"...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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?
  13. 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?
  14. jjlbmcnews

    Re: Word Wrap

    Hi, I generate an e-mail from an ASP script, problem is it contains a hyperlink but the hyperlink doesn't work as its wrapping the text and not all the details in the hyperlink can be used (does this make sense?).
  15. jjlbmcnews

    HTML and Lotus Notes

    Hi, We send HTML e-mails to a client, they run lotus notes but we send using exchange server/outlook clients. I believe that Notes will not display any HTML hence none of the hyperlinks will work and none of the graphics or colours in the e-mail will be displayed, is that true? Whats happens if...
  16. jjlbmcnews

    Replication - The process was succesfully stopped.

    I've implemented transactional replication, I had a few teething problems so I used the validate subscriptions option to see if I could get more information about what was going wrong. Since I've implemented this the distribution agent stops with the message &quot;the process was successfully...
  17. jjlbmcnews

    One Macro multiple sheets

    Hi, I have a macro that modifies the properties of a column within a sheet. I've set this up to use Auto_Open but it only runs on one sheet and not the other three. How can you force the macro to run on all the sheets in the workbook on open?
  18. jjlbmcnews

    Export to Excel

    Hi, I use DTS to export to excel, I've found a problem where by I can't total a column in Excel that contains a list of numbers even though the format of the cell in Excel is Number. This only seems to happen when I use DTS to export the rows to the spreadsheet, has anyone else experienced this?
  19. jjlbmcnews

    WA_SYS_

    If you had a lot of tables in your database that had indexes that started WA_SYS_ would this mean that the index design is not up to scratch? I understand these WA_SYS_ indexes to be indexes that have been created by the system because of a lack of correct indexes, does this sound about right?
  20. jjlbmcnews

    DTS completes but doesn't populate tables.

    Hi, I'm trying to replicate and transform some data from one database to another. No I've used all the wizards etc, etc.......to set this up and it all looks good but when I execute the replication it says its complete but the destination tables are empty. To give you a bit of background into...

Part and Inventory Search

Back
Top