Jeff Moden

Forum Replies Created

Viewing 15 posts - 34,306 through 34,320 (of 59,099 total)

RE: full-text indexing with partical word

Sorry. I only looked at the query and not the question. My mistake.
--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)

April 11, 2011 at 5:08 am

#1309743
RE: Query Similar Date from 5 Diffrent Tables

martin.edward (4/4/2011)
Dear Experts,
I have 3 different tables that I would like to query data from and put it in the following format
ConsignmentValue ...
--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)

April 11, 2011 at 1:33 am

#1309684
RE: Help required with combining rows

Gosh, folks... we don't need a Cursor for this and we certainly don't need a While loop.
Using the given data, the following works a treat and can easily be changed...
--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)

April 11, 2011 at 1:24 am

#1309682
RE: Script Database relations

a.ghasemi (4/10/2011)
is there any system or catalog view which I can use?
Yes. It's in Books Online.
--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)

April 11, 2011 at 1:11 am

#1309679
RE: SQL Injection Everywhere

Anders Hansen (4/10/2011)
I think there are many good reasons for connecting things to the internet, and to let them be computer controlled.
Not to ruin your wind shield story -...
--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)

April 11, 2011 at 1:08 am

#1309678
RE: Weird error when selecting from view.

UMG Developer (3/5/2011)
I'll start this off by saying that this has worked for months, and just started failing with no changes on either the Oracle (11g) or SQL Server (2008...
--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)

April 11, 2011 at 12:39 am

#1309676
RE: SQL Injection Everywhere

I think people have really gotten silly with computers. I mean, c'mon! Why would anyone connect a bloody washing machine to the internet?
More silly stuff... I heard 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)

April 10, 2011 at 11:03 pm

#1309654
RE: full-text indexing with partical word

lleemon13 (4/10/2011)
My table is 'product' and the field searching is 'product_name'.
if my product_name values are:
articles
sunny valley
monster truck
wii sports
black eight ball
what's the equivalent to:
select * from product where (product_name like '%nste%')...
--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)

April 10, 2011 at 10:53 pm

#1309651
RE: Need to pivot the table.

Read the following...
http://www.sqlservercentral.com/articles/T-SQL/63681/
--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)

April 10, 2011 at 10:49 pm

#1309650
RE: Generic User Defined Function to return comma delimited string

sharonrao123 (4/10/2011)
But you have suggested creating a generic function is not a good approach why is that?
Thanks, Shilpa.
First, how would you make it generic without using dynamic SQL which cannot...
--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)

April 10, 2011 at 10:44 pm

#1309648
RE: Normals not my friend anymore....

medwar19 (4/10/2011)
Sorry if this is a newbe question. I'm trying...
I got given 10GB of data in flat files which I imported into SQL and normalized.
Everything works fine but I'm now...
--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)

April 10, 2011 at 7:53 pm

#1309637
RE: Generic User Defined Function to return comma delimited string

sharonrao123 (4/10/2011)
Hello Forum,
How are you guys doing?
I am hoping I get some inputs into how to create a generic user defined scalar function which will take in a column 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)

April 10, 2011 at 7:47 pm

#1309634
RE: Are the posted questions getting worse?

bitbucket-25253 (4/10/2011)
Jeff Moden (4/10/2011)
bitbucket-25253 (4/10/2011)
Jeff Moden (4/9/2011)
Shifting gears real hard, I'm finally done not only testing a fix to the Tally Table delimited string splitter performance problem, but I've also...
--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)

April 10, 2011 at 7:36 pm

#1309633
RE: Are the posted questions getting worse?

bitbucket-25253 (4/10/2011)
Jeff Moden (4/9/2011)
Shifting gears real hard, I'm finally done not only testing a fix to the Tally Table delimited string splitter performance problem, but I've also finished the article...
--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)

April 10, 2011 at 4:00 pm

#1309624
RE: Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)

They in the incorrect order only on the source table. That's why he copies the rows to another table where he can apply a different clustered index.
Still, you just...
--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)

April 10, 2011 at 11:51 am

#1309616

Viewing 15 posts - 34,306 through 34,320 (of 59,099 total)