How do you have the numeric value defined?

Jack Corbett (11/24/2008)

---

Rod at work (11/24/2008)

---

Lynn, this is a very simple follow-up question, but I've got to ask it. In the one other SQL Job I've written I've got...

This is a unicode (nvarchar) string: N'tempdb..#test'

This, 'U', mean user defined table.

You can...

You may also want to look at the possibility of using indexed views.

What it means is that you will have purchase SQL Server 2008 for the server that you are installing SSAS, SSIS, SSRS on seperately from your database server. You...

Congratulations. Maybe some day I'll go for the certs. I've been working with SQL Server for 12 years, but never really had the time to do it.

As you are pulling the data from a table, I'm at a loss as to why you are using a cursor for this process. Below is the code I...

Please note, I corrected the code in my post above. I didn't quite cut and paste correctly while rewriting it.

Sorry.

Considering there isn't a MCDBA certification for SQL Server 2005. It has been broken out into 3 different certifications. As Jeff said, check the Microsoft Web site. ...

If the database is still in compatibility mode 80, yes, but if the database has...

Here is my untested rewrite of your query. As rewritten, this query will also work on SQL Server 2000. I could have written the derived table as a...

Here's the question you haven't answered. You have a loan with a monthly payment, the first payment is due on January 30th, when is the March payment due, since...

Yep, the record's stuck, the record's stuck, the record's stuck, the record's stuck...

teddunaveen (11/22/2008)

---

hi Experts how are you i have some douts

1)How to do the Defragmentation?

2)how to check the free space in server?

3)my application developer deleted 10 records how can i...

I feel like I'm chasing a moving target myself. Everytime I think I'm close to understanding the problem, it changes (or the water gets muddier, pick your own metaphor...).