Jeff Moden

Forum Replies Created

Viewing 15 posts - 54,256 through 54,270 (of 59,072 total)

RE: Case expression problem

Nili S (11/7/2007)
.... And it worked!! For both Oracle and SQL Server.
Thanks!
GETDATE() worked in Oracle? I don't think so...
--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)

November 7, 2007 at 7:10 pm

#749318
RE: is there any difference between != and <>

I agree with Mayank... just to add to that, the != will actually appear in execution plans as <>. Sounds strange, but I can always tell who wrote 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)

November 7, 2007 at 6:18 pm

#749292
RE: Executing VBA From T-SQL

Why not just make it an auto-exec macro that get's executed when the spreadsheet is opened?
--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)

November 7, 2007 at 6:09 pm

#749286
RE: Tale of <> Operator

But we are using 'OR' which could generate cartesian product.
Ok, Karth... your turn to explain something... How could the use of 'OR' cause a Cartesian product?
--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)

November 7, 2007 at 6:05 pm

#749285
RE: Tale of <> Operator

Absolutely nothing... NOT IN is evaluated to <> for single values and some exclusionary AND's using both for multi-values.
--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)

November 7, 2007 at 6:03 pm

#749284
RE: Finding a substring within a text

Matt Miller (11/7/2007)
...or... (come on Jeff, you KNOW what I am about to say)....
Regular expression CLR functions would do that as well.... But you still need a search string...
--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)

November 7, 2007 at 4:31 pm

#749269
RE: Add 3 columns into another column

brendt hess (11/7/2007)
This is one of those cases where COALESCE makes for a fun alternative, because it can make your head hurt figuring out what it is doing. 😉 ...
--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)

November 7, 2007 at 4:19 pm

#749265
RE: Add 3 columns into another column

karthikeyan (11/5/2007)
Just Update the Null columns as blank values
Update yourtablename
set add1 = ''
where add1 is null
Now execute your code, it should work
do You know why are you getting 'NULL' Values...
--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)

November 7, 2007 at 4:16 pm

#749264
RE: Need input on how to combine queries that return counts

I sure as heck can not figure out how to do that. When I try to copy code into QA when someone used the blocks like I did, it...
--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)

November 7, 2007 at 4:14 pm

#749263
RE: Need input on how to combine queries that return counts

brendt hess (11/7/2007)
Must remember to post my code in a quoted block, so that formatting is retained.
Problem is, if you copy from the code block to query analyzer, it really...
--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)

November 7, 2007 at 4:13 pm

#749262
RE: Finding a substring within a text

I believe that PATINDEX is the only function that will do as you ask on TEXT datatypes.
--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)

November 7, 2007 at 8:09 am

#749112
RE: difference between *= and Left outer join

Heh... and the Oracle notation is backwards from the T-SQL notation... in Oracle (+)= means "Right Outer Join"... in SQL Server, *= means "Left Outer Join". If you believe...
--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)

November 7, 2007 at 7:57 am

#749107
RE: distinct keyword

My Questions :
1. Whether the numbers used in this query are constant or not ?
2. Can you explain me the logic of this number ?
3. Can i use any numbers(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)

November 7, 2007 at 7:42 am

#749102
RE: difference between *= and Left outer join

karthikeyan (11/7/2007)
I am using sql2000. Both gave me the same output.
Yes... for simple queries they will work the same... for not so simple queries with many criteria, *= will surprise...
--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)

November 7, 2007 at 6:32 am

#749071
RE: Inserting random order of numbers between defined range

The answer is, no... Within a given SELECT, Rand is not RAND unless it has a random seed... the only thing in SQL Server that even comes close to being...
--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)

November 7, 2007 at 6:25 am

#749067

Viewing 15 posts - 54,256 through 54,270 (of 59,072 total)