insertAlias,
thanks to you, figured it out now.
e7.
east7
Last Activity: Mar 2 '10, 09:44 AM
Joined: Jul 4 '09
Location:
-
OOP newbie
Hi All,
I'm using C# 2.0. I want to produce code like this:
Code:int cnt = Products("Car").Color("Red").Count();
to get total cars that has color red.
How do i design my classes.
I know i can do it using ADO.NET classes, but i want to know how to do it purely in object oriented style.
Many thanks.
e7 -
hi,
try this
--
USE tempdb
GO
IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'testSP' AND type = 'P')
DROP PROCEDURE testSP
GO
CREATE PROCEDURE testSP
(
@ids varchar(20)
)
AS
BEGIN
DECLARE @prc nvarchar(300)
SET @prc = 'SELECT * FROM Delta d WHERE d.ID...Leave a comment:
-
ck, thanks. Cant find pivot in sql 2000.
However you lead me to this:
SELECT c.ID,
MAX(
CASE
WHEN c.Time <= '07:15' THEN c.Time
END)
AS T1,
MAX(
CASE
WHEN c.Time > '07:15' AND c.Time <= '12:15' THEN c.Time
END)
AS T2,
MAX(
CASE
WHEN c.Time > '12:15' AND c.Times <= '13:15'...Leave a comment:
-
Transpose into fixed column
Hi all,
I am using SQL 2000, and I have following table with 2 columns, ID and TIME
ID | TIME
A | 07:01
A | 12:05
A | 13:01
A | 15:09
B | 15:07
C | 06:52
C | 12:47
C | 17:03
D | 07:00
D | 18:12
D | 18:57
D | 21:04
Now i want to transpose them into another existing table with 7 fixed columns: ID, T1..T6
... -
Transpose into fixed column
Hi all,
I have following table with 2 columns
ID | TIME
=========
A 07:01
A 12:05
A 12:59
A 15:09
B 15:07
C 06:52
C 12:47
C 17:03
D 07:00
D 18:12
D 18:57
D 21:04
Now i want to transpose them into this table with 7 columns
ID T1 T2 T3 T4 T5 T6
=============== =============== ==============...
No activity results to display
Leave a comment: