You're welcome.

Reinstall the client tools from an RTM (or later) disk.

You should be able to query the backups tables in msdb and use the data from there.

Nikki (8/6/2009)

---

I guess I did not phrase the question clearly.

Users do need access within database to perform their duties but they should be connecting to database only through the application...

It would look like this for you:

declare @Range varchar(10);

select @Range = '1-3';

-- Query

;with CTE as

(select EMPLOYID, 1 as Col, GROSWAGS_1 as MonthlyWages

from dbo.UPR00900

union all

select EMPLOYID, 2 as Col, GROSWAGS_2

from dbo.UPR00900

union...

jordon.shaw (8/6/2009)

---

I'm really new at T-SQL. I do have a background in PHP, so I know programming and I know SQL, just T-SQL is new for me, so I'm...

I'm just hoping to make him shoot soda out of his nose when he reads my post.... 😛

Do you mean the actual size of the stored data for each row, or do you mean the total possible size for the columns?

Here's a sample solution that you should be able to modify to fit your needs:

set nocount on;

if object_id(N'tempdb..#T') is not null

drop table #T;

--

-- Table with similar structure

create table #T (

ID...

The one that says:

While there are exceptions, most of the DBAs *I* have met seem to fit into one or more of the following categories:

Conservative, not necessarily in the political...

Jeff Moden (8/6/2009)

---

Grant Fritchey (8/6/2009)

---

GilaMonster (8/6/2009)

---

Grant Fritchey (8/6/2009)

---

Jeff Moden (8/6/2009)

---

I've not confirmed my plane reservations but I'm 99.99% sure that I'm going to be in Lil' Rhody from 9/6 to...

It makes sense. It's the reason that data of that sort should be stored in rows, not columns, but it can be made to work.

Will the query always be...

bitbucket (8/6/2009)

---

For those who read this forum and who are living in the U.S.A and who have forgotten about the Do Not Call listing and who wish to stop telemarketing...

If you have a Numbers table, you can use this:

;with

DatesInMonth (Date) as

(select

dateadd(day, Number-1, dateadd(month, datediff(month, 0,...

Look up "incremental" in a good dictionary. Not trying to put you off, but it's pretty straightforward once you've done that.