Viewing 15 posts - 316 through 330 (of 402 total)
Cadavre (3/29/2012)
SELECT Company,...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
March 29, 2012 at 9:23 am
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...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
March 29, 2012 at 9:21 am
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
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
March 29, 2012 at 8:44 am
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...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
March 29, 2012 at 8:08 am
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...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
March 29, 2012 at 7:27 am
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...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
March 29, 2012 at 3:43 am
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,...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
March 29, 2012 at 3:28 am
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
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
March 29, 2012 at 3:03 am
Your Welcome
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
March 29, 2012 at 2:49 am
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
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
March 29, 2012 at 2:21 am
I'd stick with triggers as it prevents people "forgetting" (intentionally or not).
Agreed 😀
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
March 23, 2012 at 4:35 am
MysteryJimbo (3/23/2012)
Andy Hyslop (3/23/2012)
I will say that yes...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
March 23, 2012 at 4:31 am
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...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
March 23, 2012 at 4:16 am
hbtkp (3/22/2012)
i dotn have that parameter in data set, Parameters internal to this proc that are derived from other parameters.
OK its difficult to understand whats happening without seeing the SP...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
March 23, 2012 at 3:19 am
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...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
March 22, 2012 at 2:54 am
Viewing 15 posts - 316 through 330 (of 402 total)