Hi dwain,

The link help me to reach a solution.

I have used the SAP Data services History Transform and acheived the desired result.

Thanks, Shilpa.

Sorry, How do I group the office name into three different segments withouth the case statement?

Hi,

Thanks for the reply. I have ran the below Mdx statement as you suggested, but its giving and "type mismatch" error. Can you pleaes let me know how to go...

Hi Jeff & Bit Bucket,

Thanks for the reply, Jeff I am using Stuff at the moment but I have around 5 UDF's for each table which generate a comma delimeted...

Plz guys I need some suggestions.

Would it be better if I just used a html page instead of SSRS report? If yes can you guys post some suggestions on how...

Hello Forum,

Just a bit of clear picture about my project.

The SSRS 2008 report is rendered as HTML4.0 format using the using microsoft SQL reporting service provided WebService.

The render method returns...

hi Vireen,

Thanks for the reply, can you please let me know how did you do that SSRS report? Some direction would be nice to get me started.

Thanks, Shilpa.

hi,

I just noticed why the problem is happening if I inlcude only the columns with number data it works no problem if I inlcude the columns with both character and...

hi,

Thanks for your reply, But I keep getting the same error message is there any other reason you can think of why its happening.

Thanks, Shilpa.

Cold coffee made me coolllll 😀

hi,

The code worked perfectly, wow you are a start. Thanks a lot for your time.

Shlipa.

hi,

Thanks for your reply.

The problem is not all companies will have the email format as firstname.lastname some may have firstname_lastname and so on. If you look at the sample data,...

hi Lowell, Bhuvnesh,

The whole point of this is we have acquired a database from third party which do not have email.

So I have to update the email column in the...

hi Lowell, Bhuvnesh,

Thanks for the reply, sorry I coudn't reply yesterday.

Please see below for the sample data and desired result

Create Table dbo.Test_emailformat

(

[PersonID] [int] IDENTITY(1,1) NOT NULL,

company varchar(100) NOT NULL,

firstname...

hi,

Can i ask you one more question:

Can you please explain the logic as to using both pivot and unpivot?

Thanks, Sharon