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
June 4, 2007 at 9:14 am
I WANT MORE!
This thread is hilarious.
Can't we discuss negative numbers and rounding now?
June 4, 2007 at 7:09 am
-- Prepare sample data
SET
DATEFORMAT DMY
DECLARE
@Sample TABLE (ID INT
June 4, 2007 at 5:22 am
I think it is a trick question from an interview.
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...
June 4, 2007 at 3:09 am
-- Prepare sample data
DECLARE @ TABLE (EmployeeID INT, Freight SMALLMONEY)
May 31, 2007 at 2:32 am
Add an extra line
ORDER BY s.ID
May 31, 2007 at 2:22 am
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
May 28, 2007 at 5:48 am
select
item_code,
qty_onhand
,
date_rcvd
from
(
select vw.item_code,
vw
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...
May 1, 2007 at 2:43 pm
SELECT Col1, 10000 * Col1 + ROW_NUMBER() OVER (ORDER BY Col1 DESC) AS Col2
ORDER BY Col1 DESC
May 1, 2007 at 12:55 am
Viewing 15 posts - 1,606 through 1,620 (of 2,171 total)