Viewing 15 posts - 1,606 through 1,620 (of 2,171 total)
June 5, 2007 at 4:53 am
Here is a set-based method that will work on both SQL 2000 and SQL 2005.
-- Prepare sample data
DECLARE
@Sample TABLE N 56°04'39.16"
E 12°55'05.25"
June 4, 2007 at 9:14 am
I WANT MORE!
This thread is hilarious.
Can't we discuss negative numbers and rounding now?
N 56°04'39.16"
E 12°55'05.25"
June 4, 2007 at 7:09 am
-- Prepare sample data
SET
DATEFORMAT DMY
DECLARE
@Sample TABLE (ID INT N 56°04'39.16"
E 12°55'05.25"
June 4, 2007 at 5:22 am
I think it is a trick question from an interview.
N 56°04'39.16"
E 12°55'05.25"
June 4, 2007 at 4:56 am
Here is a solution that only takes about 12 seconds to do the calculation and present the data...
-- Create sample data
SELECT
TOP...
N 56°04'39.16"
E 12°55'05.25"
June 4, 2007 at 3:09 am
-- Prepare sample data
DECLARE @ TABLE (EmployeeID INT, Freight SMALLMONEY)
N 56°04'39.16"
E 12°55'05.25"
May 31, 2007 at 2:32 am
Add an extra line
ORDER BY s.ID
N 56°04'39.16"
E 12°55'05.25"
May 31, 2007 at 2:22 am
More here
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=79902&whichpage=1
N 56°04'39.16"
E 12°55'05.25"
May 28, 2007 at 5:51 am
declare @ int set @=1while @<101begin print ISNULL(NULLIF(CASE WHEN @%3=0THEN'Fizz'ELSE''END+CASE WHEN @%5=0THEN'Buzz'ELSE''END,''),@)set @=@+1 end
N 56°04'39.16"
E 12°55'05.25"
May 28, 2007 at 5:48 am
UPDATE Table1
SET Col1 = REPLACE(Col1, ',', ' ')
N 56°04'39.16"
E 12°55'05.25"
May 8, 2007 at 5:46 am
select
item_code,
qty_onhand
,
date_rcvd
from
(
select vw.item_code,
vw
N 56°04'39.16"
E 12°55'05.25"
May 1, 2007 at 4:06 pm
If this is a SQL Server 2000 problem, why do you post in a SQL Server 2005 forum?
DECLARE @Stage TABLE (RecID INT IDENTITY, ID INT)
INSERT @Stage (ID)
SELECT Col1 FROM Table1...
N 56°04'39.16"
E 12°55'05.25"
May 1, 2007 at 2:43 pm
SELECT Col1, 10000 * Col1 + ROW_NUMBER() OVER (ORDER BY Col1 DESC) AS Col2
ORDER BY Col1 DESC
N 56°04'39.16"
E 12°55'05.25"
May 1, 2007 at 12:55 am
Viewing 15 posts - 1,606 through 1,620 (of 2,171 total)