If he has an index on that column and he can drop the first % he can get a seek instead of a scan.

ie..

SELECT ... FROM MyView WHERE MyColumn LIKE...

kmundt (3/28/2013)

---

Here is my scenario, The user puts in a customerID, possible start and end date and selects a status from a radiobutton list. The radiobutton list is 'closed, open...

I don't have time to work on it right now but I'm guessing you're going to need a (to pseudocode)

row_number() over (partition by rolling_total < 200 order by age) rownum

kind...

I hate to say it but why not something simple like:

DECLARE @c varchar(100)

SET @c = '<div>Sunshine</div>'

SELECT REPLACE(replace(@c,'</div>',''),'<div>','')

Something like this?

declare @filename varchar(255)

set @filename = 'APR0111OFR_AAAAAAAA_01'

select replace(@filename, substring(@filename,2,2),lower(substring(@filename,2,2)))

What's the criteria by which the rows are being deleted? I'm note sure I see the point of putting an identity column on the table if he's grabbing them by...

Then the sql I posted would be sufficient for such a task, I believe.

I agree with Lynn.. this doesn't seem like a running total issue.

This would just as easily get what you want but I'm curious why you don't care about the year...

JoseACJr (3/27/2013)

---

Hi,

I would like do execute multiple statements in all databases.

I created the following code:

DECLARE

@C1_NAME VARCHAR(1000),

@sql VARCHAR(1000) ...

Good idea in my mind, Jason. I generally have a utility database from which those types of things run.

Nicely done, Sean.

This should get you started.

DECLARE @strSQL VARCHAR(max)

DECLARE @dbaseName VARCHAR(255)

DECLARE proplist CURSOR local static forward_only read_only FOR

SELECT name

FROM sys.databases

...

The first thing you'll need to look at is which NoSQL engine you're going to use. Got any information on that?

Is there a particular reason you want to avoid the pivot function, even dynamically?

Thanks for the advice. 🙂

I'll implement the changes and see if I can get a marginal boost in speed as well as at least providing data integrity.