you might want to have a look at a few...

depends if you need a BIGINT or not - i'd suggest just using yours for anything when max-min > 32,767 - otherwise use the nice small (low resource) version

wouldn't this be easier to do with a recursive CTE?

declare @start bigint=99;

declare @end bigint=147;

with x (num) as

(

select @start as num

UNION ALL

SELECT num+1 from x

where num <@end

)

select * from x...

for example

why does the following not work for you ?

insert into table2 (Number,

reference,

Quantity,

UnitPrice,

Supplier)

select

Number

reference

Quantity

UnitPrice

Supplier

from table 1

where .....

this is the standard syntax for copying data from one table to another

i often find it beneficial to start with a number of sentences describing your objects before you start designing tables and relationships - then you can check off that your...

why do you want to do this one by one ?

ive had this a few times and never got a sucessfull explanation for it ...

it normally happens to me if i'm running an xp in 2000 (such as xp_cmdshell) if...

i would suggest you start using the ANSI-92 SQL syntax it makes debugging duplicates much easier

i rewrote for you....

also - is it possible you are seeing duplicates in RS because...

i just ran the following

select AVG(convert(float,id)) from sysobjects

seems to work fine for me

are you sure didn't type in

select AVERAGE(salary) from #table - that would explain the error

another perspective on this - your primary keys and foreign keys are the same - this doesn't sit well with me

my version of the students table would be (i'm assuming...

in that case it all edpends on how big and how volatile your data is.

the bulk of the memory will be used for buffer cache, but...

you can always use the sp_oa proc calls to asyncronously execute stored procs

that way you don't have to use service broker

here is some sample code i provided to some of...

32 or 64 bit ?

AIRWALKER-375999 (4/26/2012)

---

Thank you all for you're assistance, I think I'll need to redesign the query as what I want do I dont think is possible within a case statement, I...

i think what you are trying to do is either an inner join or some kind of where clause ?

e.g.

select name from users where id='1234567890'

rather than

select case when userid='1234567890'...