ALot of books for reference...

SQL Server 2005 Bible by Paul Neilson can be one of the option.

Alot info. Some of the things have really changed in SQL Server 2008.

Just a concept....

Another Option...

Declare @t1 Table(mid int, val varchar(100))

Insert into @t1

Select 1,'123' union all

Select 2,'123456' union all

Select 3,'123456789' union all

Select 4,'123456789123'

Declare @vChk varchar(100)

Set @vChk...

Not very sure aboiut your inputs and output but try this...

Declare @t1 Table(mid int, val varchar(100))

Insert into @t1

Select 1,'123' union all

Select 2,'123456' union all

Select 3,'123456789' union all

Select 4,'123456789123'

Declare @vChk varchar(100)

Set...

From the following code, it is verified that the Index is used with or without function on the column...

Create Table #t1 (mid int,gdate datetime)

CREATE CLUSTERED INDEX [IX_ALIEN_MISSILE] ON [#t1]

(

[gdate] ASC

)...

Check this...

Declare @tMain Table (mid int, pid int)

Insert into @tMain Values ( 1,0)

Insert into @tMain Values ( 2,1)

Insert into @tMain Values ( 3,1)

Insert into @tMain Values ( 4,1)

Insert into @tMain...

Why do you think you need to put common attributes in one table? If I had 2 different entities Person and Building and both entities had an address associated with...

Good One...

Check this...

http://www.sqlservercentral.com/scripts/Miscellaneous/30085/

Not really clear what you're asking, but try this

WITH Numbers AS (SELECT number

FROM master.dbo.spt_values

WHERE type='P')

SELECT Appointment_time,Duration,Appt_count,ApptLimit_For_Day,patientRecNum,

PatientName,ApptCreatedDate,

CASE...

Why not the subquery?

Is it a Quiz...:w00t:

What exactly are the inputs and output?

You can have more than one columns IF the subquery is used in the FROM Clause.

But NOT if used in Select List (column list), Where conditions and Having conditions. Only...

Here it is... I think cursor is the option...

CREATE TABLE #Temp1

(

ID int Identity(1,1),

Appointment_time CHAR(4),

Duration INT,

Appt_count INT,

ApptLimit_For_Day INT,

patientRecNum VARCHAR(15),

PatientName VARCHAR(148),

ApptCreatedDate DATETIME,

Overbook_Flag CHAR(3),

Doctor VARCHAR(200),

[ApptDate] VARCHAR(50)

)

INSERT INTO #Temp1

SELECT '0800',15,12,7,100,'patient1','2009-02-17 15:51:55.427',NULL,'Doctor1','04/27/2009'

UNION

SELECT '0815',45,12,7,105,'patient2','2009-02-27...