MD (5/7/2008)

---

I'd put it in function and then pass the function the three date values

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE FUNCTION [dbo].[ufn_MaxDate] (@DateA DATETIME, @DateB DATETIME, @DateC DATETIME)

RETURNS DATETIME

BEGIN

DECLARE @ReturnDate DATETIME,

BEGIN

...

Just a problem with some people not reading the entire question. The question did specifically state SQL Server 2005.

Good question, everything specified to be able to make an educated...

Would you please provide a little more detail into what you are doing? Specifically, how are the four tables related (just need enough of the DDL to understand the...

Just another view of the example above. I added a count(n) to show the difference between count(*) and count(column_name).

select

count(*) as theCount,

count(n) as theOtherCount,

avg(n)...

And, what perchance, is this warning message?

😎

Do the following:

round((s.ScoreAdjTotal - c.CourseRating) * 113 / c.CourseSlope,1,1) -- The additional 1 at the end will truncate instead of round (read BOL)

😎

I put in my own referential integrity. You will need to adjust my code below for the fourth table you added. Also, mathematically, the result of your equation...

gtan018 (5/6/2008)

---

I have three tables that I wish to perform a simple query calculation. What would be the best option for my situation? I would need to calculation:

(ScoreAdjTotal) - (CourseRating)...

This is done in T-SQL, but the principle is the same:

declare @phonenum varchar(25)

set @phonenum = '(555) 555-1212'

select replace(replace(replace(replace(@phonenum, '(', ''), ')',''), ' ',''),'-','')

😎

I found a way to connect to the Windows Internal Database (SQL Server 2005 Embedded Edition (SSEE)) with thanks to Wikipedia!

It has to be done local to server, and you...

Dumb question, but why are you using a cursor to move data from one table to another instead of a set-based query?

😎

Not sure if this is totally correct, but this is the view I'd start with.

create view Vw_name

as

select

cust.customerID

from

dbo.customer cust

inner...

Looks like you are trying to connect to SQL Server 1005 using SQL Server 2000's Enterprise Manager or Query Analyzer. Just like the messge says, you need to use...

Could we see the DDL for the table?

😎

Derived tables are not allowed in indexed views either.

😎