Just to add insult to ... well, insult ... I would like to second the motion to have some sort of "does the question even make sense in English" type...

If you want to do that, create a temp table with ## instead of #, and then make sure to drop it when you're done with it. Those can...

You can use sp_configure to set an affinity mask for the server instance.

See:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/5823ba29-a75d-4b3e-ba7b-421c07ab3ac1.htm

in Books Online for details.

I don't think I understand your example and question. Why do you want the rows you want, and not also want the one that has a 1 in the...

The one time I had a view that had "select *" in it, and needed that, and the table changed and I had to update it, I right clicked the...

Use a Numbers table.

create table dbo.Numbers (Number int identity(0,1) primary key)

go

set nocount on

insert dbo.Numbers default values

go 10000

insert into finaltable (PK)

select cast(pidkey as int) + number

from dbo.Numbers

inner join dbo.tblKey

on number <=...

Modify the temp table definition by adding:

DateDay as cast(convert(varchar(25), [date], 101) as datetime),

Then run your inserts, and try:

select top 1 #rr.date, #rr.session

from #rr

inner join

(select dateday, session

from #rr

except

select dateday, session

from #rr

where...

Does that mean it worked? Or just got you far enough along to make it work on your own? (I'm curious about how well I remember how Access...

Ah. Makes sense now. Yeah, a few miliseconds here and there probably won't matter much if the whole query takes several seconds in some cases.

I'll stick with the...

It seems to me that you could use:

select *

from currenttable

where col1 between 0 and 255

and col1 = floor(col1)

That would give you all the rows that are TinyInt.

Move those to the...

I'm not totally sure, since I can't run the original and the conversion and make sure they get the same results from the same data, but try this:

case

when

[DBA_cs_project].[creator_id] Like...

Also, as per the other post here, I'd recommend moving the stuff you have in "HAVING" up to "WHERE". That will make the whole thing a little bit faster.

The reason your Where clause isn't working as expected is the OR statements need to be in parenthesis. Add an open paren "(" before the first "YEAR" and ")"...

Since I'm not a C# programmer, I can't help with that part. I'd say just open up the Business Intelligence Studio and create an SSIS package and start working...

In Management Studio, open up the database, open up the Security branch, open Users, right-click the user you want to edit permissions for, open the Securables tab, use Add to...