you could also use three part naming, and not use the USE command at all:

select * from test.dbo.sysobjects where xtype='u'

--or

select * from test.sys.tables

Connection.Execute(sqlStatement) optionally returns a dataset. use that to get uthe update and the results in one pass.

i would use a two statement combo like this:

dim Conn ' As Object

set Conn...

Ninja's_RGR'us (9/20/2011)

---

Sean Lange (9/20/2011)

---

And don't add an accidental space into Lowells naming convention. (WHORE SULTS). :w00t:

Which when I first read it i transposed the U and L in the second...

you have to create a table that mirros teh output of the proc you want to capture...

here's a basic example, just grabbing sp_who2 results:

CREATE PROCEDURE PR_CAPTURESP_WHO

AS

BEGIN

SET NOCOUNT ON

...

17 minutes or 1.5 hours sounds a lot more like a performance issue rather than than an ITVF issue;

consider updating statistics (UPDATE STATISTICS ON TBLNAME WITH FULLSCAN) for each...

ok here's an enhanced version of a parsename function, which takes any number of items, and an optional delimiter to boot:

i think this is from a Jeff Moden post ....

--usage:

with...

i believe this will do what you want...obviously test this first!

--random first land last names,

;With MyRandomNamePairs AS

( SELECT

ROW_NUMBER() OVER(ORDER BY Surname.ID) AS N,

...

[1.1.A]

it has two periods and the letter "A" in it...it would have to be a varchar.

One of our developers started down that same road, because we had so many users familiar with Excel, but we ended up switching to a web page instead;

we had...

stop the SQL service on the Active node....

that "burst" keyword your using is throwing me off...i'm not sure what you mean.

you can use a "Tally" or "Numbers" table (search here on SSC) to cross join as many...

you can use sp_fkeys [ParentTable] to generate a list of child table references;

from there you can use that list to script your merge statements...does that help?

from the link that was posted, i also noticed you cannot use SQLMail with 64 bit SQL.

it's kind of hard to not use 64 bit with anything that's reasonably new...

this link shows how to make a linked server to a PROGRESS database:

http://progress.atgnow.com/esprogress/jsp/AnswerControls.jsp?directSolutionLink=1&tabs=true&docPropValue=p120484

from there, it's a matter of the linked server calls via 4 part naming conventions:

select * from lsProgress..Database1.Table1

select...

vinaseetha87 (9/20/2011)

---

I have create a website.the customer send the query in my mail that query how to store in database.

I want to read the inbox message ,that message how...