Skip to content

Instantly share code, notes, and snippets.

@josespinal

josespinal/get_products.sql

Last active August 29, 2015 14:19
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save josespinal/9e8776f28cd6289db346 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save josespinal/9e8776f28cd6289db346 to your computer and use it in GitHub Desktop.
Download ZIP
SQL for getting products with its categories
Raw
get_products.sql
SELECT *, STUFF( (SELECT ',' + c.nombre FROM categorias c join productos_categorias pc on c.id = pc.categoria_id WHERE pc.producto_codigo = p.id FOR XML PATH(''), TYPE ).value('.', 'NVARCHAR(MAX)'), 1, 1, '') categories_names FROM productos AS p WHERE actualizar = 1;
@IntoCRASH
Copy link

IntoCRASH commented Jul 9, 2015

Saludos José!
Tienes una version del Unicenta Pos con el NCF agregado?
No soy programador. Tengo conocimientos y podria intentar agregarlo, basandome en la info que compartiste, pero lo mio no es eso. Soy artista, y tengo un bar en Santiago con el que quiero utilizar Unicenta, porque es Open Source, y por lo intuitivo de la interfaz.
Gracias por la info, de antemano!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment