Let us know if this is what you are looking for in your query.

SELECT

lmeEmployeeID AS 'Employee',

lmeWebPassword AS 'Emp #',

--Is this person a...

Two others gave you good answers, mine would have been "I don't know, this is your code. You tell us." 😉

It is possible to structure the tables such that you eliminate the column storing the data as a comma separated list. You can then hide this structural change behind...

I've done that on many occasions, especially while writing a query. Makes sure that I have the final ;.

If people would just format their code they could figure out some of their own problems. Geez.

chalbert (5/22/2012)

---

The following data keeps coming up with the error that there is an issue around the as in the alias for age...any thoughts?

Select

dbo.b_ENROLLMENT.MEMBER_DOB_DATE,

dbo.b_ENROLLMENT.EFF_DATE,

dbo.b_ENROLLMENT.MED_ID,

dbo.b_ENROLLMENT.PLAN_CODE as aid,

dbo.p_DMAS_MEDICAL_TRANSITION.recip as recipno,

dbo.p_DMAS_MEDICAL_TRANSITION.SEX...

You may want to read this article, http://www.sqlservercentral.com/articles/T-SQL/67898/.

Lynn Pettis (5/22/2012)

---

craigalaniz (5/22/2012)

---

Hi Lynn

Thanks so much for your help and your tips on submitting a question. I will be sure follow this format in the future.

I noticed that you...

Asynchronous mirroring is only available in the Enterprise Edition of SQL Server.

craigalaniz (5/22/2012)

---

Hi Lynn

Thanks so much for your help and your tips on submitting a question. I will be sure follow this format in the future.

I noticed that you included ft.FormatTime....

jcrawf02 (5/22/2012)

---

Lynn Pettis (5/22/2012)

---

I'm torn with this thread. Should we tell the OP that it is possible to hde structural changes to the tables of the database from application...

SQLKnowItAll (5/22/2012)

---

Eugene Elutin (5/22/2012)

---

Jeff Moden (5/22/2012)

---

...

By posting data in a format that you need 2008 or above for, you're cutting out some pretty hefty SQL Ninjas who may not have...

You should probably look at restructuring this table into two or more tables (I haven't really looked at). If the application must have the data presented to it as...

isaac.wamalwa1983 (5/22/2012)

---

Dear Experts,

I have a scernario where i want to retrieve data from 5 tables:

OVPM - Doc Num,Doc Type,Doc Total,Journal Remarks,Cash A/C

VPM4 - Doc Num,Row Num,Account,Paid,Description,Acc Name, Pay type

OACT -...

At some point in time, yes you may need to end every statement with a ;. Until then, I believe the only statements that require that the previous statement...