Another example would be to use a case statement to define the column.

--Declare Table

DECLARE @table TABLE (StudentIDINT

,StudentNamevarchar(50));

--Insert Data

INSERT INTO @table(StudentID,StudentName) VALUES (1,'John Doe');

INSERT INTO @table(StudentID,StudentName) VALUES (2,'');

INSERT INTO...

Tom and Jerry

phalanges

Sorry I just went back to review the data and it's not working correctly.

I'm getting the following for the results:

PatientID(No column name)

12011-02-01 00:00:00.000

22011-03-01 00:00:00.000

22011-05-03 00:00:00.000

Here is a technique. It would need to be tested for usuability with a large record set.

-- Define Table

DECLARE @Table AS TABLE (PatientID INT, DivDate DATETIME);

-- Populate Table

INSERT INTO...

Do you have a max server memory set?

I have seen that issue before myself with a system that no matter how much memory you gave it it wanted more. ...

I would check with your microsoft rep. I believe you would only need 2 licenses because your in an active/passive cluster. However, it may require software assurance.

Here is...

It's unclear what you are asking. Could you give a better example of the data in table form.

ie

PRINT 'Declare variable table'

DECLARE @table TABLE

(id int

,a int

...

Here is a post I posted earlier in the year.

http://www.sqlservercentral.com/Forums/Topic1013272-65-1.aspx

I would recommend purchasing over building. If your on a very limitted budget check out the RedGate option or powershell...

Personally I use the following:

SQL Server Customer Avisory Team (SQLCAT)

http://sqlcat.com/

The Professional Association For SQL Server (PASS) (24 Hours of Pass, SQL Rally, SQL Saturdays and Local SQL User...

It sounds like you have an expired/invalid SSL certificate. However, your stating your using http.

If you go to Start - Programs - Microsoft SQL Server 2008 - Configuration Tools...

I have not verified this. Howerver, this looks to match the issue that I am experiencing.

Article ID: 979042 - Last Review: February 17, 2010 - Revision: 2.2

FIX: The principal...

I'm sorry that was a bad example because I don't need to test for the datalength of the field.

This works also.

PRINT 'Declare variable table'

DECLARE @employee TABLE

(id int

,emp_name varchar(20)

...

Here is something quick and dirty. Hopefully it will give you some ideas on how to go after it.

PRINT 'Declare variable table'

DECLARE @employee TABLE

(id int

,emp_name...

an•tip•a•thy ( n-t p -th )

n. pl. an•tip•a•thies

1. A strong feeling of aversion or repugnance. See Synonyms at enmity.

2. An object of aversion.

________________________________________

[Latin antipath a,...