I'm guessing you 're trying to insert data in the wrong format.

Most probably it's caused by the format you're trying to insert conflicting with the current setting of DATEFORMAT.

Example:

SET DATEFORMAT...

I'd recommend using a calendar table as a left outer join part. If you don't use one already you might want to have a look at the Tally table article...

Most probably the following link will help you to resolve that problem:

http://rusanu.com/2006/03/07/call-a-procedure-in-another-database-from-an-activated-procedure/

I was talking about a datetime column. The data would be stored in the database standard edit: internal format and, if formatting of result sets is required, this would either...

There is no column [DonorID] in your sample table. Where

City, state and zip as well as some other columns defined as VARCHAR(8000) seems to be "slightly oversized".

Finally: Your sample data...

The following code would allow you to convert ISO8601 with time zone (aka as style 127) into a valid datetime format.

SELECT CAST('2008-09-18T15:52:00.000-04:00' AS XML).value('xs:dateTime(.[1])', 'datetime')

I strongly recommend to enforce using...

@ryan-2:

Maybe you could convince your "DBA" to start a thread here at SSC with a title like "What are the benefits/costs of disabled statistics on tempdb?"

Side note: Usage of "DBA"...

CirquedeSQLeil (3/17/2010)

That should stir up plenty of controversy. Maybe...

mth13 (3/17/2010)

The table which holds the donors just needs to be ordered by receipt; that way, like receipts are together. This Table2 still holds all six donors, and I need...

Please clarify the interpretation of the "hierarchy".

Example: 'grandson1,son1,grandfather1' can mean anything:

Some scenarios:

a)

Parent: grandfather1

Child1: son1

Child2: grandson1

b)

Parent: grandfather1

Child: son1

Parent: son1

Child: grandson1

c)

Parent: son1

LeftChild: grandson1

...

@steve-2: You're right. Row_number and the like is not an option here. Unfortunately.

@mike-2: If the data you have actually look like the sample you descirbed it's fairly easy (DELETE ID>4).

Therefore,...

assuming SS2K5 I'd use a table holding all reserved words I'd like to chek (e.g. from this web site: https://publib.boulder.ibm.com/infocenter/wasinfo/v6r1/index.jsp?topic=/com.ibm.etools.ejbbatchdeploy.doc/topics/rsqlMSSQLSERVER_2005.html

)

and join that to sys.syscolumns.name and sys.sysobjects.

Would it be possible for you to post the procedure?

Mabe we can help to speed it up a little bit.

As to my knowledge SSE2005 is not set up to use sp_send_dbmail by default. There are some important files missing.

However, there seems to be a solution where it's possible to...

:blush: May I quote you when talking to my boss next...