Multiple post, please post replies here.

Multiple post, please post replies here.

You will need to look at setting up a server side trace that is started using a startup stored procedure.

I'd start by researching SQL Trace and SQL Profiler in Books...

Is it looking up a value in the same row??

I also don't think the post count is working (incrementing) nor have I received any email notifications since the site went down.

Edit: Or I could be wrong on the post...

middletree (7/8/2009)

---

I agree joins are better. I was just trying to solve a problem. Sadly, I got the same error when I moved the JOIN criteria to the WHERE clause....

Lowell (7/8/2009)

---

there is an optional OUTPUT clause you can use to retrieve all the values that were inserted; typically you insert the output into a temp table and use it...

Multiple post, please post replies here.

Multiple post, please post replies here.

Multiple post, please post replies here.

Anjana (7/8/2009)

---

Hi,

i need to help to decode the timestamp values which are there on my tables.

For example i have a timestamp value like '0x00000000085EBC62'.

I would like to see...

Is it just me or are others having issues when posting replies? I get application failures, but the replies still post. Quite troubling if you ask me. ...

It would help to have the DDL (create table statements), sample data (in a readily consummable format that can be cut/paste/run in SSMS) in order to help you better.

Please read...

It would help to see what you have done so far as we may be able to help you fix your code instead of starting from scratch.

Plus that may help...

Okay. I did some testing while SSC was down. The first part of the code shows how to calcualte the various date ranges. The last part show...