that was a little stupid! 😀

uploaded file now, set as varchar, but still getting a tab space

hi sean

did you view the link above?

definitely is a tab to me - i can count the 40 Chars including spaces then the space after the , is one...

https://onedrive.live.com/redir?resid=A27225A35A5E094C!1126&authkey=!AIuanGCbZJbuF38&v=3&ithint=photo%2cpng

I want the leading space hence the char (40) etc

but yea definitely getting a tab -when i post my data its removing the formatting on the post

ahh..

i forgot to change the over write data source and reports to True - hence my changes where not applying

stupid me !

hi Alan

could that be the case even if i am using the same account that works locally?

mal

insert statement for lookup table

insert into mal.dbo.Delivery_SLAs values

('HI046','GM','GB','Mon','1215','1','5','4','6','2','Tue')

Table trigger runs off:

USE [MessageCronusTest]

GO

/****** Object: Table [dbo].[Order] Script Date: 22/01/2015 09:17:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[Order](

[ORDERID] [int] IDENTITY(1,1) NOT NULL,

[ORDERNUMBER] [varchar](20)...

Guys, you would be shocked at how dbs are loaded with triggers, sps etc etc in the places that i have worked, but dont worry i hear you and know...

Yea only 100 or so inserts a day, otherwise i wouldnt use a trigger at all

Any tips for making it more efficient? 🙂 always interested in other approaches

got it sorted!

ended up main issue was a security issue of one of the tables i was querying!

mal

ok, thanks Gila

so the program doing the insert needs to be basically told to fire triggers?

yes, first draft, i can work on optimisation once data is posting and is correct...

Hi dd

All postcodes 'should' have a number , but I guess better to have a solution that's a bit more robust. What would you do?

Mal

thanks Luis ,and you are just right making me research what i am doing 😉

SELECT Customer,ShipPostalCode,left(ShipPostalCode, ((PATINDEX('%[0-9]%', ShipPostalCode)-1))

FROM ArCustomer

hi Luis

apols, i am not sure i am following that

if i am reading the postcode field from table customer, how would you structure your query?

thanks for helping

mal