Comments by Member 15352290

Member 15352290 15-Nov-21 10:15am View

Thank you, I think both of you are suggesting right thing . I will try to implement it

Member 15352290 15-Nov-21 9:54am View

I tried something like this : SELECT RIGHT('name:[Pencil]',CHARINDEX(':','name:[Pencil]')) but the output is 'ncil]'. Since i have to check for four possible user inputs , Each will be of different lengths. As name:[value], here value can have several different inputs of different lengths how i can check that

Member 15352290 15-Sep-21 3:03am View

Thank you so much for your help

Member 15352290 15-Sep-21 3:03am View

Deleted

The above solution does not solve my problem.

Member 15352290 15-Sep-21 2:59am View

Hi actually I want to write a single function for both these tables mentioned above and based on some conditions select one table and create a new column with translation added as item.group and if another table is selected all the item should be added with item.class. The only thing i am not understanding is how to use a single function doing this functionality for both these tables

Member 15352290 10-Sep-21 8:04am View

I am replacing 'or' in this similar manner as and
SET @result = Replace(@result, N' and ', N'_');
But it is not working
SET @result = Replace(@result, N' or', N'_');
for leaf or vegetables
For example Output is crop.group.vegetables_melons_leafy_or_stem_vegetables

Member 15352290 9-Sep-21 9:27am View

Thank you so much that completely solved my problem

Member 15352290 9-Sep-21 9:23am View

Thank you

Member 15352290 9-Sep-21 7:55am View

How I can pass all the attributes of my table in the function??? The way I am doing is accepting only one value I want all the rows to be passed and all the rows to be converted into the way it suppose to convert

Member 15352290 9-Sep-21 7:51am View

I am trying to run the above function like this:
where new_CropGroups is a table like this:

Beverage and spice crops
Cereals
Fruit and nuts
Leguminous crops
Oilseed crops
Other crops
Root and tuber crops
Sugar crops
Vegetables and melons

and i want my output to be:

crop.group.beverage_spice_crops
crop.group.cereals
crop.group.fruit_nuts
crop.group.leguminous_crops
crop.group.oilseed_crops
crop.group.other_crops
crop.group.root_crops
crop.group.sugar_crops
crop.group.vegetables_melons

Running my function:
DECLARE @sql nvarchar(1000)

SET @sql = (SELECT group_name from new_CropGroups where group_name = 'Beverage and spice crops')

SELECT dbo.translationkey_v14(@sql) as tranlsation_column

Output I got:
translation_column
crop.group.beverage_sp

Comments by Member 15352290 (Top 10 by date)