Marcus Farrugia (7/10/2014)

---

Hi using the following code, I'm receiving error:

Conversion failed when converting date and/or time from character string

DECLARE @DAYFROM DATETIME

DECLARE @DAYTO DATETIME

DECLARE @sql VARCHAR(1000)

SET @DAYFROM = CAST ( ((GETDATE()...

kpwimberger (7/10/2014)

---

Thanks folks. I will see if I can create some generic example code.

I have not worked with CTEs and partitions, so I'll have to do some research on those....

kpwimberger (7/10/2014)

---

Ok all, here is my setup: I have the following tables -

tblPerson - holds basic person data.

tblPersonHistorical - holds a dated snapshot of the fkPersonId, fkInstitutionId, and fkDepartmentId

tblWebUsers...

Grant Fritchey (7/10/2014)

---

I get it. I'm not the brightest bulb in the box, but I can usually understand the logic of processing data most of the time. I'm utterly at...

I ran across one earlier today that was like this:

coalesce(count(*), 1, 0)

Really had to scratch my head trying to figure out...

haggis

Rhombus

You're welcome. Glad that worked for you.

As posted the query I wrote will work.

create table employee1(firstname varchar(5), lastname varchar(5))

create...

This awfully brittle as Steve already said but this should do it.

update e1

set firstname = e2.firstname

from Employee1 e1

join employee2 e2 on e2.lastname = e1.lastname

No problem there.

CreatedBy

ModifiedBy are referring to other tables where they are PKEY and data...

heh the...

This was also posted in the 2008 forum. http://www.sqlservercentral.com/Forums/Topic1590347-1292-1.aspx

Please don't cross post. It only causes fragmentation in your answers.

Lavery (7/8/2014)

---

I'm trying to write a view that pulls a column with Null values, but also uses the MAX function to get the most recent LastReceiveDate. I've tried using IsNull...

Ratheesh.K.Nair (7/8/2014)

---

Hi Experts,

Below are the original design and modifications recommended by us. Do i need to add anything or did i miss anything?

--Original Table design

CREATE TABLE ASC

(

[ASCID] UNIQUEIDENTIFIER NOT NULL,

[MuthalID]...