Although your problem appears to be leading blank characters it is possible that they may be other non-printing characters. May I suggest you read the following and check your...

JanJan-200247

Now I do not profess to know how this can be incorporated into your Reporting Services work flow or T-SQL for the data selection, but go to this Simple Talk...

This is a duplicate posting of:

http://www.sqlservercentral.com/Forums/Topic869819-1292-1.aspx

go to TechNet type in "migrate sql 2000 to sql 2005"

http://technet.microsoft.com/en-us/default.aspx

You will have 30,000 articles available - I am sure some of them will provide you the information you need

You may want to examine the default trace to answer your questions. Here are a few links to assist you:

Default trace - A Beginner's Guide

By Adam Haines, 2010/06/11 (first...

To receive relatively quick assistance please post your table definition, sample data / desired output and what work you have attempted as per the directions in the first link...

A new poster on SSC (helping in a forum) You all might be interested in his introduction of himself and who knows welcoming him to the community.

RainbowFfolly

http://www.sqlservercentral.com/Forums/Topic867207-131-1.aspx#bm868667

May I suggest you read this article by Jeff Moden ... it has a good deal of sample code, and will assist you in solving your problem.

http://www.sqlservercentral.com/articles/T-SQL/63003/

njaramil

If you post your table definition, sample data, expected results and what T_SQL you have tried to use, following the format as described in the first link in my...

I suggest that you read the following:

http://msdn.microsoft.com/en-us/library/ms175464(SQL.90).aspx

Amongst other text it contains:

Referential Integrity

Although the main purpose of a FOREIGN KEY constraint is to control the data that can be stored...

The Databases and Files Catalog View sys.backup_devices contains a list of backup devices.

Further if no backup device is specified in the backup command the:

BACKUP DATABASE AdventureWorks

TO...

Are you sure you are at the correct site?

IIF and DLOOKUP are ACCESS Visual Basic For Applications (VBA) functions ....

Juan de Dios (2/16/2010)

--------------------------------------------------------------------------------

This script is very useful when all the rows are not NULL, but if you modify the insert of Mark with NULL, the script only returns Bill.

insert...

Jason

And Steve was off today on a ski trip ... but he did manage to add to the question "SQL Server 2000". but said nothing about...

Tom.Thomson

Thank you for the clarification -- now I understand your point.

As one objective of the QOD is to teach - I have learned a bit more about wording the explanation....