Give us a clue what you are trying to achieve, because multiplying a time doesn't make sense.

Is the VB.NET app running the query itself, or is something else running it and passing the results to the application?

If it is the second option, how is it passing...

Jeff Moden (3/26/2013)

---

mister.magoo (3/26/2013)

---

How do we all feel about SQL Agent Jobs and the ability to run operating system commands from them?

(I know the user running the job will have...

How do we all feel about SQL Agent Jobs and the ability to run operating system commands from them?

(I know the user running the job will have been configured to...

dcdanoland (3/19/2013)

---

I'm sorry I misunderstood the difference between a subscription and a subscription "event." I wish understood better what an "event" is with regard to SSRS subscriptions. I'm having trouble...

Thanks, I am sure I will find this useful.

Nicely written as well 🙂

Eugene Elutin (3/18/2013)

---

Just replace

SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL

SELECT 1 UNION ALL SELECT 1 UNION ALL...

Just to stick up for the old CTE...

"On-the-fly" tally tables...

CTE method:

WITH E1(N) AS (

SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL...

declare @TestStr varchar(128) = 'DMV1004/343M.TR3432_PLC089_RIC_9843CL';

select @TestStr

from dbo.DelimitedSplit8K(@TestStr,'_')

where ItemNumber = 3

and Item = 'RIC'

You can get DelimitedSplit8K from here : http://www.sqlservercentral.com/articles/72993/

Drop #TheChosenOnes on it's own first and then run the whole thing.

Siobhan Perricone (3/12/2013)

---

As far as I know, they're supposed to be. I mean, we told the server folks who set things up that they needed to be exactly the...

AndrewSQLDBA (3/12/2013)

---

Hello Everyone

I am working on some old data that should not be store this way, but it is.

My data is two values with pipe separators.

10.0||14.5

or

2||34

or

7.1||19

or

4||11.7

I need to query this...

Either do it in the query that populates the dataset

OR

Put a filter on the dataset

OR

put a filter on the matrix

Siobhan Perricone (3/12/2013)

---

Curiouser and curiouser, it runs on my production system, but no on my dev system. But I just imported the data from prod to dev a short bit...

You can't use a list of values in a variable directly in the "IN" clause, which is why you have the dynamic SQL...