You're welcome.

Now the most important question. Do you understand how the code works? Would you be able to explain it if needed?

Remember that you'll be...

As my wife says, mother's...

Something like this? Or I misunderstood the question?

CREATE TABLE Company_Messages(

CompanyId INT,

MessageID INT,

CONSTRAINT PK_Company_Messages PRIMARY KEY (CompanyId, MessageId),

...

You're missing the obvious way to get the current date. :hehe:

USE [msdb]

GO

DECLARE @jobId BINARY(16);

EXEC dbo.sp_add_job @job_name=N'GetCurrentDate',

@enabled=1, @job_id = @jobId OUTPUT;

EXEC dbo.sp_add_jobserver

@job_name = N'GetCurrentDate' ;

EXEC...

We already know this. I already post a test...

Actually, have you tried this?

Declare @test nvarchar(50)

select @test = N'College'

I'm assuming that you have a unicode character in the value which won't translate correctly into ASCII strings, instead of...

vantuan02t1 (11/19/2015)

---

Naturally I will declare a variable, sample:

Declare @test-2 varchar(50)

select @test-2 = 'College'

(1) Select * from Table_1 where Description like N'%' + @test-2 + '%'

But test result is different with

(2)...

I'm sorry, I'm just watching too much Green Batman Arrow, lately. 😀

How did you declare the variable?

Using this, you might get a hint:

PRINT N'%' + @test + '%'

jasona.work (11/19/2015)

---

I was going to post this over in Steve's call for Good Basic T-SQL Exercises but decided not to pollute the topic with fluff...

So I'm posting it here...

Just for...

You have the wrong formulas to calculate each part. Check my previous post for correct formulas.

That's me being jolly.

I'm not sure if that's confusing enough. 😀

The insert is not part of the view, you might want to use a...

Seriously? And should I know why? Or should I guess?

It's a basic programming fact that variables have scope. In T-SQL,...