Jeff Moden

Forum Replies Created

Viewing 15 posts - 54,076 through 54,090 (of 59,098 total)

RE: Formula in SQL query

If income and expense are integers, it won't work unless you force a conversion as in the following...
select income, expense, ((income-expense)/income)*100.0 as percentageexpense from sales
--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 19, 2007 at 12:02 pm

#752426
RE: How do I create a report with a checkbox/combobox/ etc

Mr. Impatient has triple cross-posted...
http://www.sqlservercentral.com/Forums/Topic423754-147-1.aspx
http://www.sqlservercentral.com/Forums/Topic423766-150-1.aspx
http://www.sqlservercentral.com/Forums/Topic423758-1063-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)

November 19, 2007 at 11:59 am

#752425
RE: How do I create a report with a checkbox/combobox/ etc

Mr. Impatient has triple cross-posted...
http://www.sqlservercentral.com/Forums/Topic423754-147-1.aspx
http://www.sqlservercentral.com/Forums/Topic423766-150-1.aspx
http://www.sqlservercentral.com/Forums/Topic423758-1063-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)

November 19, 2007 at 11:50 am

#752423
RE: How do I create a report with a checkbox/combobox/button etc

Mr. Impatient has triple cross-posted...
http://www.sqlservercentral.com/Forums/Topic423754-147-1.aspx
http://www.sqlservercentral.com/Forums/Topic423766-150-1.aspx
http://www.sqlservercentral.com/Forums/Topic423758-1063-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)

November 19, 2007 at 11:50 am

#752422
RE: Rearrange Identity values

Maybe that works in 2k5... just not in 2k... yeup, I know... it's a 2k5 forum...
Server: Msg 8102, Level 16, State 1, Line 4
Cannot update identity column 'ID'.
--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 19, 2007 at 6:02 am

#752227
RE: Cartesian product!

That certainly looks like an inner join... but, it's not... behind the scenes, you end up with the same thing as a cross-join because of the criteria you've specified.
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)

November 19, 2007 at 5:47 am

#752224
RE: Problems with GetUTCDate

Yes, there is a work around...
Create a view that looks like this...
CREATE VIEW dbo.vGetUTC AS
SELECT GetUTCDate() AS UTCDate
Then "call" the view from the function instead of calling GetUTCDate().
--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 19, 2007 at 5:38 am

#752221
RE: Urgent! - How to extract number from a string

Hi,
You can try the following query :
select case isnumeric(YourFieldName) when 1 then YourFieldName else 0 end.
Avaneesh,
Try this and see why you shouldn't use ISNUMERIC as an "IsAllDigits" function...
SELECT ISNUMERIC('1e3')
...
--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 19, 2007 at 5:33 am

#752216
RE: Running Number Generation

Matjaz Justin (11/19/2007)
Maybe something like this:
select (select count(*) from sysobjects c where c.id < a.id) + 1
from sysobjects a
order by id
lp, Matjaz
Ummm... be careful... that's a classic "Triangular Join" 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)

November 19, 2007 at 5:21 am

#752209
RE: **************DD/MM/YY to MM/DD/YY************

Converting a VARCHAR date to a VARCHAR date get's you nothing... you must first convert to DATETIME.
Also, storing dates as VARCHAR in a table to start with is a form...
--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 18, 2007 at 6:25 pm

#752125
RE: Best Guideline or Strategy when dealing with records

I guess my real question is can SQL Server handle 336,000 transactions as my dataset for the year (that is after proper indexing ...)?
Heh... I've got 'little" IVR systems...
--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 18, 2007 at 9:21 am

#752102
RE: Need help resolving blocking problems

Heh... Understood, WebRunner. Ran into similar problems in our production environment except a bit worse... our blocking resulted in an average of 640 deadlocks PER DAY with occasional spikes...
--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 18, 2007 at 8:59 am

#752101
RE: Identifying the html tags contained data in database table

finally - if you want to search on a broad spectrum of tags - download the DBA toolkit from this web site, and use the Reg. Exp. tools to build...
--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 18, 2007 at 8:34 am

#752100
RE: SQL DATABASE TO PIVOT TABLE

yes it exceeds the no of cells
Heh... not quite the answer we were looking for... but it'll do.
Two ways to do this... create a view with the pivot 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)

November 18, 2007 at 8:26 am

#752099
RE: Writing Faster T-SQL

Not sure why I came back to this article, but I have to take back some of what I said about the code that Kathi found in Itzik Ben-Gan's book...
WITH
L0...
--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 17, 2007 at 6:33 pm

#752086

Viewing 15 posts - 54,076 through 54,090 (of 59,098 total)