Thank you, Paul. I am honoured to get a reply from an author-grade pro. Of course I want any help to map the relationships.

After racking my brains yesterday, I have...

Thanks again. Just curious, as SQL Server is so complicated to work with, is there any reference or quick guide to help people like me who dont want to be...

Thanks for the compliment, Lowell, it is why I am here in the first place.

I cannot log in to SQLEXPRESS with sysadmin privileges as I can at MSSQLSERVER, so that...

Agreed, but, FYI, stripped data is first backed up for future retrieval before being purged.

All I want to know is, even if I do NOT delete old records:

How to...

[Code]

CREATE TABLE [dbo].[dbo_transactions_master](

[transaction_id] [int] NOT NULL,

[transaction_date] [smalldatetime] NOT NULL,

[department_id] [int] NOT NULL,

[transaction_type] [tinyint] NOT NULL,

CONSTRAINT [PK_dbo_sales_master] PRIMARY KEY CLUSTERED

(

[sale_id] ASC

)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON...

I'm not a pro like all the others who have already ventilated this thread, but what I would do in this case is restore a backup on an independent computer...

No, DayNumberOfWeek should NOT be reset when the year changes, because it is just that - Day Number Of Week - and not Day Number Of Year.

Second, have a look...

For a debugging tutorial, see

[Code]Hi i am having table with emp code and transaction,i want to calculate how many hours he worked for the day.

Format of table

id ...

[Code]CREATE TRIGGER TABLE1_INSERT_TRIGGER

ON TABLE1

FOR INSERT

AS

SELECT *, 1

INTO TABLE2

FROM INSERTED

CREATE TRIGGER TABLE1_UPDATE_TRIGGER

ON TABLE1

FOR UPDATE

AS

UPDATE T2

SET T2.FLAG = 2

FROM TABLE2 T2

INNER JOIN TABLE1

ON TABLE2.ID = TABLE1.ID

CREATE TRIGGER TABLE1_DELETE_TRIGGER

ON TABLE1

FOR DELETE

AS...

Easy - I would generate a script of all my stored procedures and then search where the function name appears in it.

Also, an update may include the target column without changing its original value, if the actual UPDATE statement contains all column names. Then you will end up incrementing it needlessly....

[Quote]CHAR((2*Count(*)) + (CASE Sex When 'M' Then 0 Else 1 End)[/Quote]

Returns the ASCII character for the numeric value returned by double the count for MALE and double the count plus...

I think you will have to be a bit more clear in wording your problem in order to get the help you need.

Karthik, we can all see that Jeff did not intend to offend you so let us not blow this out of proportion.

Let's call it a truce for the sake of...