Thanks for the pointers, the articles are good but nothing much said on performance side, as we are going to have it in datawarehouse so is it feasible to store...

Hi,.

Great, this is what i was looking for , i made some changes as per my req and its giving me the results, its cool...

Thanks a lot for your time...

actually we want write a pieace of sql code and want to put it in SP but no luck so far

HEY PAUL

THANKS FOR THIS ONE sys.sql_modules ...

it really helped me...

Mithun

yeah this coluld be done , i can loop this view and using sp_helptext i can replace db1 with db2... seems cool let me give it a try ....

thx a...

thanks for ur replay,,

but i m not sure how to implement the logic given by u in ssis packages, i mean what transformations do have to use and all... if...

hi,Gianluca

thanks for ur reply...

see here dataset name will remain same for all.

database name can be diffrent and each database can have tables...

so this is the kind of rule ....now can...

MAY BE THIS CAN HELP..

DECLARE @sql NVARCHAR(512)

DECLARE @MaxCount INT

DECLARE @Count INT

DECLARE @FieldName NVARCHAR(512)

DECLARE @DBName TABLE (fldID int IDENTITY(1,1), fldDBName varchar(512))

INSERT INTO @DBName (fldDBName)

SELECT 'Test1' UNION ALL

SELECT 'Test2' UNION...

yeah u should try isnull(flag,1), have u tried it or not?

viswa (4/30/2009)

---

Hi u r correct but If the numeric like (17,3) mean how can u filter that

EX:

amount is (10.568) then the if condition will not work.....

hi viswa,

Good morning...

Before u read on make sure that there will be always only 2 decimals will be there in ur values and i wrote it in bit of hurry...

hi Grant,

Thanks for ur reply and i will be surly reading those articles and also will pickup the book Kalen Delaney's Inside SQL Server 2005.....

thanks for ur time and...

Try adding a lot more data (at least 10000 rows) and try again. I'm guessing that you'll see quite a different behaviour on some of them. 10 rows is far...

I was just expecting reply from u as i just saw u replyed some other post answers.....

thanks for repl Gail ....fine i will put more data into it and will...

inputfieldid is limited to three otr it can be more then 3 also.