Yes, the Upsizing Wizard turns yes/no into bit.

However, the problem is, that the insert statement will not work, and I think if that statement can not be changed as pointed...

Without having your actual table structure this pseudocode

select virusname, count(*) as no_of_recordings from yourtable group by virusname order by no_of_recordings desc

should work

Are you getting the same error when you choose the 'Table copy' option instead of 'Use a query...'?

Sorry, haven't read well enough.

Anyway, how do you import the data?

If you have defined an identity property on your subtext_id column, you don't need to import it from Access. SQL Server will automatically generate the sequence.

How do you do the...

to add to this. Access exposure can be treated.

I can't get bit to work.

So I guess you should use CHAR(5), although that isn't satisfying at all.

I also want to make a compliment.

I really like the 'Who's online' feature.

Some interesting well-known names I discovered there.

What is 'Topic of the day'?

declare @sqlstring nvarchar(1000), @table_name varchar(25)

declare @result int

set @table_name = 'pubs.dbo.authors'

set @sqlstring = 'select @c = count(*) from ' + @table_name

exec sp_executesql @sqlstring, N'@c INT OUTPUT', @result OUTPUT

select @result

CREATE TABLE MyIdentity(

id INT IDENTITY(1,1) NOT NULL,

some_other VARCHAR(10)

)

GO

BEGIN TRAN

INSERT INTO MyIdentity VALUES('Erster')

COMMIT TRAN

BEGIN TRAN

INSERT INTO MyIdentity VALUES('Zweiter')

ROLLBACK TRAN

BEGIN TRAN

INSERT INTO MyIdentity VALUES('Dritter')

COMMIT TRAN

SELECT * FROM MyIdentity

DROP TABLE MyIdentity

GO

results in

id          some_other...

Would this help?

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=19593

Use the image data type.

Amazing !

Works right at the first try with replying and quoting.

You mean T-SQL?

If you're looking for triggers in SQL Server take a look at CREATE TRIGGER in Books Online.