Viewing 15 posts - 481 through 495 (of 1,114 total)
ROW_NUMBER () OVER (PARTITION BY storeid ORDER BY storeid) AS counter -- Code Added
I think sql 2000 doesn't have this feature. OP's question below.
Is there a way...
August 20, 2008 at 4:36 am
Visit the following URL
August 20, 2008 at 3:15 am
some of the ways to handle the errors in sql2000.
1) Print
2) Raiseerror
3) @@error
@@error - Global variable - is used to capture the status of last executed statuement. if it is...
August 19, 2008 at 5:34 am
Well, I'm using Sybase 10 and Embarcadero DBArtisan 8.1.2, maybe Sybase 10 does not support to store all the E-mail addresses??
ok. Why you still using sybase 10 ? Why...
August 19, 2008 at 2:32 am
exec Email_ID_display 'HK08012698'
Result:
HK08012698 edxxxxx@gmail.com/kimxxxx@gmail.com/yunxxxx@hotmail.com
August 18, 2008 at 9:13 am
Pockeyfan,
HK08012700
ed1xxxx@gmail.com/ed2xxxx@gmail.com/ed3xxxx@gmail.com/ed4xxxx@gmail.com/ed5xxxx@gmail.com/ed6xxxx@gmail.com/ed7xxxx@gmail.com/ed8xxxx@gmail.com/ed9xxxx@gmail.com
I got the above output.
August 18, 2008 at 9:11 am
Can you post the code which you run on your system ?
August 18, 2008 at 7:34 am
August 18, 2008 at 6:55 am
An alternate way, It may fit your requirement.
create table Email_ID
(
CustomerID varchar(30),
Address varchar(50)
)
insert into Email_ID
SELECT 'HK08012698','edxxxxx@gmail.com' UNION ALL
SELECT 'HK08012698','kimxxxx@gmail.com' UNION ALL
SELECT 'HK08012698','yunxxxx@hotmail.com' UNION ALL
SELECT 'HK08012699','sallyxx@gmail.com' UNION ALL
...
August 18, 2008 at 6:31 am
Yes... the OP gave us a table with numbers in it and is required to use just that table. That's why it's not the solution here.
oh...yeah ! I...
August 18, 2008 at 5:35 am
Jeff,
That's a ticking time bomb in the face of scalability. It's known as a "Triangular Join" and you need to read about how bad they are...
How to find...
August 18, 2008 at 5:15 am
Thank you. That worked.
Good. Which method you have used to accomplish your task ?
August 18, 2008 at 5:06 am
Lian Pretorius (8/12/2008)
--------------------------------------------------------------------------------
karthikeyan (8/12/2008)
--------------------------------------------------------------------------------
Hey Trevor,
I have tested the below script, It is giving perfect result.
Same here.
Trevor, Karthik's script above uses a temp table - Which cannot be used in view's...
August 18, 2008 at 5:04 am
Viewing 15 posts - 481 through 495 (of 1,114 total)