Thank you Gail.

SELECT roll, MAX(sname) FROM Table ORDER BY roll

DECLARE @Table_1 TABLE (Col1 int, Col2 int, Col3 char(4), Col4 char(4))

INSERT INTO @Table_1 SELECT 1, 101, 'Usr1', 'WRK1'

UNION ALL SELECT 2, '101', 'Usr2', 'WRK1'

DECLARE @Table_2 TABLE (Col1 int, Msg char(20))

INSERT...

GilaMonster (1/4/2008)

---

Yeah. The varxxx datatypes have 2 bytes extra to store the data...

GilaMonster (1/4/2008)

---

Null and not null datatypes are the...

karthikeyan (1/4/2008)

---

And,Databases treat NULL values in a special way, depending upon the type of operation that it is used in.

1) When a NULL value appears as an operand to...

Jeff,

with SET STATISTICS IO ON

SELECT TV.Feature, TV.RunStatus, 100.00 * COUNT(*) / B.FeatureCount

:

GROUP BY TV.Feature, TV.RunStatus, B.FeatureCount

:

Mine above shows

Table...

The original query can be optimized as:

SELECT TV.Feature, TV.RunStatus, 100.00 * COUNT(*) / B.FeatureCount

FROM @raw AS TV

INNER JOIN (SELECT Z.Feature, FeatureCount = COUNT(*) FROM @raw Z...

http://www.sqlservercentral.com/Forums/Topic397634-8-1.aspx

They don't mean the same thing.

Try

DECLARE @T TABLE (A int, B char(1))

INSERT INTO @T SELECT 1, 'A' UNION SELECT 2, '' UNION SELECT 3, NULL

SELECT * FROM @T WHERE B...

SELECT loginname, record_date, CAST(((SELECT ((SELECT ((SELECT ((SELECT ((SELECT ((SELECT ((SELECT ((SELECT ((SELECT annual_quota FROM #pipelinehist WHERE loginname = A.loginname AND record_date = A.record_date)

/ (SELECT target_deal FROM #pipelinehist WHERE loginname =...

SELECT * FROM TempTableA A

WHERE NOT EXISTS

(SELECT * FROM TempTableB Z WHERE Z.col1 = A.col1 AND Z.col2 = A.col2 AND Z.col3 = A.col3 AND Z.col4 = A.col4)

You are missing ' at the end of @SQLString1

feeblemind_99 (11/20/2007)

---

Hi Koji,

Yeah I've changed the @Source to my table name and it works! Thanks to that...

kindly explain to me what the statement is doing from the declaration of a...

feeblemind_99 (11/20/2007)

---

Hi Koji, thanks for the help! I tried it and it works.

Anyways, can you explain to me what happens in the statement that you created?

Also, in the Insert...