You would need to mofiy the application that is used to delete the row. E.g. query the log table you mentioned.

I would use a stored procedure to get the list of users, select the results into a temp table and, using a *cough* while loop, send the sproc per...

Replace A.TOTAL with A.TOTAL*1.00 to avoid an integer divsion (usually resulting in a zero value in such a scenario).

Example:

SELECT 1/2*100, 1/(2*1.00)*100

I'd go with the IF statement.

Otherwise, you might run in to a catch-all[/url] scenario.

I would use a separate database just to make it easier for backup and restore.

A join would simply be

SELECT t1.col1, t2.col2

FROM table1 t1 INNER JOIN YourOtherDatabase.Schema.Table2 t2 ON t1.col1=t2.col2

As...

I would use an auxiliary table to hold the call information:

CREATE TABLE calls

(

callid INT IDENTITY(1,1),

appId INT,

callTime DATETIME,

...

I would use a web site that would allow to define a table name and a list of columns with data...

If users will be allowed to create tables, they should know how to design a database (e.g. build an ERM based on business requirements).

The issue with a separate schema vs....

@dwain:

What query do you refer to when you write:

The WHERE condition is based on y.WO_NUM and x.WO_NUM . You'll need both. When referring to the missing column in your subquery, I talked about x.WO_NUM.

Sorry for the lees precise...

Please provide some ready to use sample data as described in the first link in my signature together with your expected result.

(Having more than 20 reads on no reply usually...

I can't find the WO_NUM column in the SELECT part of the subquery.

Would you please clarify the scenario you're dealing with:

If it's a web app, you should be the one hosting the database. In that case, the question is: who don't you...

Looks like a classic CrossTab problem (see the related link in my signature for details).

SELECT

T.Name,

MAX(CASE WHEN t.id=1 THEN T.Title ELSE NULL END) AS Title,

MAX(CASE WHEN t.id=2 THEN T.Title ELSE...

Are you looking for something like a self-join?

DECLARE @tbl TABLE

(

Recordid INT , contact_date DATE

)

INSERT INTO @tbl

VALUES (1,'20110401'),(2,'20110501');

WITH cte AS

(

SELECT *, ROW_NUMBER() OVER(ORDER BY Recordid...