473,323 Members | 1,574 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,323 software developers and data experts.

Produce output based on values in table

i have a table like as below; as table name temp

Expand|Select|Wrap|Line Numbers
  1. SR    ER    x    Y    z
  2. 1    1    P    Q    R
  3. 2    5    l    M    N
  4. 6    9    S    T    G
  5. 10    10    Y    O    P
  6.  
I am looking a output as below :-

Expand|Select|Wrap|Line Numbers
  1. MRP    x    Y    z
  2. 1    P    Q    R
  3. 2    l    M    N
  4. 3    l    M    N
  5. 4    l    M    N
  6. 5    l    M    N
  7. 6    S    T    G
  8. 7    S    T    G
  9. 8    S    T    G
  10. 9    S    T    G
  11. 10    Y    O    P
Apr 19 '13 #1
2 1372
Rabbit
12,516 Expert Mod 8TB
Join it to a table that contains a sequential number field on your start and end range.
Apr 20 '13 #2
make a new with joins
Apr 26 '13 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Dheeraj Kumar | last post by:
hi all, I am working for code migration of roguewave libraries of c++. when i am upgrading it is giving the following errors..The errors are because of the functions defined both in cstdlib and...
5
by: RAW | last post by:
I'm using ASP.net with vb, Access database and SQL query, I'm trying to count records that match with a particular criteria after making a loop statement and after displaying any records. Does any...
3
by: Eduardo78 | last post by:
I would like to know if there is a way to run a windows application on a client computer without having to run the setup. I was wondering if it could work to have the application on a file server...
4
by: phillip.s.powell | last post by:
UPDATE redesign.student SET student_work_area_other SELECT REPLACE('anywhere,(.*)', '$1', i.work_area) AS regexp_col FROM mycompany.interns i, redesign.student s WHERE i.unique_key = s.unique_key...
35
by: Logos | last post by:
I asked about this a while ago, and got a great answer and a reference to http://www.javascripttoolbox.com/bestpractices/new.php. I just need to override onclick and return false. No biggie! ...
1
by: ajey | last post by:
Hi all I recently downloaded janus gridex for my project... the problem is iam unable to bind data... here is what i do ......
0
by: Geoff Berrow | last post by:
Message-ID: <gcdqc0$c69$2@registered.motzarella.orgfrom Jerry Stuckle contained the following: LOL, I was thinking the same thing. Possibly not the best group in which to ask this question....
4
by: gerryis2000 | last post by:
Hi guys, i have purchases table where purchase items are selected and a daily purchase report generated. i use SQL to select item ID and Date of purchase then sum all the daily purchases. since i...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.