How many Degree ID's will you be passing to the query ?

Ouch, Scott beat me to it. 🙂

May be this ?

IF OBJECT_ID('CompuCol','U') IS NOT NULL

DROP TABLE dbo.CompuCol

CREATE TABLE dbo.CompuCol

(

ID INT IDENTITY(1,1)

,FName VARCHAR(20)

,LName VARCHAR(20)

...

This, my friend?

DECLARE @Tab TABLE

( Id INT ,

Field1 VARCHAR(15),

Field2 VARCHAR(15),

Field3 VARCHAR(15)

)

INSERT INTO @Tab

...

Dont understand what you are trying to do.. could be more specific on what you really want?

Please take a gander at this link on how to help us help you...

Try these

select convert( int , 123.45 )

,convert( int , 123.55 )

,convert( int , 123.00 )

,convert( int , cast( '123.45' as decimal))

select convert( int , '123.45' )

roryp 96873 (2/21/2012)

---

ColdCoffee (2/21/2012)

---

ISNUMERIC will accept and approve decimals, dollar symbol and commas as valid characters! So dont belive ISNUMERIC always.

This MSDN link has a lot of information on ISNUMERIC.Read...

ISNUMERIC will accept and approve decimals, dollar symbol and commas as valid characters! So dont belive ISNUMERIC always.

This MSDN link has a lot of information on ISNUMERIC.Read them up!

And for...

The following link will help you decide that 🙂

http://www.sqlservercentral.com/articles/Temporary+Tables/66720/

Also read the following article on the etiquettes to be followed while posting questions. Trust me, this will reap you rich benefits!

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Unsure on what you are trying to do!

Are you trying to find out the number of Null and Not Null rows? If yes, then this might help you

SELECT

...

You may have to use Global Temp Tables or persisted tables to do that.. If you need your column names to be dynamically included in the CREATE Table clause, you...

Just add

and bmovedout <> -1 or bmovedout is null

in your first SQL query

This (actually, the solution posted by Rory)

DECLARE @Table TABLE

( UserID INT , Interested INT

, Interesting INT , Purchased INT )

INSERT INTO @Table (UserID ,Interested, Interesting, Purchased...

Jeff Moden (2/18/2012)

---

ColdCoffee (2/18/2012)

---

Going through the example again adding extra data, ( new sample has Name1 and name2 appearing 5 times each), here is the code

DECLARE @Table TABLE

( ColVal VARCHAR(10)...