Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Cobby1812
  • Content: Threads
  • Order by date
  1. Cobby1812

    Multiple Rows in 1 Row

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

    SSRS - IIF

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

    TSQL - Matching data from row 1 to row 2 etc

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

    Include Weekends when weekends do not exist in my database

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

    Excel 2007 - Comman Button does not work

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

    Last Page on Grouped report

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

    Create a Row of Data on Non Business Day

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

    SAP Open Document - Document Link

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

    Using Same Table Twice

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

    Copy data from Friday to a new row for Saturday and Sunday

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

    Crystal Reports Charts - Bar Chart

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

    Using Shared Var value in Chart

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

    Concatenating

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

    Creating a Service in Windows 2008 R2

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

    SQLCMD

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

    Selecting changed data

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

    Low Value Hex

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

    VB Script for Lotus Notes

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

    Lotus Notes Script

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

    Event Logs

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

Part and Inventory Search

Back
Top