What controls are using to create the report? A table, a list and textboxes? Depending on the controls you are using the answer may vary. If you...

I believe you want to check the ANSI_PADDING setting. That does affect how trailing blanks (spaces) are handled.

Okay, as I said in my first post:

Could you post the structure of the table you are querying, some sample data, and your current query? See the links in...

Can you post the DDL for the table and some sample data? See the links in my signature for how - to.

With the DDL and test data you can...

Grant Fritchey (2/11/2009)

---

I would go with a single Address table and then join tables to the different entities that use it. This allows you to have a single source for...

Looks like it would work. One of my preferences is to to use an identity column as the primary key (adding a unique constraint on the true primary key)...

mcloney (2/11/2009)

---

Hi Andy,

Great intro article on SSIS! I've been working with it for over two years, but had never tried anything similar to your "data probe" technique. It...

Well, I wasn't clear on if he was installing a new instance or upgrading the existing with Reporting Services or Analysis services. I assumed upgrading the default. Sure...

DanCafeFood (2/11/2009)

---

I

There is a one to many relationship between room and course (1 room can have

many courses)

There is a one to many relationship between Course and Teacher (1 course can...

Could you post the structure of the table you are querying, some sample data, and your current query? See the links in my signature for some help on this.

What...

It doesn't look to me like you have uninstalled. It looks like you already have default instances of Analysis Services and SQL Server, so you would select Default.

If you use ISO format yyyymmdd in your queries then it will work with all language settings.

Check this out:

SET LANGUAGE us_english

SELECT

ISDATE('20091231'),

ISDATE('12/31/2009'),

...

Nice article Andy. I've never used the multicast task and didn't have an idea why I'd use it, but this is a good way use for it in my...

It certainly seems like the volume has picked up again. Last November it seemed like things had slowed down, now there are plenty of questions to answer again. ...

You would need to create a role or roles in the each database. For the situation you describe I would have a Developers role, and Application Users role and...