Current valid data:

IF OBJECT_ID('TempDB..#mytable','U') IS NOT NULL

DROP TABLE #mytable

CREATE TABLE #mytable

(

RouteName VARCHAR(3) PRIMARY KEY,

...

The routing line it's used to validate the selections of the user in the interface, to write a log file...

First i check if the points selected by the user...

Thanks call.copse

That solved the problem.

Here some sample data:

GO

CREATE TABLE #Table1 (colName VARCHAR(10),ValCol1 DECIMAL)

CREATE TABLE #Table2 (colName VARCHAR(10),ValCol2 DECIMAL)

INSERT INTO #Table1

SELECT 'name1',1 UNION ALL

SELECT 'name1',1 UNION ALL

SELECT 'name1',1 UNION ALL

SELECT 'name1',1 UNION ALL

SELECT 'name1',1 UNION...

I know that i need to put the data here with the SELECT UNION to help to test the query, but i don't find the topic how to do it...

@Toby Harman

- True

Just to be capable of handling future changes in the workflow, like this one that I'm dealing...

I have to look in the forums, at least for tips, for several reasons, i have to solve this problem, i have to solve it by myself because I'm the...

@LutzM

Until the process change, i think that all in one table product case was a good choice, and if my company doesn't had changed the process I never...

Thanks for the replys

@Toby Harman

I was thinking in something like that, but i must check some things before doing that.

My application main core works around this table, i have...

Sorry for the late response... holidays 🙂

Yes i know that i need to redesign the table, that's why i ask for help 🙂

My business logic isn't like the normal product...

Sorry...

Like i said the original table has more than 100 columns, so i'll put here a sample of one similar with less columns.

Let's say that the company manufactures products for...

No one... 🙁

How do i quote some one?!

@gilamonster

I have little knowledge about developing dw's, but the little thing that i know for example in...

Yes there isn't any rule that tells that, but it should be... 🙂

😀

Hehehe

This was a small application that is increasing in the time, by adding other functions/modules/options.

Now i have to redesign one of the modules, and i was looking...