Yes,

A fairly complete example of one method to do so can be found here: http://www.sqlteam.com/item.asp?ItemID=19595

A google search on "SQL Server stored procedure run DTS" provides several other examples.

Hope this...

DECLARE @LiveRowCount BIGINT,

        @SqlCmd NVARCHAR(4000)

SET @SqlCmd = 'SELECT @RowCount = COUNT(*) FROM ' + QUOTENAME(@MyTableName)

EXEC sp_executesql @SqlCmd, N'@RowCount BIGINT OUT', @LiveRowCount OUT

IF @LiveRowCount > 0

        PRINT 'Row count =...

I am not an academic.  However, in my spare time, I am currently researching/analyzing/asessing the ability of various DB engines to serve as an engine, or framework, for autonomous AI, particularly...

hmmmmm.  while checking my post to make sure it wasn't truncated, I also noticed this...

SELECT    @ITemplate = i.Template

 , @IActionType = i.ActionType

 , @ICustCounter = i.CustCounter

 , @ProvisionSP = psp.ProvisionSP

 , @Template =...

G'day,

I cannot claim to know exactly what the problem might be.  However, for testing and debugging purposes, I would probably start by removing the join.  Leave your initial select from...

Expanded version of the earlier example:

CREATE TABLE TestTable (DateColumn VARCHAR(255),

                        StatusColumn INT)

GO

INSERT INTO TestTable (DateColumn) SELECT '6 JUNE 2005 11:58'

INSERT INTO TestTable (DateColumn) SELECT '5 JUNE 2005 11:58'

INSERT INTO TestTable...

Hi there,

Something like this might work.

CREATE TABLE TestTable (DateColumn VARCHAR(255),

                        StatusColumn INT)

GO

INSERT INTO TestTable (DateColumn) SELECT '6 JUNE 2005 11:58'

INSERT INTO TestTable (DateColumn) SELECT '1 JANUARY 2005 11:58'

GO

SELECT DATEDIFF(MONTH, CAST(DateColumn...

OK.  What are you trying to do with XML?

Wayne

hmmmm...  Not a lot of detail to work with. 

Maybe the book "learning xml" will help.  You can find a link here: http://www.amazon.com/exec/obidos/tg/detail/-/0596000464/102-8229627-2212925?v=glance

A few more details about what you...

Michael,

Perhaps you could post your current conversion code?  We may be able to spot the error.

Wayne

G'day all,

Thank you for the responses so far.  They are helpful. 

I am currently scoping out a potential new product.  Without going into too much detail, the development effort of the...

Hi there,

What type of DB is the proprietary structure using?  DB2?  xBase? Oracle? 

The difficulty of porting the table strucutres depends on the current DB.  Also depending on the source,...

Hi Dave,

A quick google search for "ZombieCheck" turned up exactly four hits.  Based on the messages in your post, I suspect you may be dealing with the first one.  It appears...

Hello again,

Can you please post the actual DDL for the tables?  I'll generate some dummy data and post the working query(s).

Thanks

Wayne

I apologize in advance if this set of questions takes the topic too far off track.  We can easily take the conversations to a different thread if appropriate.

Excellent article.  It is...