In my opinion I think it is quite the contrary - for those that know T-SQL, it is a test of their...

Refer to find a list of various SSIS functions

http://technet.microsoft.com/en-us/library/ms141671.aspx

in particular - FINDSTRING

http://technet.microsoft.com/en-us/library/ms141748.aspx

Jason

Thanks for a job well done. Now to add this new tool to my tool box.

OK...

Steve

Thanks for fixing the graphic. Sorry I did not notice the cropping when I

submitted the question .... Next time I will be extra careful

Steve

However I agree...

beejug1983

You need to consider how this table is to utilized ... what is a typical T_SQL command to be executed against the data in the table once you have...

Steve - thanks for the heads up on this emerging technology.

I can see it metamorphose into a replacement for the mouse to maneuver through a GUI check boxes,...

Only...

chereku - You have been on this site frequently enough to know that posting your question should include table definitions, and easily useable sample data.

For your next forum question, Please,...

Might I suggest that you trouble shoot your query... first run this code:

SELECT PlayerID,Username

FROM dbo.Players

WHERE PlayMode='p'

Do you...

Just a thought... could you accomplish what you require by setting up SYBASE as a linked server. If so .... read this:

How to create a linked server in SQL...

Try putting in the date with a time of midnight for example

2010-06-08 00:00:00.000

and see if this gives you the results you require

To give you an idea of the size to which your work can grow. Here is a table used by one company (author's name is unknown):

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER...

The one credo I have followed is:

"Do unto others as you would have them do unto to you"

Congratulate them in public, and privately for a job well done.

If you must...

PaulB-TheOneAndOnly

That's a good idea and some of the better designed apps I've bumped into include such a centralized log resource. Be aware this is a project on itself, the...