Viewing 15 posts - 54,046 through 54,060 (of 59,068 total)
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
November 19, 2007 at 12:02 pm
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
November 19, 2007 at 11:59 am
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
November 19, 2007 at 11:50 am
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
November 19, 2007 at 11:50 am
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'.
November 19, 2007 at 6:02 am
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,...
November 19, 2007 at 5:47 am
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().
November 19, 2007 at 5:38 am
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')
...
November 19, 2007 at 5:33 am
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...
November 19, 2007 at 5:21 am
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...
November 18, 2007 at 6:25 pm
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...
November 18, 2007 at 9:21 am
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...
November 18, 2007 at 8:59 am
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...
November 18, 2007 at 8:34 am
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...
November 18, 2007 at 8:26 am
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...
November 17, 2007 at 6:33 pm
Viewing 15 posts - 54,046 through 54,060 (of 59,068 total)