Spring Fever - I had a teasing of that last week when it got up to about 60.

28 out right now. I can only dream.....hard pressed to see 40 for...

It's possible that after Roy mentioned free drinks yesterday, there was a flurry of activity, and then the hangover took over.

Or maybe they're tossing sandbags up in Fargo ND.

Greg E

Catcha (3/25/2009)

---

[Code]

select top 100 u58.deal_type_cde , ucb.*

from u58_deal_hist u58

join ucb_exp_hist ucb on u58.deal_id = ucb.deal_id

where ucb.batch_id = 297326

and u58.batch_id = 297325

and ucb.deal_id like 'IMGATD%'

[/code]

There are...

Maybe you can hit the 3000th post too.:w00t:

The quoted reply - seems like it would pick the one above for me sometimes.

Greg E

Posting the table structure would help.

You also ask NOT LIKE at the start, but LIKE in the example query.

Is there any order by in the query?

Greg E

Wow....I think this one needs a bit of alone time.

I could think of a better fitting avatar they...

I think Doug is right about checking out the account. Does this account have access to the...

ghollis (3/18/2009)

---

I agree with the previous comment that even with a group by, top 25, and order by, you are not going to get what the question asked for as...

Overthinking can kill you - too complex, and you could miss a key ingredient. And thinking tends to get me in trouble, so I avoid it as much as possible....

I...

Reporting Services and Excel are the first 2 that come to mind.

There are also tools like ProClarity/PerformancePoint depending on the budget.

WSS3.0 can display data, but you have to do all...

'Why' is a word that often times puts a user on the defensive.

'What' are you tryinig to accomplish? at times can help get requirements out.

Role of Business - state the...

That would seem likely.

http:\\servername\reports and see if anything shows up might be interesting.

Make sure you look at the IIS logs too under the Windows\System32\Log Files folder too.

Greg E

Actually monitoring is not labor intensive. Once the rule is setup, you're well on your way.

We are alerted on selected errors that show up in the event log, but also...

SSRS has log files that may give you a clue. Default is under C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\Log Files.

Between this and IIS log files you should be able to determine...