Simply question, Why? What is the business for doing this?

I wouldn't go to a boot camp. Their only goal is to get you to pass the tests. They aren't interested in you actually learning anything that you may...

Alan.B (5/28/2013)

---

OTF (5/22/2013)

---

phc (5/18/2013)

---

I have gotten a bit further on by nesting a query, but I am not sure I have the distinct right

SELECT C.first_name"Provider", Count(C.provider_no) "Diabetics with over 1...

Let us take a close look at the code:

update top(@BatchSize) ceb set

ceb.new_wcdscreatedon = i.CreateDate

from

contactextensionbase ceb

left join #tmpIndividualCreateDates...

Will be upgrading to SQL Server 2008 R2. Restricted by what the government allows.

No idea why you haven't tried the options provided to you but using your original post in this thread (and Jeff's suggestion), try this:

select right(convert(varchar, CCD.startDateTime , 106), 8) as...

keshava.murthy (5/28/2013)

---

This works as long as you are with in one year.

If it is more than one year then the data will output as:

Jan-2011,

Jan 2012,

Feb-2011.

Feb-2012,

In this case I want the...

Have you tried [Jason.Davis]?

Perhaps the following will give you another idea:

create table dbo.TestSort(

tsid int identity(1,1),

datecol datetime

);

go

/*

Template: Dynamic Tally CTE...

Sounds like the database is using either full or bulk_logged recovery model. The nightly t-log backup will clear the transaction log where as a differential would not.

Actually, it will. Give it a try.

Sean Lange (5/28/2013)

---

Lynn Pettis (5/28/2013)

---

Sean Lange (5/28/2013)

---

Lynn Pettis (5/28/2013)

---

Sean Lange (5/28/2013)

---

Yet another reason NOT to use select *. 😛 I have answered this exact same question at work twice in...

Sean Lange (5/28/2013)

---

Lynn Pettis (5/28/2013)

---

I have...

Well, it is hard to provide you with any ideas when we can't see what you see. It would help if you could provide us with the DDL for...

RedBirdOBX (5/28/2013)

---

Sure. I would have expected SQL Server to do this when testing - especially when I defined the param as a Date type.

When I right click on the...