briancampbellmcad (10/16/2012)

---

Any ideas?... I have a trigger (not working obviously) set up that decrements from my [tblBulkPurchases].[Quantity_Remaining] field an amount by one with each entry into my [tblTransactions] when my...

Take a look at this article. It is a good overview...

Post removed...this is a duplicate post.

Post removed...this is a duplicate post.

nitin_456 (10/16/2012)

---

I need help regarding the issue having on performance and size.

We have a Database : (History_price) which contain all the historical prices of the securities. There is one table...

Luis Cazares (10/15/2012)

---

But it gives different results, Sean. Because your query will affect how the join is made and will generate duplicates. That's why you need to use separate conditions...

Luis Cazares (10/15/2012)

---

Sean, for what I understood, he might need to use the original query and filter the rows with a where clause.

DECLARE @FromDate datetime = '20121013', @ToDate datetime =...

komal145 (10/15/2012)

---

Hi friends,

I Need to get particular date(eg: todays date) date from PROD to Dev tables.where the...

Just use your parameters in the condition...

xXShanXx (10/15/2012)

---

HI Sean Lange

Sorry - I didnt check the post before. Thanks for your advise. I will follow it hereafter and these are not real table names and are with...

That's great. Can you answer the rest of...

That is certainly good news. Nothing like having the process happen at the right spot in the business. That self compliance check list has been a real eye opener for...

+1

That is why I have no...

And when you get it back up and running create a maintenance plan to backup your databases so you can avoid this type of thing in the future.

Unfortunately just re-posting the same "table" is not much help. We need to able to run queries against this stuff to help. It seems you did not read the article...