Thanks wz700.

This is another way to 'solve' the problem. Simply replace the "unparsed" @PassedDate parameter in the @FixedFilterData with the parsed value of the input parameter.

DECLARE @XDate VARCHAR(30)

DECLARE @PassedDate...

Thanks srankin for your reply. But this solution will run each SPROC for a given customer in turn and not run all SProc at the same time.

Ex: Cust_ID 1 has 5...

Try this:

CREATE TRIGGER dbo.AfterInsertSysData ON SystemDataTest FOR INSERT

AS

IF EXISTS(SELECT rid FROM Inserted)

BEGIN

INSERT INTO Books(rid,fname,book_date)

SELECT s.rid,s.fname,s.book_date)

FROM SystemData s, inserted i

WHERE s.rid=i.rid

END

ELSE

BEGIN

RAISERROR('No rows were inserted into the SystemData table.',16,1)

END

Thanks Frank.

Not quite what I want. The link provides a solution similar to what I have just now. My main question is whether it is possible to pass an entire...

Thanks Scotts and JPipes for your very helpful replies.

PS: Scott, the spreadsheet is excellent.

Thanks jpipes for the reply. The overall objective is to estimate the space used to store in clustered index! For this, I not only need to find out the...

You could use this:

create table #temp

(

rowid int,

dataval varchar(30)

)

insert #temp(rowid, dataval)

select 1, 'one,two,three,,' union all

select 2, 'one,two three four' union all

select 3, 'one,twothree'...

Because SQL server recreates Tempdb each time the server is stopped, you could use this script for tracking uptime.

SELECT DATEDIFF(hh,crdate,GETDATE()) AS UpTimeHrs

FROM MASTER.dbo.SYSDATABASES

WHERE name = 'TempDB'

Thanks very much mccork.

Exactly what i was after.

Have you tried using BCP (cf. BOL) to import the file's data into a table and then updating the columns as required

e.g. UPDATE TableName

SET Col1 = null WHERE Col1...

You could save the package as a "Structured Storage File". (check BOL for "Structured Storage")