Jeff Moden

Forum Replies Created

Viewing 15 posts - 26,626 through 26,640 (of 59,099 total)

RE: Can we call stored Procedure inside a function

Ed Wagner (6/13/2013)
Jeff Moden (6/13/2013)
mahavidhya24 (6/12/2013)
Thats not possible to call store procedure inside the function,we can call function with in the store procedure
Oddly enough, they just proved that it was...
--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)

June 13, 2013 at 10:55 pm

#1623954
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

rayoftennessee (6/13/2013)
I have a quick question, in the original post the final output is row by row. How do you get it into columns using id? Thanks.
Disregard. ...
--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)

June 13, 2013 at 10:21 pm

#1623947
RE: How to prevent ANY use of xp_CmdShell?

I agree with almost everything you said except the last part. I don't consider using SSIS (for example) to be a "more robust" way of doing things. More...
--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)

June 13, 2013 at 7:02 am

#1623693
RE: Can we call stored Procedure inside a function

mahavidhya24 (6/12/2013)
Thats not possible to call store procedure inside the function,we can call function with in the store procedure
Oddly enough, they just proved that it was possible if you use...
--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)

June 13, 2013 at 6:41 am

#1623681
RE: Modifying a system stored procedure

Sean Pearce (6/13/2013)
Sean Pearce (6/13/2013)
masterjd (6/12/2013)
Here is an example of one of them.
That is not a user defined system proc.
http://msdn.microsoft.com/en-us/library/ms403828.aspx
You really should not change system stored procs at all. For...
--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)

June 13, 2013 at 6:36 am

#1623676
RE: How to format the data in column in sql server

Kinston beat me to it but, to add a little more checking, here's what I came up with.
--=============================================================================
-- Create and populate a test table. ...
--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)

June 13, 2013 at 6:32 am

#1623669
RE: Can we call stored Procedure inside a function

Matt Miller (#4) (6/12/2013)
GilaMonster (6/12/2013)
Ed Wagner (6/12/2013)
Just because we can do something doesn't mean we should. The technical workaround does work, but I don't think it's a good idea.
It's...
--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)

June 12, 2013 at 10:00 pm

#1623559
RE: Can we call stored Procedure inside a function

Ed Wagner (6/12/2013)
Personally, I hate using OPENROWSET in production. Any time a username and password has to be hard coded means that you're screwed if you ever 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)

June 12, 2013 at 9:50 pm

#1623557
RE: Modifying a system stored procedure

System stored procedures typically are NOT located in the MSDB database... not even the home grown ones. See if you can find it in the Master database. If...
--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)

June 12, 2013 at 9:38 pm

#1623556
RE: How to format the data in column in sql server

SriSudha (6/12/2013)
Hi,
Please help me,
In my table have a one date column. It contains data in different formats .I want to set all these...
--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)

June 12, 2013 at 9:33 pm

#1623555
RE: Separate one column in many columns

Kingston Dhasian (6/4/2013)
Something like this..
SELECT*,
CASE WHEN SUBSTRING(rate, 1, 1) = '*' THEN '10' ELSE SUBSTRING(rate, 1, 1) END AS game1,
CASE WHEN SUBSTRING(rate, 2, 1) = '*' THEN '10' ELSE SUBSTRING(rate,...
--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)

June 12, 2013 at 9:28 pm

#1623554
RE: Import Dynamic File Name with a Date/Time as the file type (YYYYMMDDHRMMSS)

Ah, crud. As soon as I find a method to prevent usage of cmd.exe, I find someone with easy methods to blow through the prevention. I've updated 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)

June 12, 2013 at 9:03 pm

#1623552
RE: How to prevent ANY use of xp_CmdShell?

Ok, Orlando... I'd really be interested in how that bit of fine code could be modified to reject usage of cmd.exe by a given user because I just saw a...
--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)

June 12, 2013 at 7:50 pm

#1623547
RE: Import Dynamic File Name with a Date/Time as the file type (YYYYMMDDHRMMSS)

Might have finally found a method to prevent execution of Cmd.exe.
http://technet.microsoft.com/en-us/library/cc975912.aspx
I'll have to give this a try.
--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)

June 12, 2013 at 4:36 pm

#1623530
RE: Import Dynamic File Name with a Date/Time as the file type (YYYYMMDDHRMMSS)

opc.three (6/12/2013)
I already did.
http://www.sqlservercentral.com/Forums/FindPost1450182.aspx
I showed how to recognize that a call to the cmd shell was being made within Windows using WMI. Granted, that exercise only detected the occurrence...
--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)

June 12, 2013 at 4:19 pm

#1623528

Viewing 15 posts - 26,626 through 26,640 (of 59,099 total)