can u please explain how it got fixed ..

i also have the same issue , for the changes which you said is not wrking

Shaheer

any idea abt the solutions..

USE AdventureWorks

GO

DECLARE @listStr VARCHAR(MAX)

SELECT @listStr = COALESCE(@listStr+',' ,'') + Name

FROM Production.Product

SELECT @listStr

XQuery supports four string manipulation functions:

concat() Helps concatenate two or more strings.

contains() Helps determine whether or not a string specified as the...

Please check the Partition Source Queries..Check whether its taking data from Feb only or Jan as well.

regards

Bornsql

Please use this link

http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/0f5aaf0f-8c70-4d70-9412-0d214a8dd30f

Regards

born sql

Hi

You should put the create script like this

Create Table MyTable( mainkey int not null identity (-1,-1))

Then only you will get correct answer.

i got -1,0,1 ,but not yet get...

Thanks, It was very informative........:-D

Hi how about this code whether this will work fine or not

DECLARE @tmpstr2 Varchar(MAX)

SELECT @tmpstr2=replace(OriginalString, char(10) + char(13), '') FROM @demo

SELECT @tmpstr2=replace(@tmpstr2,' ','|')

SELECT @tmpstr2=replace(@tmpstr2,'|','')

SELECT @tmpstr2

[font="Arial Narrow"]

Hi

can you please specify the steps to how to partition the file in AS 2005

[/font]