Jeff Moden

Forum Replies Created

Viewing 15 posts - 27,046 through 27,060 (of 59,101 total)

RE: cmdexec step running and not doing anything

dkhattar (10/7/2008)
Finally narrowed down the issue. The cause is PGP encryption. When the BAT file which encrypts or decrypts data fails. It corrupts Agents Command Shell.
How to prevent it...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 12, 2013 at 7:54 am

#1605970
RE: Add prefix to all table name

monilps (4/12/2013)
Sorry, I was not clear enough. I need to update table name.
From TableA, TableB to aaa_TableA, aaa_TableB.
Thanks.
You do realize that this will break every piece of code you have,...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 12, 2013 at 7:36 am

#1605956
RE: The Command Shell

Jim P. (4/11/2013)
More than once we ran into an IT staff that said "We can't give you the SA password." We had a choice, go around you and change the...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 11, 2013 at 11:02 pm

#1605853
RE: The Command Shell

Well said on all counts, Orlando. I did try to end our conversation a couple of posts back. Time for us to move on.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 11, 2013 at 9:09 pm

#1605832
RE: Using T-SQL to Create Cross-Tab Data for a CRM Report

I'd have probably put the details in a separate table so I could just truncate the table for reuse if I needed to.
The rest took a bit of time to...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 11, 2013 at 8:02 pm

#1605820
RE: Create DML trigger for single table in SQL 2008 and send email alert to group

I guess I'd just put and INSTEAD OF trigger on the table that returned the error "Table is Read Only" and which group of people to contact for modifications and...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 11, 2013 at 5:05 pm

#1605813
RE: Are the posted questions getting worse?

Lynn Pettis (4/11/2013)
Steve Jones - SSC Editor (4/11/2013)
Lynn Pettis (4/11/2013)
Jan Van der Eecken (4/11/2013)
Lynn Pettis (4/11/2013)
This really makes one want to help, doesn't it.
Dunno, but it really looks like he...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 11, 2013 at 4:59 pm

#1605812
RE: The Command Shell

opc.three (4/8/2013)
If nuclear blasts were the only reason to leave xp_cmdshell disabled then you would have a great point. Unfortunately, that is simply too narrow a view.
The circle continues so...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 11, 2013 at 4:47 pm

#1605808
RE: Using T-SQL to Create Cross-Tab Data for a CRM Report

Mansfield (4/10/2013)
What will consume the results of the query? Just about any reporting front-end will have the facility to pivot the results to the format you want. This...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 11, 2013 at 6:58 am

#1605554
RE: Using T-SQL to Create Cross-Tab Data for a CRM Report

Truth be known, you've already done the hard part in the form of rows 21 through 42. I'm on my way to work so can't respond with code just...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 11, 2013 at 6:56 am

#1605552
RE: access denied message while executing xp_cmdshell

sandy-833685 (4/10/2013)
Hi,
I am trying to execute below simple copy statement using xp_cmdshell
EXECUTE xp_cmdshell 'copy C:\test\*.txt C:\"Program Files\"'
it gives an error as 'Access is denied'
even I get same error while creating...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 10, 2013 at 8:50 am

#1605269
RE: timeline in cross-tab??

Looking through the solutions, I'd have come up with pretty much the same thing as what Luis did. He also came up with it at about the same time...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 10, 2013 at 6:11 am

#1605181
RE: timeline in cross-tab??

r_slot (4/9/2013)
To all repliers,
Due to the time difference I just saw your proposals: I must say they look great! I am going to examine them and I hope to give...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 10, 2013 at 5:56 am

#1605173
RE: A Simple Formula to Calculate the ISO Week Number

Alan.B (4/9/2013)
Wow.
Amazing work Jeff. Great article too. 5 stars.
Thanks, Alan. I really appreciate that.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 9, 2013 at 10:34 pm

#1605086
RE: Exclude weekends from DateDiff

Erin's code is pretty much the way that I'd do it. For an explanation of how it works, please see the following (my very first) article.
http://www.sqlservercentral.com/articles/Advanced+Querying/calculatingworkdays/1660/
Erin used the numerical...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 9, 2013 at 10:36 am

#1604938

Viewing 15 posts - 27,046 through 27,060 (of 59,101 total)