Recent content by GHolden

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

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

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.

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

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

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.

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.

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.

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.

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.

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.

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

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.

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

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