SQl Query

Question

Hello I have below row data ?keyword=sweet ?keyword=sweet1 ?type=326_338_389 Now i need to show like key value keyword sweet keyword sweet1 type 326_338_389 I need sql query can you please help me

Vikrant More · Answer

Keyur try this below script IF OBJECT_ID('TEMPDB..#TEMP') IS NOT NULL BEGIN SELECT 'TABLE EXISTS' DROP TABLE #TEMP END CREATE TABLE #TEMP ( ID INT IDENTITY(11) STRING VARCHAR(100) ) INSERT INTO #TEMP VALUES ('?keyword=sweet')('?keyword=sweet1')('?type=326_338_389') SELECT RIGHT(SUBSTRING(STRING1CHARINDEX('='STRING)-1)DATALENGTH(SUBSTRING(STRING1CHARINDEX('='STRING)-1))-1) AS [Key] REPLACE(STRINGSUBSTRING(STRING1CHARINDEX('='STRING))'') as Value FROM #TEMP

Riddhi Valecha · Answer

Hi.. Is this is sort of dynamic search query ??

Manish Kumar Choudhary · Answer

I am not getting you question. What is your table structure ?