Recent content by chrisssyp82

I'm thinking now a workflow from a list maybe the only route. Is it possible to create a workflow similar to the "Collect Feedback" workflow, but caputure feedback from multiple users?

There is about 300 reports and we're trying to determine which ones are in use and which ones are not. I think doing a survey for each report would for one take a lot of time and two wouldn't be very user friendly. It may turn out that sharepoint may not be the answer to this issue, but i'm...

I have a list of reports in our business and what i want to do is send out a survey to every user asking them a set of questions per report. For each report we want to ask the following questions: Do you use the report? Y/N How often do you use it? Daily/Weekly/Monthly/Quarterly/Annually Is...

Right so now i have the following code which is pretty close, however the two opening and closing balances don't seem to be merging and removing the old opening and closing balances? Does anyone have any ideas? Am able to supply test data if required. Thanks CREATE TABLE #Workbook ( ID...

what i mean to say is only merge records where there are two capital accounts? ie where AcctType = 'CCY' AND w.AcctSubType = 'SET' and for the same currency? So add some more to the where clause before the union? Sorry i think i'm gettin myself overly confused over this, basically my code at...

Unfortunately this seem to make no difference. I still have the same table as i started with. Would not only want to merge the records where certain fields met a certain criteria?

I'm guessing the code would start something like this: IF(SELECT Count(distinct w.AcctID) FROM #Workbook w WHERE w.AcctType = 'CCY' AND w.AcctSubType = 'SET' AND w.Curr = w.Curr) > 1 BEGIN ................. ?

Basically in an ideal world you have one capital account per currency, but as we all know this isn't an ideal world and on occassions we have two capital accounts per currency. So basically as a step in my stored proc i want to be able to check for more than one capital account, and if there is...

SQL Server 2008 Hi I have an issue where i have two of the same accounts which i would like to merge together, the list looks like below: AcctID AcctType AcctSubType Curr TransType Amount 1 CCY SET EUR Opening 1000 1 CCY SET EUR BUY...

Cool i understand what you're saying now. Thanks for your response, was very helpful.

thanks for the response, however i'm confused as to why you have added this piece of code: WHERE Rt.Pk IS NULL What is rt.pk?

I've tried that and i still get the same error message.

SQL 2008 I've created a script which returns a list, however when i want to pass a field from my select in @Worktable into a parameter of a function which is linkted to @Worktable i get the error: "The multi part identifier 'pos.alt_curr_cde' could not be bout" My script is: Use...

Tanks for that mate, makes sense.

Right sorry, i've got the list now in my list of fields in SSRS from the select i've added above. So how can i get this to link to my @Worktable table?