#STACK THE STATES AND STUFF HOW TO#
#STACK THE STATES AND STUFF PROFESSIONAL#
#STACK THE STATES AND STUFF FREE#

They might be less likely to stop someone like me, because I usually wear my university logo clothes when travelling.Īlso, if you're carrying seven watches, chances are customs officials will think you're carrying them for the purpose of reselling, and thus more likelier to make you pay duty on those items. Chances are if you look like a working professional, you will be stopped for inspection. I have been waved through most times without my baggage getting inspected (at any airport - India or outside, so I should count myself lucky!). It all boils down to what customs official inspects your baggage. You do have the INR 45,000 limit (which your iPad may or may not fall within) which you could claim this under, but that won't leave headroom for your watches. The ambiguity lies in whether a tablet would be considered a 'laptop computer' or not because it's not defined within Indian customs law.

#STACK THE STATES AND STUFF PROFESSIONAL#

Note that specifically for Indian citizens returning from work abroad are allowed to bring back 'items of professional use' but computers do not count as 'professional use' items as they can be repurposed by anyone.Īpart from that, passengers above 10 years old flying in from most countries are given a duty-free allowance of items worth INR 45,000 1 as long as they don't fall into one of the restricted items list such as alcohol / cigarettes. Technically, the customs officials were correct in trying to charge him duty on the second. So obviously, your friend who was carrying two laptops (one work, one personal) was stopped.

#STACK THE STATES AND STUFF FREE#

One laptop computer (notebook computer) over and above the said freeĪllowances mentioned above is also allowed duty free if imported byĪny passenger of the age of 18 years and above. It runs in approximately the same time as Kenneth's solution.Here's what customs rules in India state (the 'free allowance' referred to is for personal items, and the duty-free allowance of alcohol cigarettes): PIVOT (MIN(val) FOR col IN (car,name)) AS p

UNPIVOT (value FOR col IN (name,car)) AS u Here is another possible T-SQL implementation which uses UNPIVOT/PIVOT: IF OBJECT_ID('tempdb.#test') IS NOT NULL Again, storing your results in a temporary table is a good idea. | Double XML PATH | 3.1720 | 3.010 | 2,005 | 92,088 | 14,951 | 233,681 |įor each distinct id in #test it performs two operations instead of one but this operation is significantly cheaper than constructing the XML and then reparsing it.Īs already pointed out by Martin Smith, a CLR aggregate is probably your best bet. | | CPU Time (Seconds) | Elapsed Time (Seconds) | #test Scan Count | #test Logical Reads | Worktable logical reads | Worktable lob logical reads | I still found Kenneth's solution with two XML PATH calls much faster and less resource intensive. However for the following test data (1000 ids with 2156 rows per id for me) INSERT INTO #test The execution plan I get for the query in the question first does the concatenation for every row in the outer query and then removes the duplicates by id, SomeField_Combined1, SomeField_Combined2. I would materialise this into a #temp table first to ensure it is only evaluated once. You say that the source for this is an expensive query. But perhaps you don't want to use one for whatever reason. SELECT test.id,įOR XML PATH ('')),1,2,'') AS ConcatenatedSomeField,įOR XML PATH ('')),1,2,'') AS ConcatenatedSomeField2Ī CLR aggregate will almost certainly be the fastest way of doing this. In some ways it seems like it should take longer but it doesn't. I ran this version which is the version I first learned. GROUP BY id, SomeField_Combined1, SomeField_Combined2 I ran a few tests using a little over 6 mil rows. The query is in an in-line TVF, so I cannot use a temporary table.Īlso, if there is a blank column the results will yield extra commasġ sam,ram,john, dodge,maserati,benz,mazda,GMC GROUP BY id,somefield_combined1,somefield_combined2Īre there any better solutions? The inner select comes from an expensive multi-table join (not the single table 'test' shown above). Using a solution I found on Stack Overflow: SELECT * FROM (

#STACK THE STATES AND STUFF HOW TO#

How to concatenate multiple columns in to a single row? For example: id name carġ sam,ram,john dodge,maserati,benz,mazda,GMC

Stack the states and stuff