BenWard

Forum Replies Created

Viewing 15 posts - 226 through 240 (of 264 total)

RE: update

LutzM (1/3/2011)
STOP!! ... I'd rather go with a persisted computed column parallel to the original column
oh look you got there first.... 🙂
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

January 4, 2011 at 7:56 am

#1268976
RE: update

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...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

January 4, 2011 at 7:53 am

#1268971
RE: insert error with computed column index

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]...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

January 4, 2011 at 7:06 am

#1268921
RE: Whats the idea with this deterministic stuff????

AH HA!
I have fixedized it!
I have rebuilt everything from scratch and now it works 🙂
Thanks for your helps!
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

December 22, 2010 at 7:54 am

#1265528
RE: Whats the idea with this deterministic stuff????

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...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

December 22, 2010 at 7:40 am

#1265523
RE: Whats the idea with this deterministic stuff????

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...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

December 22, 2010 at 6:23 am

#1265467
RE: how many variables can I have?

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...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

November 24, 2010 at 2:36 am

#1254948
RE: how many variables can I have?

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...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

November 22, 2010 at 8:54 am

#1253809
RE: how many variables can I have?

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!
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

November 22, 2010 at 8:08 am

#1253766
RE: how many variables can I have?

to be precise I need 1730 variables of data type int to produce this report
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

November 22, 2010 at 7:41 am

#1253741
RE: SSIS - SSMS 32bit standard edition

very interesting... this sounds broken to me!
have your tried reinstalling ssms?
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

November 11, 2010 at 2:35 am

#1249356
RE: SSIS - SSMS 32bit standard edition

are they both standard edition or is one of them express?
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

November 10, 2010 at 1:41 am

#1248703
RE: UPDATE tblHead SET iHairsRemaining = (iHairsRemaining - 40) WHERE vProblem = 'Perplexing'

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...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

November 10, 2010 at 1:39 am

#1248702
RE: why is this taking ages?

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...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

November 9, 2010 at 4:04 am

#1248131
RE: why is this taking ages?

ok ta.
I'll try calling the func through a SP and running that from php and see what happens.
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

November 8, 2010 at 7:42 am

#1247660

Viewing 15 posts - 226 through 240 (of 264 total)