declare @id int set @id = 1754 select  (JSON_VALUE(cast(ad.data_map as varchar(max)),'$.dataMap."1754".value')) CorrespondanceNumber, (JSON_VALUE(cast(ad.data_map as varchar(max)),'$.dataMap.***"'+cast(@id as varchar)+'"***.value')) Agency, (JSON_VALUE(cast(ad.data_map as varchar(max)),'$.dataMap."1754".value')) Protocal from actions_new a left join action_data ad on ad.id_ref = a.id where baid = 32 and displayrequestid &lt; 100;   Its working with sql server 2017 but error showing in sql server 2016.     Error : Msg 13610, Level 16, State 1, Line 3 The argument 2 of the   "JSON_VALUE or JSON_QUERY" must be a string literal. Problem in   converting INT to vachar "'+cast(@id as varchar)+'"
I am getting error:     The argument 2 of the "JSON_VALUE or JSON_QUERY" must be a string literal   ...while trying to pass variable as parameter to JSON_QUERY function. Please help me to resolve it.  DECLARE @cnt INT = 1; DECLARE @cnt_total INT = 1; DECLARE @json NVARCHAR(MAX); DECLARE @json1 NVARCHAR(MAX); declare @str  VARCHAR(200);  WHILE @cnt &lt;= 10 BEGIN     set @str = '$.Seasons[0].Products['+convert(varchar,@cnt)+'].ProductChannels';     set @str = char(39) +@str+ char(39);     PRINT @STR     select @json = json_query(jfile,@STR) from Import.tstjson; --MORE CODE         SET @cnt = @cnt + 1; END   Sample data:  {   "Seasons": [     {       "Season": "12321231",       "Products": [         {           "ProductId": "211",           "ProductChannels": [             {               "ChannelId": 1,               "WeekQuantities": []             }           ],           "ccc": 3,           "Tttt": 4         }       ]     }   ] }
Is Meta Stack Overflow just the meta for Stack Overflow or is it a somewhat special meta site? Initially I thought that Meta Stack Overflow was the common meta for all SE sites.   Then I noted that  has its own meta site.   It took a while for me to learn that even Server Fault has its own meta site.  Looking at my reputation points, I see difference between Stack Overflow and Meta Stack Overflow, but not between the other sites and there corresponding meta sites.  Now, is Meta Stack Overflow in some sense the master meta site of all or not? Just that. By good I mean something at the level of SolidWorks, AutoCAD, or similar. This is a complete limitation for me (and many others) to use Ubuntu. Uniform convergence of $\sum_{n=1}^{\infty}\frac{1}{n(1+(x-n)^2)}$ Is $$\sum_{n=1}^{\infty}\frac{1}{n(1+(x-n)^2)}$$ uniformly convergent on $(0,+\infty)$? Sadly, Weierstrass' criterion nor Cauchy's condition don't seem to work here and I just ran out of ideas. How do I switch to first person? How to sandbox applications? I want to run small untrusted programs, but restrict them from accessing any files outside of their folder, network access, and everything else that they don't really need. What is the simplest way to achieve this? To prove in a Group Left identity and left inverse implies right identity and right inverse Let $G$ be a nonempty set closed under an associative product, which in addition satisfies :      A. There exists an $e$ in $G$ such that $a \cdot e=a$ for all $a \in G$.      B. Given $a \in G$, there exists an element $y(a) \in G$ such that $a \cdot y(a) =e$.      Prove that $G$ must be a group under this product.   Attempt -Since Associativity is given and Closure also, also the right identity and right inverse is given .So i just have to prove left identity and left inverse.  Now as $ae=a$ post multiplying by a, $aea=aa$. Now pre multiply by a^{-1} I get hence $ea=a$. And doing same process for inverse Is this Right? How to delete all lines that do NOT contain a certain word in Vim? In vim I can delete all lines that contain the word "price" with this  :g /price/d   How can I delete all lines that do NOT contain the word "price"? How can see call history in iPhone one month back, i also tried with tried party software but that is not perfect , is the any solution from apple? Proving that if $G/Z(G)$ is cyclic, then $G$ is abelian Possible Duplicate:             If $G$ is a group and $Z(G)$ the center of $G$, show that if $G/Z(G)$ is cyclic, then $G$ is abelian.  This is what I have so far:  We know that all cyclic groups are abelian. This means $G/Z(G)$ is abelian.  $Z(G)= \{z \in G \mid zx=xz \text{ for all } x \in G \}$.  So $Z(G)$ is abelian.    Is it sufficient to say that since $G/Z(G)$ and $Z(G)$ are both abelian, $G$ must be abelian? $A^m\hookrightarrow A^n$ implies $m\leq n$ for a ring $A\neq 0$ I'm trying to prove that if $A\neq 0$ is a commutative ring and there is an injective $A$-module homomorphism $A^m\hookrightarrow A^n$ then $m\leq n$ must necessarily hold.    This is exercise 2.11 from Atiyah and MacDonald's Introduction to Commutative Algebra, but unfortunately all the solutions available online are either very sparse with regard to this question or seem to use (to my surprise) a generalized version of Cramer's rule. Is there perhaps some other "cleaner" approach to solving this problem? Simple question, but one that I've been curious about...is there a functional difference between the following two commands?  String::class String.class   They both do what I expect -- that is to say they return Class -- but what is the difference between using the :: and the .?  I notice that on those classes that have constants defined, IRB's auto-completion will return the constants as available options when you press tab after :: but not after ., but I don't know what the reason for this is... I am not able to play "Half-Life-2" on Steam + Ubuntu 14.04 . Error shown in message box on screen:      Could not find required OpenGL entry pint 'glGetError'! Either your video card is unsupported, or your OpenGL driver needs to be updated.   I have a Dell Inspiron Laptop.  My OS is Ubuntu 14.04 and my graphics card is AMD Radeon HD 8600M.  I have installed AMD properietry Driver.    The partial output of "glxinfo" is as follows:      name of display: :0     libGL: screen 0 does not appear to be DRI3 capable     libGL: pci id for fd 4: 8086:0a16, driver i965     libGL: OpenDriver: trying /usr/lib/i386-linux-gnu/dri/tls/i965_dri.so     libGL: OpenDriver: trying /usr/lib/i386-linux-gnu/dri/i965_dri.so     libGL: Can't open configuration file /home/arushi/.drirc: No such file or directory.     libGL error: failed to load driver: i965     libGL: OpenDriver: trying /usr/lib/i386-linux-gnu/dri/tls/swrast_dri.so     libGL: OpenDriver: trying /usr/lib/i386-linux-gnu/dri/swrast_dri.so     libGL: driver does not expose __driDriverGetExtensions_swrast(): /usr/lib/i386- linux-gnu/dri/swrast_dri.so: undefined symbol: __driDriverGetExtensions_swrast     libGL: Can't open configuration file /home/arushi/.drirc: No such file or directory.     libGL: Can't open configuration file /home/arushi/.drirc: No such file or directory.     libGL error: failed to load driver: swrast     display: :0  screen: 0     direct rendering: No (If you want to find out why, try setting LIBGL_DEBUG=verbose) How can I completely remove all traces of Java on my system?   I already know  in case I need it again. Diacritics and non-English letters in anglicized loan words: keep 'em, dump 'em, italicize the words, or what? Stack Overflow provides good tools in the question editor, like "Links" and "Styling".  Another thing that for me would be nice is a color selector. Although an HTML editor is available, a direct click on tool would be good, and users can select different colors, as for marking errors in their program with red, and more important data with blue. Proving a limit of a trigonometric function: $\lim_{x \to 2/\pi}\lfloor \sin \frac{1}{x} \rfloor=0$ $$\lim_{x \to \frac{2}{\pi}}\lfloor \sin \frac{1}{x} \rfloor=0$$    I need to prove the limit of this using the $\epsilon - \delta $ way but I don't know how to find $\delta$ when I'm given a trigonometric function I know only how to do it with polynomial functions Android app "Unknown error" when uploading photo Spent a half hour on this. Android 5.1.1 latest version SE app (Play Store won't let me update so latest).   Tried to upload photo into an answer. "Something went wrong".  Did tricks to reduce photo size to 275k -- same.    45k rep on the stack.  Here is the photo..... oh wait.  How do I solve? Top-bar hat misplaced In my profile my hat is on the correct position, but not in the top-bar. This is new. It worked until now.    Works neither in Chrome nor in Firefox. I want to know by an example how prices in stock market changes Let us assume there is a listed company x. Currently it has 100 shares issued to trade in free float market. Current price of stock is let say 10. Now please let me know if I purchase one share of company x at the market price of 10. How it will effect the stock price. And please add and exemplify some other scenarios whichever you find good to explain more. For more information let say promoters of the company holds 100 shares with them like 50% of the company is with promoters and the other half is with people who invest or trade in that company. If I've missed to tell or assume any other vital info. needed please assume it yourself while mentioning it. Thank You What's the difference between cards, panels, and tiles? It seems as if with some of the modern front-end development frameworks there is a blur between the different types of 'container' elements. Whether this is an attempt to abstract the design from implementation or if this is due to there not being any standardization of terminologies I am not sure, but it leads to the fact that in some design frameworks I see the term panels being used but not cards (e.g. Bootstrap 3) while in others the term cards exists but not panels (e.g. Iconic), and perhaps both exist in others?  From a design perspective, it seems that both cards and panels are just containers, and since there's nothing that defines how big a card can get and how small a panel can be, I am wondering whether there's really any difference. From an implementation perspective, it seems that cards should be used for smaller size design elements and are preferred on mobile specific applications, whereas panels are used for a wider range of design elements and are preferred on desktop specific applications.  Is there any evidence/reference/examples that will help to illustrate or highlight the (lack of) differences? For some reason I think cards and tiles are more closely related to each other, and that panels seem to be in a slightly different class/family?  If we take the argument that there are no differences, then it is hard to understand why people associate 'tiles' with Microsoft 'Metro' style home pages, while on Google and Android apps it is 'cards' and for Java and Gnome applications it is 'panels'. Perhaps there are some contextual or implementation differences?  UPDATE: with the release of Bootstrap 4, it seems like cards are basically equivalent to panels (since one component has replaced the other), but with this comes the cost of having to maintain a more flexible container that will make it difficult to implement consistently. According to Bootstrap:      A flexible and extensible content container. It includes options for   headers and footers, a wide variety of content, contextual background   colors, and powerful display options.   FURTHER UPDATE: It seems as if Bootstrap 5 and Material.io have adopted the card UI component in the new world of responsive and mobile first/multi-device ecosystem design systems while "tiles" have a very specific meaning in the Microsoft Fluent Design System:      A tile is an app's representation on the Start menu. Every app has a tile. When you create a new Universal Windows Platform (UWP) app project in Microsoft Visual Studio, it includes a default tile that displays your app's name and logo   Panels don't seem to be part of the vocabulary anymore, as least in terms of a UI component, but in the Microsoft and Java world it still represents an abstract concept of organisation layouts of UI components.