The size columns in the two views are in pages, so I assume you are multiplying them by 8, to get the size in KB then dividing by 1024 to...

does the below fit your needs? added the 0/1 column on the end to see the if its bit = 0 or bit = 1

declare @tab table (PERSON nvarchar(10),...

You have to be careful with playing with id columns, especially if you have foreign key constraints. Identity gaps are common in all databases, especially in transactional scopes where...

Highly useful is CTRL+R, especially when you have a...

Cliff Jones (6/5/2012)

---

anthony.green (6/1/2012)

---

Koen Verbeeck (6/1/2012)

---

anthony.green (6/1/2012)

---

Koen Verbeeck (6/1/2012)

---

I...

You need a full outer join.

declare @tab1 table (year int, week int, total_savings decimal(36,18))

declare @tab2 table (year int, week int, total_savings decimal(36,18))

insert into @tab1 (year, week, total_savings) values

(2012, 10,...

I would say this is down to different dateformats being set at the connection level.

One thing to check would be the language of the accounts in question as I am...

DOMAIN\USERNAME$ is the machine, so does the machine have access to SQL? Also what are the machines services running as which connect to SQL? Local System? If so...

you want sysaltfiles which is the 2000 equiv of sys.master_files

SELECT *

FROM master.dbo.sysaltfiles

Would be a case for a left outer join where mytable2.eid is null

select

t1.eid

from

mytable1 t1

left outer join

mytable2 t2

on

t1.eid = t2.eid

where

t2.eid is null

returns mytable1.eid 5 and 6

can you have multiple people called Jone in your tables? if so is the code the same in tableA and tableB for the right name?

SELECT

A.Code,

A.Name,

A.Sector,

B.Sector

FROM

tableA A

INNER JOIN

tableB B

ON

A.Code =...

2 connection managers, 1 for DEV, the other for UAT, then you need to use as many data flow tasks as you want to copy the tables from DEV to...

Take a look in my signature for the Cross Tabs links by Jeff, the second part is in relation to dynamic cross tabs.

what have you searched for so far, there are plenty good topics on the web on what you want

Manie Verster (6/1/2012)

---

anthony.green (6/1/2012)

---

I might be wrong, but I thought that option was for SQL Mail and not DB Mail so therefore shouldn't be in 2012 as SQL Mail is...