Viewing 2 posts - 1 through 2 (of 2 total)
You should use a funcation.
define a funcation like
CREATE FUNCTION [dbo].[SplittingByDot]( @SourceData varchar(255))RETURNS NVARCHARASBEGIN......END
CREATE FUNCTION [dbo].[SplittingByDot]
(
@SourceData varchar(255)
)
RETURNS NVARCHAR
AS
BEGIN
......
END
then use the
SELECT dbo.SplittingByDot(OutlineNumber) FROM dbo.Tally
get the result
March 15, 2010 at 6:57 pm
#1134187
From
http://swethasankaran.wordpress.com/2009/04/09/analysis-services2005-memory-usage-issue-and-fix/
Analysis Services(2005) Memory Usage Issue and Fix
Jump to Comments
What?
SQL Server 2005’s Analysis Services uses a process titled Msmdsrv.exe
The memory used by this process does not decrease...
May 14, 2009 at 2:45 am
#994323