Database

CREATE FUNCTION [dbo].[ReturnNumber](@Parametri VARCHAR(8000))<br />
returns  varchar(8000)<br />
as begin<br />
<br />
declare @i as int<br />
set @i=0<br />
<br />
declare @resultNumber as varchar(8000)<br />
<br />
while(@i<=len(@Parametri))<br />
begin<br />
	set @i=@i+1<br />
	<br />
	if(select isnumeric(substring(@Parametri,@i,1)))=1<br />
	begin<br />
	set @resultNumber =@resultNumber+substring(@Parametri,@i,1)	<br />
	end<br />
<br />
end<br />
<br />
return @resultNumer<br />
END

select dbo.ReturnNumber('AA432k')

select dbo.ReturnNumber(varcharcolumn) from test

.<br />
.<br />
.<br />
declare @resultNumer as varchar(8000)<br />
set @resultNumer =''<br />
.<br />
.<br />
.

CREATE FUNCTION [dbo].[fn_DelimitedSplit] 
(
@TextToSplit VARCHAR(8000), @Delimiter VARCHAR(255)
)
RETURNS @SplitKeyword TABLE (Keyword VARCHAR(8000),seq int identity)
AS
BEGIN
 DECLARE @Word VARCHAR(255)

 WHILE (CHARINDEX(@Delimiter, @TextToSplit, 1)>0)
 BEGIN
  SET @Word = SUBSTRING(@TextToSplit, 1 , CHARINDEX(@Delimiter, @TextToSplit, 1) - 1)
  SET @TextToSplit = SUBSTRING(@TextToSplit, CHARINDEX(@Delimiter, @TextToSplit, 1) + 1, LEN(@TextToSplit))
  INSERT INTO @SplitKeyword(Keyword) VALUES(@Word)
 END
 
 INSERT INTO @SplitKeyword(Keyword) VALUES(@TextToSplit)
 return
END

Declare @Code vatrchar(50)
set @Code = 'a_b_c'
select Keyword,seq from dbo.fn_DelimitedSplit(@Code,'_')

CREATE TABLE [dbo].[Table_1](
	[RecordID] [bigint] IDENTITY(1,1) NOT NULL,
	[Disposition] [nvarchar](50) NULL,
	[First] [nvarchar](50) NULL,
	[Middle] [nvarchar](50) NULL,
	[Last] [nvarchar](50) NULL,
	[Suffix] [nvarchar](5) NULL,
	[Address1] [nvarchar](100) NULL,
	[Address2] [nvarchar](100) NULL,
	[City] [nvarchar](50) NULL,
	[State] [nvarchar](2) NULL,
	[ZipCode] [nvarchar](10) NULL,
	[FileName] [nvarchar](100) NULL,
	[CheckedOut] [nvarchar](5) DEFAULT ('false') NULL,
	[CheckedOutDateTime] [datetime] NULL,
	[Completed] [nvarchar](5) DEFAULT ('false') NULL,
	[ReturnedFailed] [nvarchar](5) DEFAULT ('false') NULL,
	[ImportedRecord] [text] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

Nostrom0 wrote:

1. Is this problem caused by the fact that the PRODUCTS_TABLE and/or the MV_MASTER_PRODUCTS tables both now have additional fields that are not referenced in the MV/Snapshot script itself, and these changes are causing the script to "stall"?

Nostrom0 wrote:

2. Are MV scripts not meant to be edited, or is this just a problem with TOAD, or with my permissions? i.e., am I supposed to create a new MV to replace the old one instead of editing the existing script?

//I'm sorry but I have to get your database dirty with this test table
CREATE TABLE TEST(F1 NUMBER(1),F2 NUMBER(1),F3 NUMBER(1))
/
INSERT INTO TEST VALUES(1,2,3)
/

SELECT X.C1 AS "COLUMN NAME", Y.C2 AS "VALUE"
FROM
(SELECT column_name AS C1 from user_tab_columns where table_name = 'TEST') X,
(
SELECT  F1 AS C2 FROM TEST
UNION
SELECT F2 FROM TEST
UNION
SELECT F3 FROM TEST
) Y
/

COLUMN NAME                         VALUE
------------------------------ ----------
F1                                      1
F1                                      2
F1                                      3
F2                                      1
F2                                      2
F2                                      3
F3                                      1
F3                                      2
F3                                      3

9 rows selected.

<br />
--And you can keep out of my database please<br />
DECLARE @Tbl Table(F1 int,F2 int,F3 int)<br />
<br />
INSERT INTO @Tbl VALUES(1,2,3)<br />
<br />
SELECT *<br />
 FROM @Tbl<br />
 <br />
 <br />
SELECT 'F1' Col,	F1 [Value]<br />
FROM @Tbl T	<br />
UNION <br />
<br />
SELECT 'F2' Col,	F2 [Value]<br />
FROM @Tbl T	<br />
UNION <br />
<br />
SELECT 'F3' Col,	F3 [Value]<br />
FROM @Tbl T	<br />

SELECT 'My Column Name 1' FROM MyTable
WHERE MyColumn1 = 1 UNION
SELECT 'My Column Name 2' FROM MyTable
WHERE MyColumn2 = 1 UNION

Mycroft Holmes wrote:

--And you can keep out of my database please
DECLARE @Tbl Table(F1 int,F2 int,F3 int)