Hi Alan and Magoo...

Thanks for the info , I do have a dimdate table and it does work, except you're right about losing the calendar control. If when you have...

Hi Alan

Thanks so much, it work great and I even understand it 🙂

I did run into the problem that AddressType will not take a null because it is a multi...

Hi Alan

Thanks for getting back so quick.

I get most if it, just a bit confused on the dataset part.

Here is the dataset I am using, if you could incorporate it...

I will definitely be able to use this for something, but I did find a problem with the formatting,

I got en error because one record had parenthesis in the...

That works great, Thank You....

And if I looked at the table "Just a bit" closer I would have seen that DOB was there... lol

But I did learn something...

Thanks Scott,

I could get my head around it, I started doing it with if statements around selects, but this is much cleaner..

Thanks

Again

Great this worked!!!!

adding this onto my daily restore job..

Not sure if its the best way ???

thank you

CREATE USER [SSRSUser] FOR LOGIN [SSRSUser] WITH DEFAULT_SCHEMA=[dbo]

EXEC sp_addrolemember 'db_datareader', 'SSRSUser';

Thanks for getting back.

I get this backup from an outside source where we use canned software.

They send us a backup of the table data daily and the user doesn't...

Sorry I left out that the tables do have an ID field to match on

I did come up with this but wondering if there was a better way?

Thanks

SELECT ...

Thinking about it ... I think I need to do a UNION ?

Hi

I have read a bit and think it cannot use a wild card

I seems that this addition will work..

declare @Bakpath varchar(80)

set @bakpath = 'C:\xxx\ExtractedData\app_xxx_backup_' + cast(year(getdate()) as varchar(12))...

Thanks for the info, definitely helps...

I was also wondering if I was using the view Gui interface where I can pick tables or other views if I can point it...

Hi Sean

Thanks for the help with this..

As usual I can't explain myself.

Everything work except the carraage return.

I tried CHR13, but when I copy and paste into say .. notepad...

Sean helped me with this awhile back..

I need to add a carriage return between each record and I seem stuck !!

Once I get the carriage return it getting exported...

I finally figured it out...

I'm using =CDate(Format(Parameters!EndDate.Value, "yyyy-MM-dd" & " 23:59:59")) which gives me the end date @ 23:59:59