This seems to pin my CPU at 100% for about two minutes. I can replicate this every time I expand a path in the report and then go to expand...

This seems to pin my CPU at 100% for about two minutes. I can replicate this every time I expand a path and then go to expand the modified date....

After looking at my vendors procedure I saw that they were checking if the NT user existed in their system. After adding my SQL Server Agent account as a user...

I also get the same error in a job when I past the code directly into a test job step and set the jobs step to my vendors database.

I have eliminated xp_cmdshell and file output but the error remains.

Let's call my two databases vendor and work. I want to call my vendors proc but not create objects in...

Thank you for responding to my narrative.

Yes I am using xp_cmdshell. I get the same error when I add the SQL Server service account to the sysadmin, that was...

Sean is correct....

--Create your type

CREATE TYPE TCType AS TABLE

(

TranCode varchar(20)

)

--Create some sample data

CREATE TABLE Test (TranCode varchar(20))

INSERT INTO Test (TranCode) VALUES ('BUY')

INSERT INTO Test (TranCode) VALUES ('SELL')

INSERT INTO Test...

There are two approaches to this problem that I am aware of.

You procedure is passed one string parameter like 'BUY','SELL','CONTRIBUTION' and then the string is split within the procedure into...

Brian,

You may want to consider removing the spaces from you field names. TicketNumber rather than Ticket Number. Spaces are allowed but you would have to bracket you fields when referring...

Alternate way below. If you can confirm that we have clarified the problem and that the solution works maybe one of the more experienced posters can speak to best practices...

Below is the simplest way.

There are alternative ways where you don't have to repeat the SELECT statement. I would go tend to use the simpler way unless the...

That clarified matters. Standby...

Is the purpose of the @TC parameter to:

1) Control the number of records returned, or

2) Control the appearance of the data returned (the number of records returned will always be...

What are the possible values for field transcode?

1) Buy or sell; or

2) Buy, Sell or All

Is 'All' actually a transcode or does all indicate that you want both buys and...

I would export to to csv as an intermediary format. I agree it should work and you could probably make it work but if its a one time process I...