Jeff Moden

Forum Replies Created

Viewing 15 posts - 31,381 through 31,395 (of 59,101 total)

RE: Getting the difference from current row and previous row

hemaljoes (1/16/2012)
Thanks everyone for the replies.
I'm new to programming. Need bit more time to understand what some of you have told. I will try those stuff and reply ASAP.
Thanks.
The first...
--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)

January 17, 2012 at 6:22 pm

#1434939
RE: about the site itself

Grant Fritchey (1/17/2012)
We do have ASK.SQLServerCentral.Com if you really prefer posting to a place with a reputation system.
The thing is, some questions lend themselves to that style of web site....
--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)

January 17, 2012 at 6:19 pm

#1434938
RE: CMDEXEC

helpmewithsql 73993 (1/16/2012)
Sorry - it says:
Unable to start execution of step 1 (reason: Error authenticating proxy DOMAIN\SQL_Proxy_Username, system error: Logon failure: unknown user name or bad password.). The step...
--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)

January 17, 2012 at 6:15 pm

#1434937
RE: Need to grant execute permissions on all sprocs of a specific database to all server logins of a SQL instance without explicitly granting exec permissions on each individual object

GSquared (1/17/2012)
Yep. But that doesn't grant access to a database their account/group hasn't been given access to, except as "guest". So guest has to be enabled.
Ah... sorry. ...
--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)

January 17, 2012 at 6:08 pm

#1434935
RE: Wjat would be a good supplmental skill to SQL server

Let's go all the way back to the beginning on this because I'm actually quite curious about this. What, exactly, is meant by the following snippet from the original...
--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)

January 17, 2012 at 6:02 pm

#1434934
RE: Need to grant execute permissions on all sprocs of a specific database to all server logins of a SQL instance without explicitly granting exec permissions on each individual object

Marios Philippopoulos (1/17/2012)
Even "best practices" should be looked at with a critical eye.
Precisely why I encapsulated "best practices" in quotes. 🙂
--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)

January 17, 2012 at 1:34 pm

#1434844
RE: Need to grant execute permissions on all sprocs of a specific database to all server logins of a SQL instance without explicitly granting exec permissions on each individual object

rlevine (1/17/2012)
No, public did not work without creating a user in the target db first, which is what I am trying to avoid.
Ok... thanks for the feedback.
--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)

January 17, 2012 at 1:33 pm

#1434843
RE: Need to grant execute permissions on all sprocs of a specific database to all server logins of a SQL instance without explicitly granting exec permissions on each individual object

GSquared (1/17/2012)
Jeff Moden (1/16/2012)
rlevine (1/16/2012)
Perfect!!
I was able to install my CLR functions into a db called Library and then use these scripts to enable having all users call the functions...
--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)

January 17, 2012 at 6:35 am

#1434566
RE: Extracting parts of text from a varchar column

Adi Cohn-120898 (1/16/2012)
If you have the same structure, but different length for each value, then you can convert it to XML and then use Xquery to get the data 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)

January 16, 2012 at 10:29 pm

#1434400
RE: CMDEXEC

helpmewithsql 73993 (1/16/2012)
Hi Everyone,
..Firstly, I have to state that I am new to this..
I'm working on sql 2008 r2, trying to set up a proxy account.
This is what I've...
--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)

January 16, 2012 at 10:25 pm

#1434398
RE: Need to grant execute permissions on all sprocs of a specific database to all server logins of a SQL instance without explicitly granting exec permissions on each individual object

rlevine (1/16/2012)
Perfect!!
I was able to install my CLR functions into a db called Library and then use these scripts to enable having all users call the functions without needing 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)

January 16, 2012 at 9:28 pm

#1434390
RE: Are the posted questions getting worse?

I'll reserve my opinion on this but thought I'd give everyone a heads up...
http://wikimediafoundation.org/wiki/English_Wikipedia_anti-SOPA_blackout
--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)

January 16, 2012 at 9:13 pm

#1434389
RE: Wrapper to run stored procedure many times

If the Temp Table has sequential numbering like that offered by an IDENTITY column and you've done nothing to disturb the sequence of numbers, then you could use a counter...
--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)

January 16, 2012 at 8:56 pm

#1434386
RE: Numbers

michael.kaufmann (1/4/2012)
Stuart Davies (1/4/2012)
Know what you mean Tom - but I took the wording straight from BOL (I know, a scarely used resource 🙂 ) to try and avoid any...
--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)

January 16, 2012 at 8:42 pm

#1434384
RE: Numbers

michael.kaufmann (1/5/2012)
Stuart Davies (1/4/2012)
Dave62 (1/4/2012)
Here's another beauty.
Select ISNUMERIC('£,,1.,') As "String";
Still returns a 1 :crazy:
Based on Jeff Moden's SQL Spackle on ISNUMERIC[/url], any of these characters evaluates to 1; so I'd...
--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)

January 16, 2012 at 8:25 pm

#1434382

Viewing 15 posts - 31,381 through 31,395 (of 59,101 total)