Viewing 15 posts - 7,051 through 7,065 (of 7,168 total)
My fault, I missed the distinction you made. SSIS does not handle embedded column delimiters or embedded text qualifiers as robustly as I would like. SSIS will however handle embedded...
March 3, 2011 at 9:41 am
Some thoughts:
1. Don't use Hungarian naming for your procs, i.e. don't prefix with sp.
Try this code:
ALTER PROCEDURE dbo.compare_orders
AS
BEGIN
SET NOCOUNT ON ;
DECLARE...
March 2, 2011 at 3:59 pm
Again? The answer is no 😎
http://www.sqlservercentral.com/Forums/Topic1072170-148-1.aspx#bm1072206
March 2, 2011 at 3:21 pm
Erland has been around the SQL block a few times and he makes some pretty good points as to why not to use INSERT-EXEC as a general development technique:
March 2, 2011 at 3:18 pm
Assuming I correctly understand this, the error msg is saying I can't use a Stored procedure to call another Stored Procedure.
No, that is not what it is telling...
March 2, 2011 at 3:12 pm
You may not want to remove all of them, please see this post: http://www.sqlservercentral.com/Forums/FindPost541758.aspx
March 2, 2011 at 2:28 pm
You have a nice file with escaped text delimiters but SSIS still does not care 🙂 This in my opinion is a *glaring* deficiency in SSIS and one that I...
March 2, 2011 at 2:17 pm
Sure, get out of SSMS and go to a cmd prompt on your local machine...then run the BCP command your T-SQL outputs directly:
bcp "SELECT APPLICATION_NAME FROM PARTI.dbo.applications FOR XML...
March 2, 2011 at 2:11 pm
This looks like homework 😉
I'll give you a hint though, refer to the error message and then look at the definition for your table named @vool, it's PRIMARY KEY and...
March 2, 2011 at 2:07 pm
Do you have an XSD for your XML?
If not you can derive one using SSMS. Open your XML document in SSMS and from the XML menu (only shows when in...
March 2, 2011 at 1:56 pm
Can you please provide the DML to populate your tables with the data you're using in your examples?
March 2, 2011 at 1:50 pm
I hope I am missing something and someone shows me the way on this one, it is why I jumped onto this thread, but from all my reading and experience...
March 2, 2011 at 1:45 pm
I don't have a concrete solution for you but I do have some random thoughts on the matter. If it sparks additional conversation or evokes a solution from another, then...
March 2, 2011 at 11:43 am
This may help you get started:
http://www.sqlservercentral.com/scripts/foreign+keys/69110/%5B/url%5D
March 2, 2011 at 10:09 am
...and will be created under some different user.
The requirement that schemas be strictly linked to database users of the same name last existed in SQL 2000. Some folks still use...
March 2, 2011 at 9:45 am
Viewing 15 posts - 7,051 through 7,065 (of 7,168 total)