WEB LIFE
GADGETS
SOFTWARE
STYLE
DOWNLOADS
SHOPPING
TECH SUPPORT

Tom's HardwareTom's IT Pro

Computing.Net

query fo retrieve from partitiontbl

Tags:
pentium
partition
filter
Score
0
Vote Up
October 3, 2006 at 21:33:33 Pacific
Specs: windows xp, p4

i have a table called xyz which is having 5 columns
(client,datmonth,productid,productname,productdesc)
and it is partitioned as

column client is the primary partition
column datamonth is subpartitioned based on client

if i have to select both client and datamonth how to do it by select query

i arrived till
select * from xyz partition <clientid-partition>

but unable to proceed further

any help?



Reply ↓  Report •


#1
Vote Down
Score
0
Vote Up
October 4, 2006 at 04:57:03 Pacific

Something like this will do it.

SELECT tblClient.Client, tblClient.DatMonth, tblClient.ProductID, tblClient.ProductName, tblClient.ProductDesc
FROM tblClient
WHERE (((tblClient.Client) Like [Enter name] & "*") AND ((tblClient.DatMonth) Between [Enter start date] And [Enter end date]));

Note that I have used the like operator and the Between to filter the date required. More flexible than hard coding the criteris.

David


Reply ↓  Report •
Reply to Message Icon Start New Discussion
Related Posts
See More ↓

« Anyone good with Veritas ... homepage hijacked »

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Ask the Community!
Describe your Problem
Example: Hard Drive Not Detected on My PC