is the data integer data type or strings?

so the value 24701 is 2:47:01 (am?)

152205 would be a valid value and 15:22:05 or 3:22:05 pm?

something like this may be...

a lot depends on your data; that cross join can have a cost.

if your data is anything like my copies of the US Census to 90% firstnames/lastnames, a cross...

try it yourself.

ALL transactions can...

hint # 1 the number of rows don't matter...testing it yourself goes a lot farther education-wise than asking and getting an answer....

hint # 2 when can you use or not...

you did everything right, thank you! excellent explanation, sample code of what you tried, gave me everything i needed to build a testable, working example.

good...

sounds like row number will give you exactly what you need:

SELECT

ACCT,

ROOM,

CUST,

REGION,

LASTUPDATEDATECORP

FROM

(SELECT

ROW_NUMBER() OVER(PARTITION BY...

you could get it from the execution plan, if it was in the cache.

it's not easy, as xQuery's a little difficult, but it's in there.

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.