Run your sample query and turn on the execution plan. Review the plan and see at what point the where clause is used.

You can always reverse the string then count the commas until you encounter the 'R'.

Not sure if this will give you the right answer but try:

Declare @user_id varchar(50)

Set @user_id = suser_sname()

Select @user_id

It's what I've used in some scripts to identify the person executing the...

I managed to catch some good flicks recently.

Grand Torino 4.5 / 5

Doubt 3/5

Defiance 4/5

Hancock 4/5

Walle 5/5

Kung Fu Panda 4/5

The one that really changed my life though is Fireproof....

I've enjoyed all three of the Bourne movies and have Superbad, Transformers and Spiderman 3 set aside for the next week.

When time permits I try reading the Tom Clancy novels....

Check out the response in http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=368359  Mr. Hamar provides a nice explanation of permission issues across servers that should help you.

I haven't used c#, but couldn't you expose the File System Object of the image and check the size?

I believe that the numbers correspond to the order that the data types appear in the Data Type column on the Destinations tab of the Transformation task.

use the DateDif function.  Refer to BOL.

From the Excel Help file.

You can import data to Excel from most data sources by pointing to Import External Data on the Data menu, clicking Import...

Sounds like you're in need of an archive solution.  Backup your Database and Log files and do a weekly deletion maybe.

If Excel is the route you have to take you'll...

2 other thoughts on the subject (via another post that made me think of this).  Send the reports via Access Snapshots (http://www.microsoft.com/downloads/details.aspx?familyid=b73df33f-6d74-423d-8274-8b7e6313edfb&displaylang=en is the link to the snapshot viewer that...

If it's a matter of the end user needing the Snapshot Viewer from MS use this link, http://www.microsoft.com/downloads/details.aspx?familyid=b73df33f-6d74-423d-8274-8b7e6313edfb&displaylang=en , otherwise the issue is that rtf files convert objects to lines...

start here.  It's a webpage, but it will give you the basic connection strings you'll need.

http://msdn2.microsoft.com/en-us/library/ms992495.aspx

Try this.  http://msdn2.microsoft.com/en-us/library/aa933534(sql.80).aspx