Search results for query: *

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...

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 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...

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 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...

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)...

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...

Hi there, I have a database that only shows weekday data. I have been asked to write a report that shows Saturday and Sunday Data (which will be exactly the same as Friday data). Can this be done?? Any help would be gratefully received.

Morning All, I have two charts in my reports - both Stacked Bar Charts 1st Chart shows in the Y Axis the value 0M to 10M - the data behind it are all numbers 2nd chart shows in the Y Axis the value 0M to 10.000M - the data behind it are all numbers The 2nd chart needs to shows as 1M 2M 3M 4M...

Hi there, I am sure this has been posted before but I am losing the will to live with it. I created this in the sub report shared CURRENCYVAR fiu; fiu := {FIU.FIUGBP} + ({FIU.FIUEUR} / {FIU.EUREXCHANGERATE}) + ({FIU.FIUUSD} / {FIU.USDEXCHANGERATE}) In the main report I created this shared...

Morning, I have a table that holds IT Call Information. The table assigned an ID and also has a CallID generated by another system. Table shown below ID CallID CallNotes Date AssignedTo 1 1 IT text Test 1 27/04/2015 Mark Cobb 2 1 IT text Test 2 27/04/2015 Mark Cobb 3 2 Test Text 1 27/04/2015...

Hi there, I am trying to install a service from an exe on my Server. The bat file to run the loader runs fine. When I setup the service using either SC or NSSM I get Windows cannot start the service, it could be a windows internal error or a service an internal service error... Any idea's

Morning, I am using a SQLCMD to export data from one view into a CSV file. If I do this on screen running the actual query then highlight the results and save as Export File CSV then the size of the file is say 4mb. If I run from the SQLCMD it about 200mb.......I cant work out why...any...

Hi All, In my database I need to know when a value has changed i.e (below)....on from 02/04/2013 till 24/04/2013 the value was 60000.00 then it went to 5.00. Whats the easiest way to find this value........ 2013-04-02 00:00:00.000 0 60000.00 2013-04-08 00:00:00.000 0 60000.00 2013-04-12...

Morning, I have what appears to be a really stupid question...but everytime I ask my sofwtare house I get a random response. Basicially I need to create a file as on a server as follows:- 001123456702...

Hi there, New to all this so please bear with me. We have a form in a Lotus Database, in this form we are getting the value <capip>, now this value looks like 5613.24758 etc. However in the form we want it to come out as 5613.24. Code below. Anyone help...... Sub ReplaceCapIP Dim WordSelection...

Hi there, New to all this so please bear with me. We have a form in a Lotus Database, in this form we are getting the value <capip>, now this value looks like 5613.24758 etc. However in the form we want it to come out as 5613.24. Code below. Anyone help...... Sub ReplaceCapIP Dim...

Morning All, I am trying to extract the User Name from an evt file as follows CoID={xxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx}: The user xxxxxxxxxxx\Mark Cobb connected on port VPN2-119 has been assigned address 111.111.11.11 So the Mark Cobb is the Part I want to extract, obviously I am...