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.

😎

I have been reviewing the code you provided, and was wondering how you then execute and delete the resultant package you have created? I am thinking that this may...

Also, i have a question :

when i write ml.year=2008, it´s because "2008" is a variable that iám introduced before running the script.

Do i must write the extended date like...

Geez,...

luissantos (4/28/2008)

---

Hello Lynn

thanks for your reply.

I test my tsql code with some index that you mencioned, but the maximum performance for this TSQL is about 6,30 minutes. Is too much

Also,...