Search results

Hi I have created a function that has 43 parameters. When I call this function from a query the error I get is "query is too complex". This function will work if I have 28 parameters which seems to indicate a parameter number limit. Is there a way I can either call all 46 parameters or use...

Here is what I have: ID colors 1 white, black, red 2 red, orange 3 blue Here is what I want to achieve: ID colors 1 white 1 black 1 red 2 red 2 orange 3 blue The separated field would be written to another table in the same DB. Any help would be greatly appreciated Thanks in advance mazz