What version/edition do you have?

Run this and post the results...

SELECT ServerProperty('ProductLevel'),

ServerProperty('ProductVersion')

-SQLBill

A CASE statement MIGHT work:

SELECT CASE WHEN drvT.Total_Sub > 0

THEN LEVEL2ID

...

From the examples you give, and the question...I don't see what you are trying to do. You say you want to remove the values in the CalcAction column in...

Sounds like a memory problem (not enough). How are you doing the query?

1. On the server itself or from a remote machine?

2. From Enterprise Manager, Query Analyzer or another...

quote: Would some like to summarize the difference between a regist...

Huh??? What are you asking?

-SQLBill

Look in Enterprise Manager, expand Management, expand SQL Server Agent. You will find jobs there. Look through them to see what they do. Find the area for DTS packages,...

I'm willing at this point to give Red-Gate and this site the benefit of the doubt. But it's going to be interesting to see what this site is like...

It's looking for capital letters and/or those specified 'special' characters.

-SQLBill

You probably clicked 'Edit Post', the 'Reply to post' option is all the way at the bottom of the thread.

Start looking at the connections made to SQL Server (sp_who2 or...

The issue is that a lot of the stuff happens BEFORE the select occurs. WHERE, GROUP, HAVING all occur on the whole data table before the select. So the alias...

I would talk to your sysadmins..that's an issue with the server not SQL Server. As to why your CPU is at 100% - we can't tell you that. We...

Congrats Steve, Andy, and Brian!

Hopefully, Red-Gate will continue to maintain the high standards you have set for this site. But if the gentleman from ApexSQL is correct, it seems that...

You would create a stored procedure:

CREATE PROCEDURE spGetClientAddress

@FirstName VARCHAR(20),

@LastName VARCHAR(50)

AS

SELECT Address,

City,

...

Can't do it in SQL Server. MS Access is both a front-end (application) and a back-end (database). SQL Server is only a back-end.

Create a stored procedure on SQL Server...

What do you mean rebuild it? Was it deleted? If so, you are out of luck since you don't have a backup.

-SQLBill