May be like this..there can be another way to do this

SELECT CASE WHEN NAME IN ('Foo','Alice') THEN 'Alice'

WHEN NAME IN ('Dan','Bob') THEN 'Bob'

ELSE NAME

END...

Hi ,Please try below if it's match with your desire result..

May be it can be done with more simply way.

I have alterd function alldays to include startdate for join.

ALTER FUNCTION...

You need to use primary key ..if it is sequential then it can be used ,else you need to generate identity i think.

may be below script you can use with change as per requirement.

DECLARE @C INT

DECLARE @I INT

DECLARE @L INT

DECLARE @max-2 INT

SET @C = 1

SET @I...

Hi,

please try below

SELECT DISTINCT [surveyName],[respondent],

(STUFF(

(SELECT ',' + filmPreference

FROM ##multiPick B

WHERE A.respondent = B.respondent

FOR XML PATH ('')),...

I think, you need to have audit table which would be same as original table with

two more fields version and action .action will store if it was insert,update or delete.

create...

Luis Cazares (6/11/2014)

---

If you only need those 3 levels, just keep it simple. 😉

SELECT p.TeacherId AS userID,

s.UserID AS student

FROM #temp p

JOIN #temp s ON p.UserID...

Jack Corbett (6/11/2014)

---

So what you want returned is something like this:

Pediatrician Parent Student

6062 6063 6064

6062 ...

may be like this..not sure if work or not as don't have sample data

INSERT INTO @tbl

(

vCreditApp,

...

There must be some other technique for this but from what i understand, i come up with below code..

;WITH CTE AS(

SELECT DATEPART(HH,starttime)S,COUNT(*)cnt,ScheduleDate,MIN(starttime)start, DATEADD(mi,1,MAX(endtime))endt

FROM [DoctorScheduleFortoday] WHERE UnitStatus = 0...

Thanks..Alan Burstein

Hi..Ed Pollack

once again thanks..your code works correctly :-).

meanwhile i come up with below code..just to share

/* Data generation for #LocalTempTable */

DECLARE @Date1 datetime

DECLARE @Date2 datetime

SET @Date2 = '03-18-10'

SET...

Ed Pollack (5/20/2014)

---

Good Morning!

The simplest solution to this would be to use PIVOT to flip the data into the format you are looking for. Please try out this SQL...

aberndt (5/19/2014)

---

Hi - I'd like to create a view where I can select one value from the previous row in the table. Can a query be written that does...

Grant Fritchey (5/13/2014)

---

Ok..means view should be avoided in...