SELECT YEARVALUE FROM TABLE WHERE VALUE = MAX(VALUE)

My apologies if I sound dense, but I'd like to know the utility gained from taking the trouble to define an elaborate CASE clause and then filtering records on only...

[Code]CREATE TRIGGER CHECKENDTIMES ON [dbo].[Schedule_Info]

FOR INSERT, UPDATE

AS

DECLARE @START DATETIME

DECLARE @END DATETIME

SET @START = SELECT STARTING_TIME FROM INSERTED

SET @END = SELECT ENDING_TIME FROM INSERTED

SELECT COUNT(TITLE) AS CLASH

FROM SCHEDULE_INFO

WHERE DATEDIFF(m, ENDING_TIME,...

What is the criteria for retrieving the other rows? Write it out as a simple query and then cut out the WHERE part and add it to the first query...

Srini, thank you for such a useful and beautiful piece of code!

1. However, when I ran the script and then the sproc, I found it only created log_tables for...

You can save your script as .sql or .txt and send it to your clients as it is or zipped up, and have them run it from QA.

Alternatively, you can...

[Quote]Also, i want to introduce the [Enter] after add1 and add2 so that when i retrieve the Address, formatting looks good.[/Quote]

SELECT ISNULL(add1,'') + CHAR(13) + CHAR(10) + ISNULL(add2,'') + CHAR(13)...

In many discussions on this issue that I have seen on several forums, including here, all the big boys have been very careful to stress that there is no one...

Irfan, with all due respect (and I suppose I am speaking on behalf of many members), your post is not at all clear on what you need to do.

I grasp...

Pray tell, for the sake of all other members, how you solved it.

Vidhya, I would not be so hasty in claiming that. SQL Server is an OLEDB Server, which means it can hold any type of files, and I am sure there...

Thanks.

Thanks, Ramesh.

Use this statement immediately after committing your insert to extract the last identity value used:

SELECT @@IDENTITY FROM Table

If the related column in Table2 is an FK (i.e. it always has a matching record in Table1, then you can use:

DELETE TABLE1 WHERE Column1 NOT IN(SELECT Column1 from TABLE2)

Otherwise,...