Evil Kraig F (6/20/2014)

---

pwalter83 (6/20/2014)

---

I am trying to calculate running total in...

Jeff Moden (6/23/2014)

---

Thanks, Magoo... That's pretty close to what I would have ended up doing had someone not posted the solution but, my word, I don't believe there are a...

Join to a "numbers" or "tally" table to generate the extra rows.

Have a read of this article, and then, if you don't understand how to apply it to your situation,...

Here are two similar ways, but probably the second would be preferable as the first is deprecated.

1. Jscript.Eval

Add two references to your report:

Microsoft.JScript

Microsoft.Vsa (<-- deprecated, so...

Same problem here.

Jeff Moden (6/22/2014)

---

How in the world a newbie would make the connection in his/her mind that you need to find and embed a MIME attribute in HTML to send an...

Can I ask what is not working in the SSRS RunningTotal, it may just be a scope problem?

mickyT (6/16/2014)

---

One to make you smile if you have 2012:-)

DECLARE @smiley varchar(20) = 'Dont Worry Be Happy';

WITH Params AS (

SELECT MAX(CASE WHEN ItemNumber = 1 THEN Val END) OFFSET,

MAX(CASE WHEN...

clayman (6/17/2014)

---

Thank you!

I have two follow up questions.

Is there a way to change the query so that it only counts the word(s) once per row?

Also, I would like...

select Word,sum((len(t.string)-len(replace(t.string,Word,'')))/len(Word)) as count

from @word as w

cross join @t as t

group by Word

If you provide some sample data in the form of DDL and DML statements that we can run, you will definitely get a working answer.

See the link in my signature...

also, can you please tell us whether you are looking for exact matches or whether partial matches count?

e.g. if you are looking for "SQL", does "MySQL" count as a hit?

Eirikur Eiriksson (6/16/2014)

---

mister.magoo (6/15/2014)

---

It's not very fancy, but I have found a query where NOLOCK really is desirable...

SELECT result FROM fifaworldcup2014 [highlight="#ffff11"]WITH(NOLOCK)[/highlight] WHERE team='ENGLAND'

Here's hoping for that "incorrect data" we...

I got tripped up by the encryption bit, as I did not take the phrase "You also determine that encryption is not used in this database" to mean that the...

It's not very fancy, but I have found a query where NOLOCK really is desirable...

SELECT result FROM fifaworldcup2014 [highlight="#ffff11"]WITH(NOLOCK)[/highlight] WHERE team='ENGLAND'

Here's hoping for that "incorrect data" we are constantly warned...