Cadavre (3/29/2012)

---

3,000 visits and you haven't learnt that the best way to get answers to your questions is to provide consumable sample data rather than a non-consumable table?

SELECT Company,...

Here's another way - I've also created the data for you as well 😉

CREATE TABLE #TEMP

(Company INT,Category VARCHAR(50),AcctgDate INT,Sequence INT,Amount MONEY)

INSERT INTO

#TEMP

SELECT 85,'WritPrem',11201,2,73.00 UNION ALL

SELECT 85,'WritPrem',11201,2,73.00 UNION ALL

SELECT 85,'WritPrem',11201,2,-73.00 UNION...

No as far as I am aware if you are set to Full Recovery then it will be logged:

http://msdn.microsoft.com/en-us/library/ms191244.aspx

Yes it would certainly do the trick for you - I have had colleagues who have used this method in the past successfully and SELECT INTO is minimally logged.

My personal...

What is your loading strategy - if you have a strategy where you do a destructive full load i.e. dropping all of the tables, rebuild and reload then I would...

Thats just the default location, as I don't know how your version has been installed I have no way of knowing where it would be located on your machine.

That being...

yep you can store it anywhere you like it will just change how you add the file to the project.

Using the above way you are adding it as a template,...

You can set up your own templates in SSRS - This link should help you out

http://lukehayler.com/2009/08/create-your-own-reporting-services-templates/

Andy

Your Welcome

Assuming that you just want to Insert all of the rows and not update existing rows:

INSERT INTO

Academic

(ID,Ename,Qualification)

(

SELECT

ID

,Ename

,Qualification

FROM

Personal

)

Andy

Agreed 😀

MysteryJimbo (3/23/2012)

---

Andy Hyslop (3/23/2012)

---

It depends on many things, how many triggers, how well written, data types, how many tables they are hitting the list goes on.

I will say that yes...

It depends on many things, how many triggers, how well written, data types, how many tables they are hitting the list goes on.

I will say that yes a trigger does...

OK its difficult to understand whats happening without seeing the SP...

Hi

Have you removed the parameter from the dataset and the parameter list?

If you have only removed it from your dataset the parameter is still held and it is possible this...