Jeff Moden

Forum Replies Created

Viewing 15 posts - 46,651 through 46,665 (of 59,095 total)

RE: script to get all tables an sizes

neneco56 (12/12/2008)
I cannot use cursor or loop or create table, I need a simple script to do the job,any ideas?
Trade ya... tell me why you cannot use a cursor or...
--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 12, 2008 at 11:23 am

#911828
RE: Wacko SMTP email with ActiveX

Bugger... now all I have to do is figure out why the ActiveX script on both servers work but the equivalent sp_OA based sproc doesn't work on one of 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)

December 12, 2008 at 7:41 am

#911645
RE: Urgent: Need help with Query on Group By Part

Well, right you are! So, instead of talking and talking and talking, show Shubhra how to do that with the original code posted instead of just making casual suggestions....
--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 12, 2008 at 12:19 am

#911482
RE: Which is better

Heh... dammit... I hate tabs. 😛 Thanks, Christopher.
--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 12, 2008 at 12:04 am

#911478
RE: Selecting numbers up to the first non-numeric char from a string

engintoksoz (12/11/2008)
... and learned how to use patindex.
As a sidebar, what's the first thing you do when you buy a new car? You find out how to operate...
--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, 2008 at 11:59 pm

#911477
RE: Generating automatic sequential alphanumeric key

vbugarsk (12/11/2008)
Thanks guys for answers.
I am fully aware of possible problems:
1. Overruns will never happen, meaning that client will never have more then 200 orders per year. If it will...
--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, 2008 at 11:59 pm

#911476
RE: CLR vs Dynamic SQL?

The scope of a temporary stored proc is a bit different than that of a temp table... if you create a temp stored proc using dynamic SQL, it IS callable...
--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, 2008 at 11:43 pm

#911472
RE: CLR vs Dynamic SQL?

Heh... no, no... I wasn't trying to be sarcastic or smug in any way. From BOL...
[font="Arial Black"]Arguments[/font]
procedure_name
Is the name of the new stored procedure. Procedure names must conform 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)

December 11, 2008 at 11:27 pm

#911470
RE: Selecting numbers up to the first non-numeric char from a string

Ok... here it is... first, we need to make a UDF from Matt's code to drive a point home later...
CREATE FUNCTION dbo.MillerCode
(
@STR...
--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, 2008 at 10:25 pm

#911458
RE: Selecting numbers up to the first non-numeric char from a string

engintoksoz (12/11/2008)
I loved the Matt's solution too and learned how to use patindex. But I dont agree about your reasoning. patindex itself is a function and I can not imagine...
--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, 2008 at 9:39 pm

#911446
RE: Stored Procedure to generate work day prior?

Ron,
I'm not sure what to tell you... I saved the file attached to the post above from SMS and renamed it .txt. That's all I did to it 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)

December 11, 2008 at 9:10 pm

#911440
RE: Stored Procedure to generate work day prior?

Just testing... please ignore this post....
--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, 2008 at 9:07 pm

#911438
RE: Need to copy data from table to table with update statement

Garadin (12/11/2008)
You know, I never really stopped to think about it, but you're right, it doesn't even make commenting out easier. I do think it makes it a little...
--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, 2008 at 9:00 pm

#911436
RE: Need to copy data from table to table with update statement

Chris Morris (12/11/2008)
Jeff Moden (12/11/2008)
Heh... I think it's a bit odd that anyone would write code to make commenting it out easy when they refuse to comment code to make...
--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, 2008 at 8:47 pm

#911432
RE: Concatenate issue with datetime

In all fairness, cursor solutions for such small rowcounts such as working on a list of databases will never become a performance problem unless you just want to consider 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)

December 11, 2008 at 8:32 pm

#911431

Viewing 15 posts - 46,651 through 46,665 (of 59,095 total)