Suggest reading this:

http://sankarreddy.com/2010/02/get-the-server-level-default-connection-properties-for-sql-server-using-t-sql/

Above article contains:

CREATE TABLE #ConnectionOptions (property VARCHAR(100), value INT)

INSERT #ConnectionOptions

SELECT 'implicit transactions', 2 UNION ALL

SELECT 'cursor close on commit', 4 UNION ALL

SELECT 'ansi warnings', 8 UNION ALL

SELECT 'ansi...

Here is what we expected from you, remember you are closest to the problem and we are not, so you may have something that you are aware of and we...

Steve Jones - SSC Editor (5/27/2011)

---

bitbucket-25253 (5/27/2011)

---

Driving a Mercedes 300 1992 (Diesel with super charger) now at 303,562 miles. Change oil every 5,000 ... maintence every 10,000 costs $90.00,...

Difficult to answer your question without some sample data and desired results.. could you post same? For ease of posting readily consumable data please click on the first link...

Stefan Krzywicki (5/27/2011)

---

Lynn Pettis (5/27/2011)

---

Stefan Krzywicki (5/27/2011)

---

GSquared (5/27/2011)

---

Stefan Krzywicki (5/27/2011)

---

GSquared (5/27/2011)

---

ALZDBA (5/27/2011)

---

GilaMonster (5/27/2011)

---

Elliott Whitlow (5/26/2011)

---

Jan Van der Eecken (5/26/2011)

---

GilaMonster (5/26/2011)

---

One very uncomfortable PM sent...

From the posts the person has made,...

Having served as a volunteer at the same event, I agree with all that you have said. But would add that the speaker's dinner the night before was...

Is this what you want?

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[T_computedCols](

[Col1] [int] NOT NULL,

[Col2] [int] NOT NULL,

[col3] AS ([col1]+[col2]),

[col4] AS ([col2]+(1))

) ON [PRIMARY]

GO

ALTER TABLE [dbo].[T_computedCols] ADD CONSTRAINT...

WayneS (5/23/2011)

---

bitbucket-25253 (5/23/2011)

---

bitbucket-25253 (5/23/2011)

---

WayneS (5/23/2011)

---

bitbucket-25253 (5/23/2011)

---

A plea for assistance, from the denizens of the thread.

QOD - easy enough to display the page to create and submit etc., etc.

When...

bitbucket-25253 (5/23/2011)

---

WayneS (5/23/2011)

---

bitbucket-25253 (5/23/2011)

---

A plea for assistance, from the denizens of the thread.

QOD - easy enough to display the page to create and submit etc., etc.

When the submittal...

WayneS (5/23/2011)

---

bitbucket-25253 (5/23/2011)

---

A plea for assistance, from the denizens of the thread.

QOD - easy enough to display the page to create and submit etc., etc.

When the submittal page...

A plea for assistance, from the denizens of the thread.

QOD - easy enough to display the page to create and submit etc., etc.

When the submittal page displays mine...

Thank you for a nice clear and concise question.

1. Do you have a question about the code?

a. Does the code when executed fail and return an error?

2. Does your code...

In the distant past at a location far away an analysis of...

Here is a step by step possible solution for you to walk through and combine statements when you understand them and of course want to.

DECLARE @St AS Datetime

DECLARE @et...