Look at...

You're running the "unpatched" or RTM version (the original version of SQL server without any patches).

I get all my patches through Microsoft Update. It automatically picks up what I...

deekadelic (5/15/2008)

---

I wrote a stored procedure that manipulates data for any record where the value of a specific date field is older than 21 days; but I want to change...

Depending on the output mechanism - you may find it easiest to handle this kind of output in the output mechanism. For example - SSRS and Crystal both have...

etxeb (5/15/2008)

---

Matt Miller (5/14/2008)

---

Combining that into a Windows service is likely to be your best bet. Once you wire up the FSW event to fire as you like, triggering...

Please don't cross-post. This has already been answered over here:

http://www.sqlservercentral.com/Forums/FindPost499535.aspx

hmm - that's strange - because I get 6 rows, not 5.

ActionTimeactionName

2008-01-02 12:40:51.000BUY

2008-01-02 12:41:41.000SELL

2008-01-02 12:42:01.000BUY

2008-01-02 12:42:41.000SELL

2008-01-02 12:42:51.000BUY

2008-01-03 12:41:31.000SELL

It might make a difference that your SECOND definition of actions returns different...

I hate to say this - but doing a straight select like the initial loop you have, and....I get 10,000 selects, all with the SAME date value.... The only...

I'm hoping you screwed up your sample again, because if you didn't - you're SOL. (you'd be wanting us to rely on "physical order" to break these things, which...

Are you running the statement from the database where test1.emp is? Sounds to me that you're in the wrong DB at the time....

premnathk.chn (5/13/2008)

---

Hi All,

I am at the final stage of my project(developed in java and db as sqlserver 2000) and now we are doing the data migration and we have this...

Karthik -

With all due respect - this might be a great opportunity to wade on in, roll the sleeves up, and see how many of these you can take...

Sure you can. It's actually a rather common operation in my shop.

UPDATE TableA

SET TableA.columnA=TableB.ColumnB

FROM TableA

INNER JOIN TableB...

No rush - just kind of noticed it. Thanks Steve!

I for one am eagerly anticipating Part II, where we get to hear about multi-phase projects, and no doubt the highly useful Phase II/refactoring tool as shown here:

Major Refactoring tool