I totally agree with SQLSister using a cursor to do this will kill your performance especially if your doing this every time on a insert. I would insert all your records into a temp table to do your work then insert into the main table as a final step.
I am trying to use a job node to decide the order of steps based on criteria.
if datepart(dw,getdate()) = 1
return job Success
else
return failure
this way i can add a step if its sunday and skip it every other day.
Does anyone know how to add a pagelet to a report. I want to create a dashboard that can run a report within the main page without refreshing the entire report.
The migration does take a large chunk of time as its not as easy as they make it sound. The of the biggest pains is report rebuilding some syntax does not port through properly as well as we have been experiencing prompt problems. The upgrade is definitly worth it but take the time you planned...
I have been working on converting Impromptu reports to ReportNet for the last few weeks. What i have found is there is no great way to accomplish this task for very detailed Impromptu reports. We have had a consultant from cognos here and still we have virtually rewrite all the reports. If there...
I just had this issue yesterday.
((?Time_Zone?='East') and ([DWH Production Rogers].[Eastern Standard Time]between ?start_date? and ?end_date?))
or
((?Time_Zone?='Central') and
([DWH Production Rogers].[Central Standard Time]between ?start_date? and ?end_date?))
or ...
The thing to...
I want to sort based on a users prompt. I am able to do it without a problem for columns that are not aggregated. I would like some solutions based on sorting aggregated columns if any exist.
currently im trying to get a child tabular model to do the aggregation but I am running into a cross...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.