And to the that other part of your question about alternative data types, don't. Use the appropriate date/time data type for the date/time column in your table. You...

Solomon Rutzky (5/14/2016)

---

Lynn Pettis (5/13/2016)

---

Jacob Wilkins (5/13/2016)

---

Lynn Pettis (5/13/2016)

---

Could some someone provide me with some UNICODE string data that casts wrong from NVARCHAR to VARCHAR and back? Don't need...

Alan.B (5/13/2016)

---

Lynn Pettis (5/13/2016)

---

Alan.B (5/13/2016)

---

Lynn Pettis (5/13/2016)

---

Actually, yes. I have seen that a couple of script authors have posted scripts in multiple parts but it is difficult to find...

Alan.B (5/13/2016)

---

Lynn Pettis (5/13/2016)

---

Actually, yes. I have seen that a couple of script authors have posted scripts in multiple parts but it is difficult to find them since there...

Eric M Russell (5/13/2016)

---

Personally, I don't like it when a recruiter or agency wants to make all the arrangements without me having a face to face with the employer. I...

below86 (5/13/2016)

---

I've got a phone interview set up for next week. Any advice? I have never had to do a phone interview. This is just a phone...

Jacob Wilkins (5/13/2016)

---

Lynn Pettis (5/13/2016)

---

Could some someone provide me with some UNICODE string data that casts wrong from NVARCHAR to VARCHAR and back? Don't need a lot, just a...

Could some someone provide me with some UNICODE string data that casts wrong from NVARCHAR to VARCHAR and back? Don't need a lot, just a few short string values.

Thanks.

b.grove (5/13/2016)

---

I'm confused. I already have a document table with the exact same data in it called Dcoument Signed

So why create another document table duplicating the existing Document Signed...

b.grove (5/13/2016)

---

Hi, Thank you for helping. I really need another pair of eyes to look at this and offer suggestions. I have tried everything, code wise to get...

Actually, yes. I have seen that a couple of script authors have posted scripts in multiple parts but it is difficult to find them since there are no links...

RV16 (5/13/2016)

---

I applied this query:

SELECT SM.yr_cde,

SM.trm_cde,

SS.room_cde,

SS.bldg_cde,

SS.loc_cde,

SS.crs_cde,

SM.short_crs_title_1,

SS.monday_cde,

SS.tuesday_cde,

SS.wednesday_cde,

SS.thursday_cde,

SS.friday_cde,

SS.saturday_cde,

SS.sunday_cde,

SS.begin_tim,

SS.end_tim,

SS.days_tim_ovrid,

SS.begin_dte,

SS.end_dte,

SS.comment_txt,

SS.seq_num_2,

SM.x_listed_parnt_crs,

count(SCH.ID_NUM) "No of student"...

GilaMonster (5/13/2016)

---

This looks like Oracle code.

While some people do know Oracle, this is a SQL Server forum (as in Microsoft SQL Server), and that's what most answers will be written...

Once again with feeling:

Since we can't see what you see you need to help us more. The DDL (CREATE TABLE statement) for the table(s) involved (can be shortened to just...

R.P.Rozema (5/13/2016)

---

Lynn Pettis (5/12/2016)

---

Thought I'd reformat your code some and replace the 3-part naming convention you used with 2-part naming using table aliases. This is important as Microsoft has...