Adi Cohn-120898 (12/26/2012)

---

Makes perfect sense. I was missing something:-)

Adi

edited: Sorry, just had a look at it. It does seems to work. According to the where clause one...

Golfer22 (12/25/2012)

---

Tinyint and bit have a higher precedence than ntext. Why is this? Couldn't ntext we complex alphanumeric values? Tinyint and bit are limited and simple.

What precedence...

yuvipoy (12/26/2012)

---

Hi,

I am having a condition that i need to create tables on run time that is

Say for customer 1, if logins he will be giving some data which is...

Where is the encrypted data being decrypted? Is all the encryption handled in the application or in the database?

SQL_Kills (12/26/2012)

---

Hi,

First of all I hope everyone has had a good Christmas!

Just wanted to know if anyone documents there table using MS_Description? I'm struggling to think how much detail...

edward_hall76 (12/25/2012)

---

I am using Sql 2008 server and Dreamweaver cs4 and wanting to use asp.net. Or how to connect to Sql 2008 server using php. Does anyone one know...

geoffrey crombez (12/21/2012)

---

Hi,

when I use the READ_COMMITTED_SNAPSHOT and use DELETE FROM table the other session is not locked when SELECTING data.

However when I use TRUNCATE TABLE it does block the...

According to the requirements that won't...

imaceo58 8163 (12/24/2012)

---

I am getting this same error message ...Column name or number of supplied values does not match table definition.

My table definition is...

Again...what is the datatype? The best you are going to get is pure speculation unless you give us the whole picture.

MyDoggieJessie (12/21/2012)

---

I get them, they're just coming in several hours after-the-fact, last night it was after 10pm CST before I got post notifications from 4-5pm...

I thought it was...

adonetok (12/21/2012)

---

I use len function to find out varchar column data size but did not display right size.

For example, in some cell of varchar column, data is "0", "6"... but...

Here is another way.

select t.* from #temp t

join #temp t2 on t.cStudentID = t2.cStudentID

where t2.cCurrentGradeCode <> '99' or t2.cAnticipatedGradeCode <> '99'

order by t2.cStudentID

Excellent job posting ddl, sample date and desired output!!! I wish everybody would post their questions like this.

Here is one way to do this.

select * from #temp

where cCurrentGradeCode + cAnticipatedGradeCode...