asco5 (3/27/2013)

---

Hi i have a big problem here

i have a list of person in my database

each person have several entry date and exit date

i would like to know what is...

Jason-299789 (3/27/2013)

---

I'm looking at some code from a project that is not performing very well, and I've noticed that they have a while loop on a couple of the data...

So use the pseudo-code that Scott posted and morph that into the code I posted...

You would end up with something like this:

select Specialty, SchedProv, datename(month, ApptDt2), count(distinct day(ApptDt2)) as MyCount

from...

No worries. I take that by changing the dateformat the query I...

Kenneth.Fisher (3/27/2013)

---

Sean Lange (3/27/2013)

---

Lowell (3/27/2013)

---

OK i now see that SQLFiddle is for MySQL, not SQL Server;

i guess it is some kind of front end tester, where you can build a...

Lowell (3/27/2013)

---

OK i now see that SQLFiddle is for MySQL, not SQL Server;

i guess it is some kind of front end tester, where you can build a temporary schema in...

You said you expect all the sample data to be in October but with the DATEFORMAT you posted the dates are not all in October. If however you set the...

nick.mcdermaid (3/27/2013)

---

Are you kidding me? someone posts into a discussion on forum etiquette asking a new question and breaking most of the rules of forum etiquette in the process!

Anyway.... I'm...

NineIron (3/27/2013)

---

I need to count the number of days that a doctor works in a month. My data has the doc's name and appointment date. The number of visits per...

What you are describing is VBA code. You want to run different queries based on the selection from a combobox. However you can't just mix sql and VBA code like...

A dynamic cross tab is what...

Duplicate post. direct all replies here. http://www.sqlservercentral.com/Forums/Topic1435217-392-1.aspx

fbozek (3/26/2013)

---

I've seen questions here after searching but the answers just don't seem to work for me.

Sample Data:

Day-----------Name

Monday-------Lisa

Monday-------Tom

Monday-------Steve

Tuesday------Sally

Tuesday------Mike

I would like my output to look like this:

Row1: Monday ...

asm1212 (3/26/2013)

---

Yeah what do you think the first thing I did was...GOOGLE duh!

But we have tried those fixes..

Alot of those fixes is talking about the .mdf file when attaching/detaching the...

asm1212 (3/26/2013)

---

Hey guys,

Ran into a problem I have never seen before...

I am logged on to a SQL Server box as sa with sa rights...

I go to create a database, give...