Viewing 15 posts - 361 through 375 (of 402 total)
Not trying to be picky, but sp_MsForEachTable uses a cursor internally.
Interesting I didn't know this, but now I think about it makes sense I suppose...
Learn something new every day! 😉
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
February 29, 2012 at 3:20 am
Very difficult to say without much more information, however it sounds like you have multiple steps in your job and the step that calls your package is not set to...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
February 29, 2012 at 2:56 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
February 29, 2012 at 2:34 am
Do the ID columns all have the same name or are they different?
If so this would work I think
CREATE TABLE #temp (TableName VARCHAR(200),TableCount BIGINT)
INSERT #temp
EXEC sp_MSForEachtable 'select ''?'',Max(ID) from ?'
...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
February 29, 2012 at 2:24 am
Hi
Difficult to say without seeing much more info like DLL's and Data.
However taking a shot in the dark would the undocumented procedure msforeachtable be of use to you
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
February 29, 2012 at 2:12 am
Your welcome - Glad to be of help 🙂
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
February 28, 2012 at 9:58 am
Its because the query is doing exactly what you are telling it to do and only returning records WHERE IsNull(App_FK_EventID, 1382) = 1382
This should work for you
I haven't tested 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
February 28, 2012 at 9:50 am
Welsh Corgi (2/23/2012)
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
February 23, 2012 at 7:17 am
Or you could just drop all of the Keys as part of your load and then re-build them once the tables have loaded - this way you can load the...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
February 23, 2012 at 7:03 am
Your User field I'm making the assumption that its a string data type and is a name that you need to order A - Z (or Z - A) and...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
February 22, 2012 at 8:06 am
Hi
Have you tried putting an ORDER BY in the query?
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
February 22, 2012 at 7:28 am
thanks for posting your solution 🙂
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
February 22, 2012 at 2:27 am
No Worrirs Peter glad to have been of help 🙂
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
February 22, 2012 at 2:25 am
Hi Peter
Does this help?
=IIF((Fields!IsSales.Value) = 1 OR (Fields!NEWBOSS.Value)= 0,True,False)
Although your logic will show as visible if either Sales = 1 OR NEWBOSS = 0, not necessarily both
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
February 22, 2012 at 2:18 am
Hi
Right click on the column that you want to hide Column Visibility>Show or Hide based on an expression the expression you want is:
=IIF(Fields!IsSales.Value = "1",TRUE,FALSE)
If you want to do 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
February 21, 2012 at 9:47 am
Viewing 15 posts - 361 through 375 (of 402 total)