Viewing 15 posts - 2,641 through 2,655 (of 7,631 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...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
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)
...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
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. ...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
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...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
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...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
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"...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 6, 2009 at 3:02 pm
Thanks for the feedback.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 6, 2009 at 2:30 pm
OK, then replace this:
...
FROM CRM_StatusCodes INNER JOIN
...
with this:
...
FROM (
Select *
, (Select count(distinct transaction_ID)
From CRM_StatusCodes...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
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...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 6, 2009 at 2:18 pm
There should be one or more records before that too?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
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,...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
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...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
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...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
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...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
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(
...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 6, 2009 at 1:23 pm
Viewing 15 posts - 2,641 through 2,655 (of 7,631 total)