Jeff Moden

Forum Replies Created

Viewing 15 posts - 53,641 through 53,655 (of 59,089 total)

RE: store proc

Mike Levan (12/11/2007)
sorry its deleted
That's just not nice... now we have an answer with no question.
--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)

December 11, 2007 at 2:18 pm

#759183
RE: passing csv list into stored procedure

I guess my question would be... why does anyone pass more than 8000 bytes of parameters to a stored procedure... what is the purpose?
--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)

December 11, 2007 at 2:17 pm

#759182
RE: How to check if a Stored Procedure is running?

If it's that critical, create a "token table" where you set a row to identify if the job is already running. Check for that token at the beginning of...
--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)

December 11, 2007 at 2:11 pm

#759180
RE: Printing ASCII Values

karthikeyan (12/10/2007)
Jeff,
No..This is a different one.Yes i want to print ascii values of A-Z.
Can i use the same logic where you replied for my previous question ?
No, it's not different......
--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)

December 11, 2007 at 7:42 am

#758968
RE: How to avoid While Loop - RBAR ?

Ok... sure...
In order to do what you wanted, you wrote a loop to have a variable (@InitialValue) count from 1 to 6 in your first example. Then you...
--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)

December 11, 2007 at 7:35 am

#758956
RE: Update from Column to part of the field

1. What is the best way to show rows of data here? I am sure the way I did it can add to confusion if a lot of columns of...
--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)

December 10, 2007 at 7:23 am

#758585
RE: Further learning in SQL

Heh... Exactly... couldn't have said it better myself!
... and... GO WINGS! WOO-HOO!
--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)

December 10, 2007 at 7:15 am

#758580
RE: How to avoid While Loop - RBAR ?

Karthik...
What about you... you all set?
--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)

December 10, 2007 at 7:06 am

#758576
RE: Hidden RBAR: Triangular Joins

I delete dups like this all the time:
delete d
from table k
join table d on k.matching = d.matching
where d.primarykey < k.primarykey
And I could swear this is set based, but maybe 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)

December 10, 2007 at 7:00 am

#758571
RE: Help configuring Object Browser Scripting Options

Ramesh (12/10/2007)
Apparently, you would be surprising to see some useful features disappeared!!!:D
Heh...you've got that right...
Thanks for the info, Ramesh... add one more chunk... the scripting options you told me about...
--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)

December 10, 2007 at 1:48 am

#758503
RE: need help in case stmt

First, you must make the dates correct... the following code exemplifies the error... run it an see...
DECLARE @AnyDate DATETIME
SET @AnyDate = '12/8/2007'
SELECT @AnyDate + '11:59:59.999...
--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)

December 10, 2007 at 1:40 am

#758501
RE: How to avoid While Loop - RBAR ?

You bet, Sandy... 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)

December 10, 2007 at 1:27 am

#758499
RE: Update from Column to part of the field

If all the SKU's start with a numeric digit and nopne of the paths leading to the file have a digit anywhere in them, then the following demo code gives...
--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)

December 10, 2007 at 1:25 am

#758498
RE: Printing ASCII Values

You are double posting... that'll get you thrown out of the "sandbox"... 😉
http://www.sqlservercentral.com/Forums/Topic431176-8-1.aspx
--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)

December 10, 2007 at 1:10 am

#758495
RE: How to avoid While Loop - RBAR ?

Of course the "code" must change... but the changes I made also make it more flexible...
DECLARE @Str VARCHAR(100)
SET @Str = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ'
SELECT LEFT(@Str,Number)
FROM...
--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)

December 10, 2007 at 12:40 am

#758489

Viewing 15 posts - 53,641 through 53,655 (of 59,089 total)