Viewing 15 posts - 31 through 45 (of 57 total)
I think your suffering from having multiple rowsets problem generated from your procedure. While in your case its just a single rowset. You need to flush the rowset from the...
March 17, 2004 at 2:21 pm
Question 1)
When you state job you mean a Sql Agent Tasks correct? i.e. something created with t-sql sp_add_job.
Not that I'm aware of.
Check out Gert Drapers presentation to PNWSSQL from July...
March 17, 2004 at 12:48 pm
Check out OPENXML. http://msdn.microsoft.com/library/en-us/xmlsql/ac_openxml_1cx8.asp
Allot depends on how you want to map the elements of your XML to relational data base tables.
Peter Evanns (__PETER Peter_)
March 17, 2004 at 11:34 am
Can I infer that you aren't using XML via the FOR XML clause for the task now and using another way to get it to XML?
I ask because I...
March 17, 2004 at 11:00 am
Sounds like what you want is this upcoming SQL Server 2005 feature in the update to T-SQL for SS2k5
Peter Evans (__PETER Peter_)
C&P from http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_fa-fz_90rs.asp
The new PIVOT...
March 16, 2004 at 9:16 pm
Here's a link to the PSNWSQL (Pacific Northwest Sql Server Users Group) formerly associated with the acronym PNWSSUG.
http://groups.msn.com/pnwsql/ If you join the MSN community you should be able...
March 16, 2004 at 9:02 pm
Something else to consider is also setting up a silent custom installation script using the Sql Server setup templates available on the the setup CD. With these you can develop...
March 16, 2004 at 8:29 pm
Another interesting thing to note is that if you use a lot of columns and use ADO to update records you can get double the number of columns sent in...
March 16, 2004 at 8:11 pm
I think the short answer to your question is NO.
The graph of dependicies genearatable in this way is limited to those dependencies scoped with the DRI and other referential...
March 16, 2004 at 7:45 pm
The hard thing about this problem is tracking the work you've done and
the work remaining. Ideally you want to be able to track a logical transaction against the large...
March 16, 2004 at 6:21 pm
Yes! The User does need a login with the SQL Server instance that has the permissions and roles to perform the steps and...
March 16, 2004 at 3:25 am
Why bother with the TABLE variable?
declare @rows int
set @rows = 0
while (@rows < 100000)
begin
delete con.dbo.acct
from (
select TOP 1000 a.consumer_id as [ID]
from
consumer.dbo.acct a(nolock)
...
March 16, 2004 at 2:25 am
Your second query implicitly removes the
(or B.intLanguage is null)
test by moving the test
from the join condition
to the predicate condition.
Remember the JOIN QUALIFIER tells...
March 16, 2004 at 1:37 am
Francisco I think the query below will fix your broken exists query so that you can do the benchmark.
SELECT
MIo.MachInstallID AS CurrentInstallID,
MIo.ActiveServiceDlrID AS ServicedByID,
MIo.InstallDate AS CurrentInstallDate,
MIo.MachineID,
MIo.entryTIME
FROM
dbo.tbl_MachineInstalls...
March 16, 2004 at 1:09 am
Sergio,
This sounds like an opportunity to use the partitioned views feature of SQL Server instead of going with the dynamic sql hack. I agree with Jonathan that violating this...
March 16, 2004 at 12:28 am
Viewing 15 posts - 31 through 45 (of 57 total)