Lynn Pettis (5/2/2012)

---

Which one...

Hi Lynn / Cadavre,

Sorry I am late today - meetings in the AM and more coming too - but while I have time I looked over the code you sent,...

When our clients use our tools they can specify about 10 or so parameters - that is what you are asking about...

So, its the modified date of the file (eg,...

Lynn Pettis (5/1/2012)

---

First, there is a much better split function that we can use. Will get to that later if someone doesn't beat me to it.

Second, I am assuming...

Lynn Pettis (5/1/2012)

---

Also, what counts are you trying to get. You provided the query you built the cursor on but you didn't show us what you were going to...

Here is fn_ISAppType

ALTER FUNCTION [dbo].[fn_IsAppType](@LookingForAppBrand varchar(100),

@AppBrandValue varChar(100))

RETURNS int

As

BEGIN

Declare @IsApp int

IF @AppBrandValue = @LookingForAppBrand set @IsApp = 1

ELSE

set @IsApp = 0

RETURN...

Lynn,

In your second post you say "Thinking this is what you are trying get so far?" - uh, no... I dont get that many rows as shown in your...

Lynn,

Thanks - sweet bit of code! Uh, yes... There is more work to do here and I promise I will try to do it with set based thinking...

Hello again Cadavre / Lynn,

I have a question regarding the CTE Cadavre shared with me. I have done a bit of studying to get the brain wrapped around this...

Cadavre,

Today I will study and dive into the CTE element much deeper - and yes, you are absolutely correct - we developers who have spent years (decades in my case)...

Cadavre...

I apologize - yes, the CTE you forwarded is great, sleek, and well, its just getting my head around it that took time. I appreciate the code.

And yes again...

Point taken... Good point too. Let me first try to finish what I am doing now as suggested elsewhere (which seems to be working better) and then we...

Ah, Gotcha...

I got a couple great suggestions and some guideance off another SQL site and I am pursuing that right now. If I get stuck I will try to...

Thanks Lynn...

However, there are no CREATE TABLE statements - this comes out of one of our core Databases, created 10 years ago (or more?) through the interface, not statements. ...

Wow...

Thanks for the replies, and the advice. I made the cursor READ_ONLY, presuming that would help improve things - but if you guys are saying "Dont use cursors", that...