hi,

pls have a look at this..u can do away with the cursor..

CREATE PROCEDURE TelstraData_Form @paramNumber varchar(30)

AS

INSERT INTO tempo_telstraData (work_item_id,work_item_description,unit_cost,

work_item_quantity,works_type,number,category,

brief_description,

...

Same problem, I had with my Win 2003 box, had to install sp1 for win 2003. pls check whether ur win 2k box has the latest sp on it..i believe...

Jesper,

At my end, both SQL boxes are Win 2003, sorry in win 2000 it has to be start->control panel->admin tools->Component Services..Expanding that u can find the My computer and then...

Hi,

In my end, this works like a charm..

insert #tempcust EXEC [server2].northwind.dbo.usp_test

Some key points to confirm at your end:

1. Go to Start->Run->dcomcnfg.exe

2. This opens the COM+ window. Right click my computer->Check...

Hi,

Try putting SET NOCOUNT ON as the first statement in ur proc.

HTH

Thanks and Regards,

Dilip

Hi AJ,

Hope this helps u to get the desired resultset:

--***************************************************

SELECT distinct

s.apple_part_num, s.apple_catalog_num,

s.qty_on_hand,s.qty_committed,

SUM(d.bag_quantity) AS sampling_inven,

,(select max(work_ord_num) from dbo.tblShipping_sched where apple_part_num=s.apple_part_num) as work_ord_num

,(select max(work_ord_line_num) from dbo.tblShipping_sched where...

I can help you with the script if u put down here some 3-4 table schemas with some sample recs and the way u want the output to come

All...

I can help you with the script if u put down here some 3-4 table schemas with some sample recs and the way u want the output to come

All...

Sapna,

I'm not saying u create 185 temp tables, u make a temp table which is dynamic like e.g. u write a select which joins multiple tables and gets the final...

I'm sorry If i don't understand your problem completely. I think since your need basically is to retreive data from tables with varying schemas, you can write a hand-made SQL...

Yes, what you are doing is rite. The easiest way is to use a sp to create a temp table(depending on the conditions and filters) and then use a DTS...

Chris, i have written an external vbs script which gets me what i want but i have to schedule it and it has to run all the time.

i was just...

I added one more col to my temp table and This will get u the title which you were looking for...

select distinct a.articleid,max(a.assetid) as mediaassetid

,(select distinct top 1 descript from...

I think you should use shrinking mechanism of transaction log. YOu can refer to SQL BOL about DBCC SHRINKFILE and this command you can schedule in a job or automate...

Assuming u have got the data in #tmpMedia table, simply executing this query will do it for you:

select distinct articleid,max(assetid) from #tmpMedia

group by articleid

order by 1

Regards,

Dilip