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...
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)...
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.
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...
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...
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"...
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"...
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...
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...
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.
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...
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...
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'...
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...
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?
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?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.