You can issue an ALTER TABLE ... ALTER COLUMN without rebuilding the table, even if the column is the PK.

CREATE TABLE dbo.Document
(DocumentKey NVARCHAR(5) NOT NULL CONSTRAINT...

I am sure someone will correct me if I am wrong, but inceasing the size of the NVARCHAR(5) or NVARCHAR(7) columns shouldn't require a rebuild of the tables if you...

I would have the same EIN & Name combination listed out for both years, that's the way the table was set up. Is there a way to do it?...

True, but the OP also needs to know how to correctly use a...

Couldn't test it, but give this a try:

USE [Premdat]
GO
/****** Object:  UserDefinedFunction [dbo].[fnJasonCreate]    Script Date: 4/15/2019 3:24:10 PM ******/
SET ANSI_NULLS ON
GO
SET...

• This reply was modified 6 years, 5 months ago by Lynn Pettis.
• This reply was modified 6 years, 5 months ago by Lynn Pettis.

One, figure it out by reading the Microsoft documentation.  It is your friend.

Two, what if you have [Entity Name] and [Entity EIN] values in FY 2018 that aren't in FY...

Insert into Cntrl.tbl_Entity_master select distinct [Entity Name], [Entity EIN] from B;

This too.

I get a page not found error on the link above.

In Object Explorer you can right click on the database and in the pop-up menu select the option to backup the database.

Based on what you have just posted, you are...

This is an easy issue to correct.  In SSMS click on Tools.  In the drop down menu click Options.  In the dialog box click on Table and Database Desgners.  In...

It's live now. A problem with some status not moving on auto publish, but the Corgi Contest is out: https://www.sqlservercentral.com/forums/topic/canine-corgi-completion-contest Not a great way to start a Monday,...

I understand. Let me arrange the plan and query. I can't add all the data as it is big enough but will see If I can reproduce it with...

It gives me this error now If I declare and set values like above Msg 134, Level 15, State 1, Line 582 The variable name '@begindate' has already been...

Are these values being compared against other columns defined as DATETIME and do these values have a time component?  If so, you are doing your comparisons...