You can use this example for how to create the missing years. If you can't get it working with this, please do as Lynn suggests, and give us table structures...

No, this is the way that table variables are supposed to work.

What you can do is change all of the "DECLARE @TABLE TABLE" statements to "CREATE TABLE #TABLE", then change...

Thanks Lynn. I remember that now after reading it.

Wonder why those parameters for ServerProperty still...

Agreed.

EXCEPT will get you a list of all of those that you want them to have, minus the ones already...

This will get you the information for one server:

select ServerProperty('LicenseType'), ServerProperty('NumLicenses')

What I would do is to incorporate this into the SQLCMD command line utility, using the FOR /F dos command...

NP. Haven't heard back from the OP yet...

I think it's all fixed now... all the code...

To elaborate on what Lynn mentioned, you can use either the IF or CASE statements as shown below:declare @var1 char(3),

@var2 char(3)

set @var1...

Rog Saber (4/20/2010)

---

I have a table MAINT_REQ in which I want to insert values. I want 'mary' to have all of the same roles as 'jo'. 'jo' has a bunch...

If you're using a monitor server, the "Transaction Log Shipping Status" report (available in SSMS, right-click the server, select reports | Standard Reports | Transaction Log Shipping Status), and you...

You might want to check out this link for help in pivoting a query.

You might want to check out the REPLACE function in BOL.

You might also check out the LIKE function... you might be able to use it as LIKE '%[SX]VD%'.

I was just thinking about this,...

I don't see an issue with your code.

I just ran this code, without error.

CREATE PROCEDURE [dbo].[sp_TLCOMSCandReg] (@CandID VARCHAR(50) output,@FirstName VARCHAR(100),@MiddleName Varchar(100),

@LastName VARCHAR(100),@EmailID VARCHAR(250),@MobileNo VARCHAR (15),

@PhoneNo VARCHAR (15),@DOB DATETIME,@Gender SMALLINT,@Address...

This doesn't have anything to do with your issue, but why are you passing nvarchar fields to a procedure that is expecting varchar?