Additionally, you could use a numbers/calendar table with a UNION statement or an outer join to force all of the months/years to appear regardless of if they have data or...

Why not just order by the date instead of the datepart?

Never Mind about the additional datasets, for some reason I was thinking you could use an expression to switch the dataset for your table/matrix etc during report execution, apparently I...

How's come you want to use DTS. Can't you just pass that data through to a query/stored proc that is setup as a report with the default option of...

Ahh gotcha, I was thinking more of the traveling salesman/remote user type scenario...

How are trusts handled between the domains or do they not interconnect at all except via your application?...

How many columns are we talking about here?

If the number is small you could create a dataset for each of the columns and you could put some logic in to...

These are users connecting to an intranet box who already have domain logins right? I may be incorrect, but I was under the impression that if you're using per...

There's an option in the linked table manager to relink, but I've at times seen this just propagate issues like what you are dealing with. I'd suggest deleting the...

Take a look at the following KB article and see if it helps.

-Luke.

http://support.microsoft.com/kb/811889

Ok, now I have enough data to look at and perhaps understand what you are trying to accomplish.

I do have a couple of more questions though... In your final...

I'm still having trouble visualizing what you are trying to do.

So you've given some pseudo DDL but no sample data. Without that all I can do is guess at...

I'm actually surprised that the data being in a variety of less than optimal datatypes, like a float for a phone number, isn't causing you issues all over your app....

yeah it's the precision that's screwing you.

try this...

declare @phone float

SELECT @phone = 5197531212

select cast(cast( @phone as decimal) as char(10))

I'm still not understanding what you are looking for. Can you include some DDL for your tables and perhaps an example of what you are looking to get as...

Nice Chris, Stuff is just one of the commands I completely forget about because I never have need for it.

I get...

2008-10-03...