Hello Jeff,

Your scripts is accurate.

INSERT INTO dbo.myInsertedMenu

(menuCollection_idx)

SELECT menuCollection_idx = ca.mixedID

FROM dbo.myMenuCollection mmc

CROSS APPLY (SELECT mmc.menuCollection_idx...

Owh. Did you have any article to - Create SQL Agent to re-process the Cube in Visual Studio?

Hihi. This is my code

SELECT CVID, WorkExperience, Convert(varchar(10),WorkExperience / 12) +SPACE(1)+'years' + ' ' +

ISNULL(CAST(NULLIF([WorkExperience]%12,0) AS VARCHAR(2))+SPACE(1)+'months','') as WorkExperience_2

from

(

select CVID, sum(WorkExperience) as WorkExperience

from

(select CVID, WorkExperience =...

Hello sir,

How about year? I cant imagine that

tq very much

This is the result after Update

CVID point_To_Scorescore

72 10 ...

Ok. This is my table

1- x_CV

CREATE TABLE [dbo].[x_CV](

[CVID] [int] NOT NULL,

[point_To_Score] [tinyint] NULL,

[score] [tinyint] NULL,

CONSTRAINT [PK_x_CV] PRIMARY KEY CLUSTERED

(

[CVID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,...

LutzM (8/23/2014)

---

Unfortunately, you didn't answer my question:

Why would idx=34 get a score of 10?

It would be a lot easier if the data where in normalized form instead of a separated...

LutzM (8/23/2014)

---

What are you trying to do?

Your description is rather vague...

For instance, what do you mean by

??

For that idx...

Dear Mr Higgam,

You're helping me sir. Thanks to you. But no thanks to other one.

:crying:

g.britton (8/17/2014)

---

Your original post included a screenshot that looks like a windows application. Are you working on that application? If so, I would do the validation there and...

I'm a SQL...

I consider input from Mr Sean Lange and Mr ScottPletcher. So, here it is..

1- This is my Job Notice / Job Vacancy table

*JobNoticeID is a primary key

2- This is Job...

Sean Lange (8/13/2014)

---

Not sure what the question is here. Where does job vacancy come from? The structure you have posted seems reasonable enough but I don't at all understand where...