Wow if the same rate continues we should hit 1.5M by the end of the day today or certainly tomorrow.

Are you looking to get a result set with each half hour block for a given day and the count of rows in your table for each block?

It is totally unclear what your question is here. You need to more clearly explain what you are trying to do. If you want help with the actual code you...

SQL Kiwi (5/3/2012)

---

One possible test is to imagine one's mother reading the post before hitting 'reply' and wondering if it would make her proud.

I'm not sure The Thread actually has...

Lynn Pettis (5/3/2012)

---

Sean Lange (5/3/2012)

---

Just an observation and a friendly reminder.

/soapbox on

We are starting to lean too far to the arrogant side with many of our replies (and yes I...

That sounds painful. Why do you need millions of rows in a DataTable? For that much data manipulation it seems like you should keep it all in SQL instead of...

Looks like Lowell beat me to it.

Where are you viewing this that it is all on one line? If it is in SSMS and you are viewing results as grid it will not span multiple lines....

Amen to that!!! This is snark central how...

Just an observation and a friendly reminder.

/soapbox on

We are starting to lean too far to the arrogant side with many of our replies (and yes I am guilty myself sometimes)....

Even before the where clause when writing a delete or update query I write

begin transaction

rollback transaction

That way I can run the code without fear of anything going horribly wrong until...

Couldn't you use the following query to create your temp table instead of the complicated IF construct and two different temp tables?

Select l.Source_Description, a.ShKey, Sum(m.MeasureValue) as MeasureValue, s.Period_day as DateCode

into...

jerome.morris (5/2/2012)

---

Hi guys forgive me if this is simple but I seem to need more complex query the more my c# app progresses and being a new to both 1...

tt-615680 (5/3/2012)

---

Dear All,

I would like to find more about the Disadvantages of Transactional Replication as it is the best process of Replication for my Business needs; I would like to...

You have a couple things going on here. First your query is using the old style join. While syntactically correct it is very hard to read these types of joins....