OK.

I'm an intruder...

What is the rule for leaving this particular record, not any of the others with "A Y"?

tafountain (3/21/2013)

---

The predicate applied by the WHERE clause is not pushed down to the view at runtime. This is evidenced by reviewing the execution plan and seeing that...

Record consumption events against nodes the entites belong to at the moment, not entities themselve.

Then shifting an entity to another node won't change statistics of consumption for nodes.

event.eventdate (as any other column used for a range selection, i.e. >=, <, BETWEEN, etc.) must be made a 1st column of a clustered index on the table. Or -...

Or alternative method:

1. Create a procedure which returns a list of the jobs which "are running longer than defined SLA"

2. Add a bcp command to your .BAT file which runs...

From your post right from above:

I am looking to find '01J416781', each row of data starts with this pattern....

WHERE value_expression LIKE @Pattern + '%'

Is it what you need?

Oh, I see.

"To write" is "to read.

Aha.

And "black" is "white'.

And "lie" is "truth".

Of course.

I'm recalling I read something like that before...

Or - did I write it?

Oh, I cannot...

Which server you want your bcp to connect to?

try to run

SELECT

BatchID,

FieldA,

FieldB,

CAST(ISNULL(ROW_NUMBER() OVER (PARTITION BY BatchID ORDER BY DateEntered), 0) AS INT)...

Just to annoy you Lynn 😀

select ...

from mytable mt

inner join (

select dateadd(hh, 1, dateadd(dd, datediff(dd, 0, getdate()), 0)) StartDate

) DT ON mt.someeventdatetime >= DT.StartDate and mt.someeventdatetime < dateadd(dd, 1,...

I believe the whole thread by now is off-topic for the original question.

but just in case anyone...

Eugene Elutin (3/18/2013)

---

I did. Checked. He did not state that CTE are easier to write. For a mater of fact, he said that writing queries using CTE is easier than...

dtibz01 (3/18/2013)The part that I find to be a little frustrating, is that the data types for the parameters defined for WITH RESULT SETS are defined elsewhere in the SP...