Here is an example of several methods you can use for each case within an ActiveX transformation.

Option Explicit

Dim strName, arValues, strSuffix, strLastName

'------------------------------------------------------------'

'/                       City, State                        /'

strName = "Pittsburgh,PA"

Comma_Pair strName, arValues

MsgBox arValues(0)...

I bet it helps with burnout also.

Or just simply

RIGHT('00000' + RTRIM([fieldname]), 5)

As you don't really care if it is already 5 it will be five either way when done.

IT would be helpfull if you could provide a few examples of the data. Such as

Turner,Bob S MD

Or

Bob S Turner MD

Just so we know what format you are dealing...

Without having somewhere to test and the fact I don't have a server setup with log shipping I do believe they are nothing more than transaction log backups which means...

The query engine performs better when using = values as opposed to != or <> so rewtire the previosu like so.

select RecordType, Quantity_Ord = case when RecordType = 20 then Quantity_Ord...

I have no idea of the stats for all the work I have done because a lot of objects have been created and redesigned, sometimes there were new objects, sometimes...

I will say that I keep a credit card with a low limit for purchases where the card will leave my sight such as resturants. But low and behold a...

I would look at one of these options. It is basically the same thing but more native to SQL itself and means you might can even avoid the temp table.

Ok so does MyTable exist in the database the user is connected to or is it another? If the same and is owned by DBO then all the SP of...

There is a devleoping standard for it in the ISO-11179 standards.

Just another option.

First Off I am assuming ProjectID is Unique in Project and ProjectId is Unique per EmployeeId in EmployeeProject (meaning an employee can only be associated once).

However if the...

From what I can tell it only works for a few items such as items under Objects events, Stored Procedures events and Transactions events. I have never seen work for...

I am curious as to further detail. The way it looks I would say why not just make a direct call to the table. This looks lik an over complication...

There is a lot in BOL but basically don't think of it as the objects and data changing it is the pages that are backed up. When a page has...