Viewing 15 posts - 2,641 through 2,655 (of 7,636 total)
If you have not written them to be location/target agnostic driving off the configuration files (and you probably would not be asking if you had), then for the most part...
May 6, 2009 at 8:03 pm
OK, I think that this should work:
SELECT
CRM_StatusCodes.TRANSACTION_ID
,CRM_StatusCodes.CREATED_AT
,CRM_StatusCodes.USER_STATUS
, CRM_Serials.SERIAL
, CRM_Serials.TotalCount
,CRM_PartsLabor.DESCRIPTION
,CRM_Orders.PRIORITY_DESCRIPTION
,CRM_Orders.PRIORITY
/*,CRM_StatusCodes.START_DATE*/
/*,CRM_StatusCodes.END_DATE*/
,CRM_CodeTexts.ABCDE_CODE_DESC
,CRM_Partners.DESCRIPTION AS [Function]
,CRM_Partners.ADDRESS
FROM
CRM_StatusCodes INNER JOIN
( Select *
, (Select count(distinct transaction_ID)
...
May 6, 2009 at 7:56 pm
I thought that I already explained this. You don't get any SQL Errors because you don't have any SQL errors, you have errors in your BCP command line. ...
May 6, 2009 at 7:43 pm
Igor Makedon (5/6/2009)
You are talking about access to a database - one of a hundred that a human user views in her Management Studio Object Explorer pane.
While I am talking...
May 6, 2009 at 7:36 pm
Sorry, I mistakenly assumed that SERIAL was part of the CRM_StatusCodes. I'll have to give it another look...
May 6, 2009 at 3:08 pm
ifila (5/6/2009)
...27"MASTER.DBO.xp_cmdshell 'bcp ""Bank.dbo.Account""
in ""c:\Myimport\b.txt"" -SSQL -T -c -r -t,'"31:21.2
...
Yeah, there's too many quotes in these, I think. This should look more like this:
...
27"MASTER.DBO.xp_cmdshell 'bcp "Bank.dbo.Account"
in "c:\Myimport\b.txt"...
May 6, 2009 at 3:02 pm
OK, then replace this:
...
FROM CRM_StatusCodes INNER JOIN
...
with this:
...
FROM (
Select *
, (Select count(distinct transaction_ID)
From CRM_StatusCodes...
May 6, 2009 at 2:26 pm
OK, I just realized that that is the BCP Help output, which you get when you run BCP but there is some syntax error with the command line. We...
May 6, 2009 at 2:18 pm
There should be one or more records before that too?
May 6, 2009 at 2:13 pm
Grant Fritchey (5/6/2009)
Lynn Pettis (5/6/2009)
sorry, crushed you will be.
I don't know. I met Barry at the PASS Summit last year. He sounded a bit like Darth... an avuncular friendly Darth,...
May 6, 2009 at 2:06 pm
Bob Hovious (5/6/2009)
They might give him bad advice though.
He might even take it.
BTW, if...
May 6, 2009 at 1:58 pm
OK, I guess by Container, maybe you mean a VM? No matter.
SQL Server Developer's Edition costs less than $65. A 1 Terabyte USB drive can be had for...
May 6, 2009 at 1:38 pm
cvoronin (5/6/2009)
But I did test the file in excel before. It's an old backup.
Instead of coma separated numbers its supposed to show usernames, log action names, etc... (words...
May 6, 2009 at 1:28 pm
It's returning those errors because your subquery does not include all of those columns. You might try something like the following instead:
...
FROM CRM_StatusCodes INNER JOIN
...
WHERE CRM_StatusCodes.transaction_ID IN(
...
May 6, 2009 at 1:23 pm
Viewing 15 posts - 2,641 through 2,655 (of 7,636 total)