Viewing 10 posts - 1 through 10 (of 10 total)
That was not my question.
i'm asking how can i achieve this in T-sql
Reason i want to do this in SQL because these are very heavy queries...
February 1, 2018 at 12:53 pm
i want clear.
it simple.
i want the head category followed be the sub categories
headcat
subcat
subcat
subcat
subcat
headcat
subcat
subcat
subcat
headcat
February 1, 2018 at 11:49 am
worked.
thanks a lot
August 3, 2017 at 10:37 am
now i only got 1 connections string, for the website application and that is the SA !
Which probably very stupid, thinking about it
Would user with less permissions,...
August 3, 2017 at 8:10 am
mmmm im talking about a public website, so there no users groups.
can't i create user with read permissions and use that as connection string?
then use that connection string...
August 3, 2017 at 6:47 am
Slightly diffrent question, can this also be achieved with the connection string?
if it is possible, how?
and would i be better for performance on a website, have connection string...
August 2, 2017 at 6:16 pm
I trying make a small change. but without success
the result is this now:
OrderID Contents DuplicateOrders
1735733 Apples 1kg 3
1735806 Apples 1kg 3
1735774 Apples 1kg 3
1735756 Oranges 1kg ...
August 2, 2017 at 6:11 pm
That Did the Trick, thanks a lot guys
July 30, 2017 at 3:54 pm
The previous answer gives me the total options, but not the GROUP of options contained in each orderCREATE TABLE #temptable ( [OrderID] int, [OptionID] int, [Quantity]...
July 27, 2017 at 4:57 pm
Nope,
I want to know how many orders (can more then 1 row) have the same products.
So the pack department can do all the same orders in 1...
July 2, 2017 at 12:37 pm
Viewing 10 posts - 1 through 10 (of 10 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy