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: *

  1. GHolden

    I'm creating a stored procedure. I

    Hi, looks like your current database collation is different to the collation of the fields in the table you're joining to. So your temp table is created with the default current collation, but the one you're comparing to was created using a different one. You'll need to specify the collation...
  2. GHolden

    Bulk Insert Multiple Text Files - blank space delimiter and tab-delimited - Error Received

    kjv1611, thanks, not addressing the question as such, however as you're interested in the concept, I'd use SSIS or some other option rather than BULK INSERT, unless it was a one-off import. And in that case I'd just use the basic data import. G There are two ways to write error-free programs...
  3. GHolden

    Bulk Insert Multiple Text Files - blank space delimiter and tab-delimited - Error Received

    Hi, not sure about the error where you are saying it's occurring, however you have double quotes on the FIELDTERMINATOR = " ", which would cause an issue. G There are two ways to write error-free programs; only the third one works.
  4. GHolden

    Need help with a view to show difference in week numbers between sequential records

    Hi, if you're using SQL Server 2012 or newer check out Lead and Lag Explained here: https://blog.sqlauthority.com/2011/11/15/sql-server-introduction-to-lead-and-lag-analytic-functions-introduced-in-sql-server-2012/ Regards There are two ways to write error-free programs; only the third one...
  5. GHolden

    What is ghostservice and why is Word trying to contact it?

    Okay, that's no go then. Not that I'm aware of, quick bit of googling show's that it a not uncommon problem. Only solutions I can find are: Local copies of the templates, code to strip the template refernce out (doesn't solve your problem) and you may as well just get them to send with no...
  6. GHolden

    What is ghostservice and why is Word trying to contact it?

    If you're worried about the doc not looking right if they remove the template.... you get a copy of the Template from them, copy to a local location and then re-link after you receive the file maybe? There are two ways to write error-free programs; only the third one works.
  7. GHolden

    What is ghostservice and why is Word trying to contact it?

    Glad you've got it sorted [thumbsup] Version Control...??? Nope, new one on me... There are two ways to write error-free programs; only the third one works.
  8. GHolden

    What is ghostservice and why is Word trying to contact it?

    IF" it's due to them using a Template that you can't access, I think you can get them to remove this prior to sending the document. Have a look at Word Option - Add-Ins - Manage Templates. There are two ways to write error-free programs; only the third one works.
  9. GHolden

    What is ghostservice and why is Word trying to contact it?

    Could relate to ghostservices.co.uk who offer, hosted desktops (among other stuff)? There are two ways to write error-free programs; only the third one works.
  10. GHolden

    reinstall of XP

    You can continually add to the slipstream folder too, and then you just need to burn a new ISO when you want to use it. There are two ways to write error-free programs; only the third one works.
  11. GHolden

    MS Access insert into SQL Server error - ODBC -- call failed - invalid object name

    Hi, probably doesn't matter but LENGTH is a reserved word so you may need to [] it? There are two ways to write error-free programs; only the third one works.
  12. GHolden

    reinstall of XP

    Hi, if you use nLite (http://www.nliteos.com/) you can slipstream the updates into the XP Install, I did this last night with and SP2 install CD an SP3 update and some drivers, added them to the Windows Install, created an ISO and installed all in one go. There are two ways to write error-free...
  13. GHolden

    Calling an Oracle Stored Procedure from Report Services...

    Hi, you need to use cursors in oracle to return recordset: http://www.oracle-base.com/articles/misc/using-ref-cursors-to-return-recordsets.php Should then just be the same as SQL Server from the SSRS end. There are two ways to write error-free programs; only the third one works.
  14. GHolden

    Downgrade SQL Server 2012 Developer to 2008 R2

    Hi, We have SQL Server 2008 Standard Edition installed on our DB Server. Following an attempt to purchase SQL Server 2008 Developer Edition I was informed by MS that this is no longer available, but I could buy 2012 Developer and downgrade to 2008 R2 as we have volume 2008 licence. Does...
  15. GHolden

    Check for existing database then use else create new database

    Hi, not sure exactly about SSIS, however, this may be of some help to get started. To get a list of databases in SQL use: SELECT name FROM sys.databases WHERE name NOT IN ('master','tempdb','model','msdb') The NOT IN isn't really needed but it just excludes the system databases. There are...
  16. GHolden

    Literally Wrong

    Jamie Redknapp likes to literally use the word to death: "that cross to Rooney was literally on a plate" "Barca literally passed Arsenal to death" "centre forwards have the ability to make time stand still. And when Chopra got the ball, it literally did just that" My personal favourite...
  17. GHolden

    Literally Wrong

    Good point, well made [thumbsup2] There are two ways to write error-free programs; only the third one works.
  18. GHolden

    Literally Wrong

    Apparently it can be used informally for emphasis while not being literally true: I have received literally thousands of letters Source: http://oxforddictionaries.com There are two ways to write error-free programs; only the third one works.
  19. GHolden

    search value in columns

    Hi, I would have a QTY_MIN & QTY_MAX in the table QTY_MIN QTY_MAX DISCOUNT 10 19 15% 20 29 18% etc... Then search for >= QTY_MIN AND <= QTY_MAX There are two ways to write error-free programs; only the third one works.
  20. GHolden

    Import CSV into Excel by Column Name

    Hi, you can connect to the csv file using ADO which allows you to use named columns E.g. Sub readChuteFull() Dim xlcon As ADODB.Connection Dim xlrs As ADODB.Recordset Set xlcon = New ADODB.Connection Set xlrs = New ADODB.Recordset Dim currentDataFilePath As String Dim currentDataFileName As...

Part and Inventory Search

Back
Top