Using a cursor:

DECLARE myCursor cursor LOCAL FORWARD_ONLY FAST_FORWARD READ_ONLY

FOR SELECT OfficeId

FROM dbo.Office

DECLARE @OfficeId int,...

Or using CROSS APPLY:

SELECT OfficeID,

S.StateAbbr,

C.countrynames

FROM dbo.Office O

CROSS APPLY (SELECT TOP(1)

...

A csv list can also be generated using "FOR XML"

I rewrote the final query using this method:

SELECT OfficeID, 
       (SELECT TOP(1)
...

Hi James,

I'm not sure exactly what you are trying to do. Is it that you have a stored procedure that calls an inline table function and it's the inline table...

Yes, thinking about it, the runtime for the all of the methods...

sagesmith (6/18/2013)

---

Please forgive my lack of etiquette.

I am humbly submitting this code for review by the gurus here on this forum. I think it might show that the CURSOR...

I see 😛

It can also be done even more simply with an INNER JOIN and tally table (and is faster than the...

I thought this looked a good candidate for CROSS APPLY:

insert into dbo.def 
(
    SeqNo,
    Date_Field,
    Payment
)
SELECT A.Seqno,
 ...

tom-580235 (6/17/2013)

---

Problem with the script in that if any of your variables are null you don't get the create string produced. i.e., in my experimentation @FileGroupName was null on one...

Nice article and some good links to useful videos

http://technet.microsoft.com/en-us/sqlserver/ff977043

It doesn't work in your algorithm. I've pulled it apart to see what it does if there...

It does seem a bit too close for comfort to this article:

http://www.dbta.com/Articles/Editorial/Think-About-It/How-Secondary-Files-Put-Your-Database-at-Risk-86580.aspx

But then again at the...

The code in the article doesn't check that the EventCloseDate older than 6 days when it does the delete. Is it that the EventCloseDate is always present and monotonically increasing...

I think the creation of a separate view is unnecessary when you can have the view inline:

DECLARE @Rowcount int

SET @Rowcount = -1 -- Initialise

WHILE @Rowcount <> 0

BEGIN

...

This made me laugh