Search results for query: *

I used STRING_AGG instead in the end - works lovely.

Will try both thank you

Hi there, I am trying to return some data in Transact SQL. The small example table below shows the core data and the Example OutPut shows what I am trying to achieve. I want one row per Client however I cant think of a way to do this. Any ideas anyone. Example Date ClientNo SystemID...

kray4660 you a star thank you that all worked perfectly

Hi Kray4460 No error just wrong result set - in this one IIF(Fields!Prospect_Stage.Value = "Client Take on" OR Fields!Prospect_Stage.Value = "Legal" OR Fields!Prospect_Stage.Value = "Offer Accepted", "Accepted Offers/Legal" I get three different Group Headings - all the correct name but only...

Hi All, I am trying to create a group based on certain informtation as shown below - the first group will create a different group header for each value it finds i.e it would create one if it found "Client Take on" one for "Legal" and one for "Offer Accepted" What I want it to say is of its in...

Hi Olaf - will give it a whirl - your a star many thanks

Hi there, In my query results below I have returned three rows of data - what I want to do is say If EndDate (Row 2) = SetDate (Row 3) then 1 else 0 I cant for the life of me work out how to do it. Any help would be gratefully received. SetDate EffectiveDate End Date 2017-12-20...

Dear Forum, I have a datebase that excludes weekends. However I have been asked to create a query that includes weekends to allow for 365 day average of the data. The small snipet below is the main query to return everything (havent put in a date range as yet). Anyone got any idea's how to do...

will do thank you for the advice.

Hi there, yes all macros enabled - settings look exactly the same - I have checked all obvious things. Just wont let you do anything at all - cant right click on it - nothing. Yet on Laptop works fine. I cant work it out - I even reinstalled Office.

Hi there, I have a weird one. I have an excel sheet that has a button that sends stuff to Sun Systems. Now if I open it up on a laptop the button works fine - opening on a desktop and nothing happens, the button does not depress...no data sent...nothing. Both on Excel 2007. I just dont get it...

HI LB, your right I could certainly use that - issue is they will need to know what is the actual end page of a Customer. However it may be worth me asking them if Page 3 of 3 etc Many thanks

Hi there, History I have been asked to write a Statement of account for customers. This will be one report but will have multiple customers in it - grouped by customer. This report will then go off to a mailing house to be printed and sent out (we have about 6000 customers) Issue The issue...

Thanks PWise - I will give it a whirl.

Hi All, I have a database that only updates on working days - for instance tonight it will roll forward and upload data from todays transactions then nothing for Saturday nothing for Sunday. I have been asked to create a query (for averages) that will show all days in the month regardless if...

Hi there, I am using - SAP BusinessObjects BI Platform 4.1 Support Pack 1 Version: 14.1.1.1036 I have created a report and want to use the Document Link to share the report.(as shown below)...

I have resolved now - turned out I didnt put the correct table name in one part.

Hi there, sorry for the delay ssage: [SQL5001] Column qualifier or table FFS01P0A1 undefined. Cause . . . . . : Name FFS01P0A1 was used to qualify a column name or was specified as the operand of the RRN, RID, HASHED_VALUE, PARTITION, NODENAME, NODENUMBER, DBPARTITIONNAME, DBPARTITIONNUM...

Hi there, I am trying to create a script that will show all the information I require. In one table I have a field called RECTYPE - now RECTYPE can be 801, 802, 803, 804 - it may exists sometimes for one user or not for another. In my simple mind I thought of just using a LEFT OUTER JOIN Twice...