No Cursor, Where there's a will there's a way.

This is a common request. A little review of the existing posts would have revealed a little somthing like this.

create table Widget(pk...

Please post a your table with Sample data (Or a table like it.)

and then what you want the result to look like.

http://www.aspfaq.com/etiquette.asp?id=5006

Yes, Thats how Crosstab queries work.

Why don't you want to use the IND in the query.

That is the only way to do it.

But you might want to modify code as...

The size of your T-Log is based on your backup Recovery Model.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_bkprst_4l83.asp

Transaction logs grow alot specifically when in Full Recovery mode when there is alot of activity, and no...

My point here is just to buy the hardware that will easily get you thru the next 2-3 years.

If your nowhere near the projected volume, you don't need a server...

Test was over a year ago, and I don't think there was a good Sql Server 64 bit out yet.

CREATE PROCEDURE sproc_Number

(

@deptID int,

@serOff varchar(4) OUTPUT,

@returnNum int OUTPUT

)

AS

DECLARE @Service char(4)

DECLARE @office char(4)

DECLARE @Num int

DECLARE @tempNum int

DECLARE @tempNumTwo int

DECLARE @temp varchar(4)

-- Don't need this, used in subselect below.

--...

Alot of information in here for design considerations:

http://msdn.microsoft.com/SQL/sqlperf/default.aspx?pull=/library/en-us/dnpag/html/scalenetchapt14.asp

You did not mention any failover, or Distaster recovery strategy.

Log shipping, Clustered Server. Backup Strategies.

Also Consider, the db may be 2g now....

from where noeld?

Diagrams in Enterprise Mangler?

That is a very difficult tool to use.

And a PDF Writer like Adobe Acrobat is a little pricier than Erwin, or ER Studio.

2c is...

I don't know of any way to do it.

You'll need to purchase a software package.

Er Win,

http://www3.ca.com/Solutions/Product.asp?ID=260

ErStudio by embarcadero

http://www.embarcadero.com/products/products.html

Visio Enterprise Edition (Not good with over 100 tables)

I agree formatting is a presentation layer function.

there are a few things to consider.

1. Don't let data get into your database this way. The application should commit data to...

hren, As I told you in the early on posts, Dynamic sql was not a good solution to your problem, because of some limitiations with dynamic sql, You need to...

The following creates a test table insert rows some nulls

Create Table TempTest (pk int identity, Field1 char(1), Field2 int, Field3 varchar(100))

Insert into TempTest (Field1, Field2, Field3)

Values ('1', 0, 'No Nulls')

Insert...

I understand that.

But you need to tell us if 2434.56 and 2345.67 are in 2 different fields in the same row?, or if the 2 values are in the same...

No Idea.

I have no idea what you mean by "Than I need to take those values with the decimals and add them together to make one single record."

Declare @Table table...