oh look you got there first.... 🙂

Consider adding a computed column, it could be safer than updating a column that might have dependencies.

what I would do (and I expect to be shot down in flames by...

Thanks for reply.

this what you're after?

USE [KPI]

GO

/****** Object: Table [dbo].[tblImportDaily_ageukddf_hhi] Script Date: 01/04/2011 14:03:51 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[tblImportDaily_ageukddf_hhi](

[iFileSeqNo] [int] NOT NULL,

[sFileDate]...

AH HA!

I have fixedized it!

I have rebuilt everything from scratch and now it works 🙂

Thanks for your helps!

aha! TVM!

I have discovered that I was using getdate....

unfortunately it is still reporting as non deterministic...

here is my function...

ALTER FUNCTION [dbo].[funMonthYear]

(

@date SMALLDATETIME

)

RETURNS char(8) WITH SCHEMABINDING

AS

BEGIN

DECLARE @dateToUse AS SMALLDATETIME

SELECT...

Cool thanks.

The function does have schema binding but according to the supplied query is still not deterministic. is this because the scalar function calls a second scalar function? interestingly the...

ColdCoffee (11/22/2010)

---

I would go with a single table with 2 columns.. Column 1 being the variable name and column 2 being value column.. Then u could make use of some...

cool thanks lowell

we discussed it as a team and we feel that the simplicity of senibly named, sensibly grouped variables is the best way to make this program straight...

Thanks lowell.

These aren't input parameters but rather individual variables created like DECLARE @fYetAnotherDamnedNumber AS FLOAT

I'm going crosseyed looking at so many variables!

to be precise I need 1730 variables of data type int to produce this report

very interesting... this sounds broken to me!

have your tried reinstalling ssms?

are they both standard edition or is one of them express?

thanks mate, unfortunately it is completely dynamic with different columns coming out each time.

I have opted to take a programatic approach and write a php script that dynamically creates the...

gosh....

whats going on here... ran in this morning and it takes 54 seconds on both ssms and php!

ugh never mind. looks like I'll have to prepopulate data sets over night...

ok ta.

I'll try calling the func through a SP and running that from php and see what happens.