Thanks for the help!

I Want to see all months even if there are no rows, January 2012 and January 2013 should be seperate rows

So when I use SSMS to exexute the procedure and I enter the Login it puts a single ' in front of the Sample/abc when I go to enter the...

That is exactly what I needed to be returned. Im gonna compare it to the value and query method I was trying.

I put sample values in the asset table just to see what I meant

CREATE TABLE [dbo].[Asset](

[AssetId] [int] NOT NULL,

[DocId] [int] NULL,

[Title] [nvarchar](max) NULL,

CONSTRAINT [PK_Asset] PRIMARY KEY CLUSTERED

(

[AssetId] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS...

Ok, Thanks, I new here and to sql.

I am trying to make Title in table 1 a computed column that will get updated every time the title column in table...