Stefan_G (4/21/2010)

---

Paul White NZ (4/21/2010)

---

Both run without error for me on both 2005 and 2008.

Versions tested:

SQL...

kabaari (4/21/2010)

---

Coldcoffee,

Thanks. Not sure if posting data would apply in this situation. But, I posted data in the past and ended up with people responding with how valuable their time...

I see you found it...

Here is a question for you, have any of your clients (customers) connected from any of those IP addresses that have attacked you??

Just an FYI, starting with Windows Server 2008 XCOPY has been flagged from depreciation. Recommended replacement is ROBOCOPY.

Not someone I may consider hiring as a consultant or direct-hire.

obstinate

stubborn

It would help if you would post the DDL (CREATE TABLE statement) for the table, sample data (series of INSERT INTO table statements) for the table, and expected results. ...

I have to agree with Paul. Yes, if I run his function the way you are calling it, I get an error. However, look at the following code...

Configuring a VPN client is only done once. Once configured, you simply start it and use it. One of our sysadmins even has his start automatically when he...

Another option:

CREATE TABLE #orders(

order_id int,

product_id int,

...

agitate

Steve Jones - Editor (4/20/2010)

---

One other issue to consider is how do we decide what's on the test for new features? Who "becomes" the expert? The "who" can be a...

malavika.ramanathan (4/20/2010)

---

Thanks for your suggestion. But when i run it , i am still getting error.

In my SP, i have given print statements at every level to check.

Now...