Jeff Moden

Forum Replies Created

Viewing 15 posts - 49,381 through 49,395 (of 59,091 total)

RE: How to get the integer value from varchar field?

Dang... thanks for the catch, Ken... I normally list that article and plumb forgot...
--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)

July 7, 2008 at 8:30 am

#838939
RE: How do I throw custom errors from SQLCLR code back to calling T-SQL?

Marios Philippopoulos (7/7/2008)
2) Are you allowed to use sp_OA* procedures?
I don't know much about sp_OA* procedures, but I think they come with their own baggage of problems, and in 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)

July 7, 2008 at 8:25 am

#838931
RE: Debugging CLR function

Ok, thanks for the feedback...
By the way... sorry I forgot to post the simple code example... just in case anyone else is interested...
DECLARE @SomeString VARCHAR(1000)
SET @SomeString...
--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)

July 7, 2008 at 8:05 am

#838910
RE: How do I throw custom errors from SQLCLR code back to calling T-SQL?

Thanks,
Just a couple more questions...
1) Which date are you listing... Create, Modified, or Last Accessed?
2) Are you allowed to use sp_OA* procedures?
3) Do you really need the date 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)

July 7, 2008 at 8:02 am

#838907
RE: Dropping Stored Procedures

David Naples (7/7/2008)
You can't do this directly, as the CREATE PROCEDURE or ALTER PROCEDURE statement has to be the first in the batch.
Ummm... maybe not directly, but you can...
--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)

July 7, 2008 at 7:55 am

#838897
RE: Trigger Not Firing

Thanks for letting us know what the problem was, Jim... I think you're on the right track.
--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)

July 7, 2008 at 7:50 am

#838890
RE: Debugging CLR function

... and, here's a bit of simple code to play with...
If you cannot create a Tally table, please post back... we have other ways to skin the same cat. 🙂
--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)

July 7, 2008 at 7:49 am

#838888
RE: Debugging CLR function

MichaelC (7/7/2008)
the simple function that I was working on would simply parse a comma delimited string and return the requested section. For instance, I would pass a string, 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)

July 7, 2008 at 7:37 am

#838877
RE: Dynamic USE clause

Thanks for the feedback...
I avoid the use of cursors even in Oracle. Setbased methods work better there, too. 🙂
--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)

July 7, 2008 at 7:27 am

#838865
RE: Dropping Stored Procedures

It would probably be better if you started a new thread... when you do, you might want to explain what kind of alteration you want to make to each stored...
--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)

July 7, 2008 at 7:24 am

#838862
RE: eliminating duplicates

vipul.ymca (7/7/2008)
I see 2 possible options but not sure if they are implementable at your end.
1. insert a temp identity column and then you can issue a delete statement. (let...
--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)

July 7, 2008 at 7:21 am

#838858
RE: To Certify or Not To Certify

Yep... I agree with that... I still avoid them on some processes in 2k5 simply by using concatenation to build "monster" commands and execute those instead of a cursor. ...
--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)

July 7, 2008 at 7:19 am

#838855
RE: Time Calculation

I'm sorry to be asking so many questions... I'm just looking for clarification because I believe I have a nasty fast method to do what you want...
--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)

July 7, 2008 at 7:13 am

#838844
RE: Time Calculation

Will you ever end up with totals in excess of 24 hours?
--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)

July 7, 2008 at 7:11 am

#838841
RE: fast file split on CRLF?

emamet (7/7/2008)
Yes, the initial data comes as a file and is manipulated by a C# program. It was my idea to do the first bit in one SQL chunk because
-...
--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)

July 7, 2008 at 6:51 am

#838817

Viewing 15 posts - 49,381 through 49,395 (of 59,091 total)