If the master database goes down, and takes the other accounts with it, you may not be able to restore it. On the other hand, that's where the sa...

It looks like it would be:

select sum(rec_cnt)-count(*) as total_reject_cnt

Without the Group By, that should get you what you need, I think.

They're the same. sa is just a default sysadmin login. Nothing more nor less.

Roy Ernest (12/29/2010)

---

Today is my last working day for this year. There fore I want to wish everyone a very happy and prosperous new year, 2011.

On another note, I have...

I've done both. A day working from home can be incredibly productive, but a day at the office can too. One offers more uninterrupted time, the other offers...

I love the title. I...

WayneS (12/28/2010)

---

Okay, let's talk about blogging. I've seen a few posts from time to time, but I don't recall seeing anything dealing with:

(From a higher level) How to set up...

Yes, there are a number of ways to go about the mechanics of storing common data in one place. They all have advantages/drawbacks.

I'd say that, under most circumstances, maintaining...

Makes sense.

Let us know if you have any questions.

Abhijeet Chavan (12/29/2010)

---

GSquared (12/27/2010)

---

I must be missing something if this won't work:

DECLARE @imported BIT;

SELECT @imported = null;

SELECT *

FROM #M_Vendor

WHERE DailysettlementYN = @imported

OR @imported IS NULL;

Change the value of the variable,...

Of course, you can't use dynamic SQL in a view, but that'll work for a proc.

Not only that, but I actually predicted I'd...

You can do this via means like sp_MSForEachDB.

What I recommend, however, is if the data is the same in each database, move it to one database and have the rest...

That kind of data formatting is usually done in the report or application it's being presented in. Most allow for that kind of thing pretty easily. Don't do...

malleswarareddy_m (12/27/2010)

---

Hi its an interview question in IBM.But the guy told that with 3 dml staetments we can do this.

But when we diable using alter its as DDL .Please try...