We were creating our store in access and we used queries. Our store was
housed on yahoo. We are getting away from the yahoo store and going to
another hosting company that supports SQL.
Here is a line from hone of our queries in access and I that they would like
for it to look the same in SQL but now in queries.
id path name abstract code price sale-price cost map-price margin ship-weight availability orderable taxable leaf seat-size1 arm-height back-size capacity depth weight exterior-size interior-size height length width overall-dimensions degree-of-swivel main bridge return sale-price-text seat-depth seat-height seat-thickness seat-width recliner ottoman shipping-info shipping-options color-options dims diameter quantity-per-carton right-column out-of-stock custom-order quickship 60-day-guarantee free-shipping is-top-seller template-number back-height-from-seat credenza hutch custom-options contents optional related-samples UserID caption flat-ship-rate1 Inside-delivery shipping-cost Manufacturer mpn UPC ISBN ASIN-Amazon
Number collection options delivery shipping-price keywords product-type made-in age-range Promo Free-shipping2 department materials gender artist-designer green-certified CA
Product Summary CA Product Short Name CA Promo
Text product-url Vendor Completed Updated
101cpu-mco Maco Maco Side Pount CPU Holder [101CPU-MCO] Maco Side Pount CPU
Holder
[101CPU-MCO] 101CPU-MCO 175.00 89.99 87.50 $0.00 FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE 5 "<li>Under
desk side mount design is
expandable in depth only</li><li>Will fit all
brands of furniture</li><li>Keeps your CPU
elevated from dusty floors</li><li>Side
mount onl</li><li>16 gauge steel<\li><li>Perfect for school or library
settings</li><li>20" $0.00 Maco Furniture 101cpu $0.00 steel school
furniture, office furniture, home furniture school,
library steel FALSE
http://www.bizchair.com/ BizChair.com FALSE 14-Jan-08
Thanks Dee
"ML" wrote:
> That's nice! Thanks! Now if you'd just post an example of the output you need.
>
> Regarding SSIS - you could start with Books Online. There's also a web site
> dedicated to SSIS:
> http://www.sqlis.com/
>
>
> ML
>
> ---
> Matija Lah, SQL Server MVP
> http://milambda.blogspot.com/