loki1049 (12/22/2010)

Thanks, but I was just hoping there was something like MS Access uses, its...

You can use Dynamic SQL for this issue. But since Table Variables defined outside the SQL statement cannot be used in the SQL statement, you will have to use a...

If i understood you correctly, you need the Patient Details long with the last attended appointment and the immediate next appointment.

You can use the ROW_NUMBER() Function for the same

; WITH...

This is called a Subquery in SQL Server.

http://msdn.microsoft.com/en-us/library/ms189575.aspx

Here we are selecting the first 5 columns( Patient_Code, Patient_Name, Invoice_Code, Date_Created, Date_Visit ) directly from the table @tblTemp as we normally do.

For...

As Wayne has already suggested, NEVER use a code in PRODUCTION if you don't understand it completely. If you use such code without understanding you will find it difficult to...

This should do it for you

DECLARE@tblTemp TABLE

(

Patient_code int,

Patient_name varchar(50),

Invoice_code int,

Date_Visit date,

Date_Created date

)

INSERT @tblTemp

SELECT20, 'David', 2, '2010-11-15', '2010-12-15' UNION ALL

SELECT21, 'Anna', 3, '2010-12-15', '2010-12-15' UNION ALL

SELECT21, 'Anna', 4, '2010-12-15', '2010-12-15'...

This would mostly give the same result again and again. Use NEWID() in the ORDER BY Clause

SELECT...

It's quite simple

SELECT*

FROMTableName

WHEREvalue1 <> newvalue1

ORvalue2 <> newvalue2

ORvalue3 <> newvalue3

I had run into this problem once after which I avoid 2 digit years. But now I know the reason for the issue. Thanks for the Question and the explanation.

Something like this should help..

SELECTp_o.prodid, MAX( p_o.posteddate ) posteddate

FROMprodid p_o

WHERENOT EXISTS

(

SELECT*

FROMprodid p_i

WHEREp_i.prodid = p_o.prodid

ANDp_o.posteddate = DATEADD( DAY, 1, p_i.posteddate )

)

GROUP BY p_o.prodid

Something of this sort

INSERTINTO TableName( List of coloumns ) -- Columns other than the IDENTITY Column

SELECTList of coloumns -- Columns other than the IDENTITY Column

FROMTableName

I think you would be having another table that has a list of all rooms, I have assumed the same to be @Rooms. If you don't have a table like...

Please provide the DDL and some sample data with the expected results. This will help people to reply faster.

You can't use Dynamic queries and temporary tables in a function. So, if you have to implement the Dynamic SQL you will have to use it in a stored procedure.

Glad you took my message in the right spirit and I hope my answer clarified your doubt. 🙂