If it's a registered server, right-click server and select properties. Go to the connection properties tab. Check the "Use Custom Color" checkbox, and select the color.

If it's a server that...

check out the EXCEPT and INTERSECT operators:

select <columnlist> from table1

EXCEPT

select <columnlist> from table2

will show you what's in table1 but not in table2

replacing EXCEPT with INTERSECT will show you what is...

You know, the people that help out here are all un-paid volunteers. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables affected, and INSERT statements to put...

First question: are you working in SQL 2008? I ask because you posted in a SQL 2008 forum, yet your xml code looks like SQL 2000 era. If you're in...

TRACEY-320982 (8/4/2010)

---

The data does not exist in main table

INSERT INTO MAIN_TABLE

SELECTCOLUMN1, COLUMN2

FROM TEMP_TABLE

WHERE NOT EXISTS

(SELECT * FROM MAIN_TABLE) W

WHERE

W.COLUMN1 = COLUMN1 AND

W.COLUMN2 = COLUMN2)

So i am doing a where...

Then it looks like you went...

You can't use a CTE in SQL 7/2000 (which is the forum that you posted in).

In addition to what has already been mentioned, you might want to check out the cross-tabs and pivot articles (Parts 1 and 2) - links are in my signature. Part...

Ken,

You're not going to find too many people here very wild about your cursor solution. There are many of us that will be willing to help you get rid of...

Okay,...

I think the problem with using a view in a select statement is if the view doesn't have all of the columns that you need, and you end up joining...

Ray, thanks for that link. I'm also trying to look into MVC.

Perry Whittle (8/4/2010)

---

Hmm yes, the only issue with that diagram is the Quorum assignment! I would use a majority node set with a witness and put the Quorum mirrored drives...

Yes. Did you even try to do this?

WITH TableCTE (ClientID, ProductName, ProdSize, MeasuredDate) AS

(

select ClientID, ProductName, CAST(Avg(ProdSize) AS DECIMAL(9,2)) as ProdSize,

convert(varchar(4),dateadd(month, datediff(month, 0, MeasuredDate),0),100) + convert(varchar(4),year(dateadd(month, datediff(month, 0,...

One slight improvement on Lutz's function:

CREATE FUNCTION [DSUSER].[BDP_WPS_Approvals] (@lWPSID AS INT)

RETURNS TABLE

WITH SCHEMABINDING