GSquared (5/6/2009)

---

Maybe I have the volume on my speakers turned down to far, but I haven't noticed anyone's avatars making any noises at all... (cuz I'm a blonde, yeah yeah...

Bob Hovious (5/6/2009)

---

Why shouldn't he put quotes around 'NULL', Alvin?

'NULL' is a perfectly good word. Isn't it? :unsure:

BTW, I was also...

Do not use quatation marks around Null

I haven't analyze any data to validate my answer, but I feel that the answer to the original question: "Are the posted questions getting worse?" is:

YES!

KATHLEEN Y ZHANG (5/6/2009)

---

Hi, we have some asp code right now that transfers contents of three tables from one server to another. Here is how it works right now:

if condition1...

Would using...

If I understand what you're asking for then I think what you need is to add the code below to your where clause:

DATEDIFF(month, YourDateColumn, getdate()) <= 12

Just out of curiosity ....

How many columns are in the table now?

How often do you add new columns?

How many columns do you add each time?

Grant Fritchey (5/6/2009)

---

Alvin Ramard (5/6/2009)

---

I agree with Grant and I would recommend Microsoft Visual Studio. I would pick VB over C#. You probably would find that a bit...

PaulB (5/6/2009)

---

Alvin Ramard (5/6/2009)Keep in mind that a DR plan for development can be completely different from a production DR plan. A development DR plan could be as simple...

vidhyasudha (5/6/2009)

---

I clearly understood that I first plan what needs to recovered in case of disaster then try to figure out DR method that suits my business process and implement...

I agree with Grant and I would recommend Microsoft Visual Studio. I would pick VB over C#. You probably would find that a bit easier to learn, but...

No, it does not mean you have to create replication. It means you need to have...

If...

I realize that, but you know what we say around the...