Count( * ) gives the number of records in the table

Count ( columnName ) gives you the count of rows with values in that column

the number of null values is...

I am not sure if I am understanding your required result set correctly but

You could do something like

select cfg.*,

Value1 = Min(

Case v1.INTERNALVALUE 

When cciCode1 Then v1.EXTERNAL_VALUE

Else null

End

)

, etc...

from v_configurationitem...

MAybe I should explain

Get the number of payments.  Count( paymentNo )

Calculate number of pages with 4 Payments per page:  Count( paymentNo ) /...

If I understand Correctly you want a max of 4 payments per page

Then The Page to print to is

PageNo = PaymentNo % ( Ceiling( Count(PaymentNo )/4.00 ) )

I must be over the top.

I am putting togethere a machine with 2*250 + 7*500GB Drives.....

What you are saying is part of the problem. In the example used I would only have stored 25 rows as apposed to 100000, so the space does become...

I forgat to add, I have implemented a solutiopn for these ad-hoc columns or data, but the developers believe it is too difficult to use.... They have to execute a...

Thanks for the response.

That was the example. My problem is I have front end developers who are making changes to the database ( small company, they've been here longer...

Have you tested a similar package to a 32 bit machine, just wonderng if there is an issue with converting the information from the 64 bit machine to the 32...

I think you should look at my ealier responses to your post. you should have an idea of how to do this after shecking those replies.

Use a case statement to split amount into Debit and Credit

Select Debit = Case When Amount > 0.00 Then Amount else 0.00 End

, Credit = Case...

Sorry I forgot to remove the 'With Rollup and Having clause'

There is no need for that.

Try This

Declare @Tab Table(

GL_ID Int

, GL_Name_VC VarChar(15)

, Amount Int

, Period_TI TinyInt

, Year_SI SmallInt

)

Insert into @Tab Values( 1000, 'Inventory', 8000 , 01 ,2005 )

Insert...

Simplified version

--====================================================

--First SQLTask using Source Connection

--Backup DB process-----

Backup Database {DBName}

To File = {BckupFile}

Declare @Cmd Varchar(2000)

Select @Cmd = 'Zip DBZipFile BckupFile'

Exec master..xp_cmdShell @Cmd

Select @Cmd = 'Copy DBzipFile DestZipFile'

Exec master..xp_cmdShell @Cmd

--===========================================================

The other...

I am shooting from the hip here, but I did something similar a while back.

This is how I remember it

1. Get the list of table reference from sysreferences

2. Compare your...