Excellent article and I look forward to the rest on this topic.

About email notification: I am a member on another site and if you select email notification all you get...

What 'last comma'???? This is the way it looked when I answered it.......

CREATE TABLE Employees (

EmployeeID nvarchar(10),

EmployeeName nvarchar(255),

EmployeeSocial nvarchar(255),

EmployeeStartDt datetime,

EmployeeReviewsMemo nvarchar(2040),

EmployeeNotes nvarchar(2040)

)

-SQLBill

No fun! We can't post replies (I get the same error as Frank).

And I so wanted to respond to Andy's "Steve Jones my garage door is broken" thread.

So here's my...

OOPPSS, there ARE other forums in which I can't see any of the threads. Could it be that there aren't any threads since it's beta for now?

-SQLBill

1. CON - I have to scroll to the side on every page

2. PRO - I really like the look

3. CON??? - I noticed I'm the last poster on...

What permissions do you have on that database? Are you just a user? If so you aren't going to be able to delete it.

-SQLBill

Frank,

Yes a good question that makes people think could be worth a star - if that's the way it's set up. But that doesn't help identify the people who are...

You can only use Profiler to show what you have already recorded. You can't get it to show something that has already happened. Set it up now to start recording...

quote:

---

In http://www.tek-tips.com the orginator can mark accepted/usefull solutions (multiple) and based on that the points are awarded. They have Annual and Monthly...

If you still have the tape drive for the DDS-4 tape: restore it to a server and then copy it to LTO.

Other than that, you'll probably have to find a...

I'm not sure you could do it that way, but do you have any reason why it can't be two different stored procedures? For example:

EXEC spMyProcedureIN ('502,503,504')

EXEC spMyProcedureNOTIN ('502,503,504')

-SQLBill

Why have a count at all?

Let the responses stand by themselves. If someone posts wrong information it is usually corrected by someone else. I know that because I've posted wrong...

quote:

---

I agree, I did not answer the question because it did not include changing the dateformat for the imports from overseas using...

This should work:

CONVERT(datetime, datefield, 120)

Refer to the BOL, use the INDEX tab and enter CONVERT.

-SQLBill

Have you tried the format:

'yyyy-mm-dd hh:mm:ss'

i.e. '2003-12-18 18:30:00'

-SQLBill