This is a common issue when attempting to ‘bubble’ up data from a chain of stored procedures. A restriction in SQL Server is you can only have one INSERT-EXEC active at a time. I recommend looking at How to Share Data Between Stored Procedures which is a very thorough article on patterns to work around … Read more
Haha, oh boy, I figured it out. Somehow, someway, I did not install the Database Engine when I installed SQL Server 2008. I have no idea how I missed that, but that’s what happened.
Try: And yes, you can reference common table expression inside common table expression definition. Even recursively. Which leads to some very neat tricks.
IF you have tables A and B, both with colum C, here are the records, which are present in table A but not in B: To get all the differences with a single query, a full join must be used, like this: What you need to know in this case is, that when a record can be found in A, but not in B, … Read more
It’s picking up the commas within the comments field as delimiters, because the delimiters are not consistent. The best solution is to insure that all fields are wrapped with double quotes and set FIELDTERMINATOR to ‘”,”‘. Alternately, replace the commas with something unlikely to be in the comments (like ~) and set FIELDTERMINATOR = ‘~’.
If it is an Express instance, it is most likely not a default instance, but rather a named instance. So you probably meant: Otherwise you’ll need to show us the server properties in SQL Server Configuration Manager on that machine in order for us to be able to tell you how to correct your connection … Read more
You do not need to interact with managed code, as you can use LIKE: As your expression ends with + you can go with ‘%[^a-z0-9 .][^a-z0-9 .]%’ EDIT:To make it clear: SQL Server doesn’t support regular expressions without managed code. Depending on the situation, the LIKE operator can be an option, but it lacks the flexibility that regular expressions provides.
The max size for a column of type NVARCHAR(MAX) is 2 GByte of storage. Since NVARCHAR uses 2 bytes per character, that’s approx. 1 billion characters. Leo Tolstoj’s War and Peace is a 1’440 page book, containing about 600’000 words – so that might be 6 million characters – well rounded up. So you could stick about 166 copies of the … Read more
You will want to use the YYYYMMDD for unambiguous date determination in SQL Server. If you are married to the dd-mm-yy hh:mm:ss xm format, you will need to use CONVERT with the specific style. 5 here is the style for Italian dates. Well, not just Italians, but that’s the culture it’s attributed to in Books Online.
To locate the troublesome row use the errorfile specifier. myRubbishData.log will have the offending rows and a companion file myRubbishData.log.txt will give you row numbers and offsets into the file. Companion file example: