exec p_BackUpTransactions ?

Then click the parameters button to assign @KeepDaysInDatabase to the dynamic parameter ?

Regards,

Andy Jones

andyj93@hotmail.com

Yes, but you still cannot distinguish between

1,2,3

4

and

1,2,3

4,,

as they will appear identical in the working table. The text files are produced by a third party app. and I want to...

For reading the ini file:-

Define a global variable.

Add a dynamic properties task.

Click add

Select your global variable.

Click set and speicfy the ini file as the source.

Then to pass it to a...

update assoc set count = (select * from prospects where assoc.salespersonid = prospects.salespersonid)

Regards,

Andy Jones

andyj93@hotmail.com

No!! But have you tried using a cascade delete and not a trigger to get the functionality you require? In table properties on the relationships tab check the 'Cascade Delete...

nb: In the example above replace <five> by the numeric. I didn't want to write it explicitly as then you would expect this page to be returned in the search...

Also it only brings back unexpected results when the character at the end of the string is W, Y or Z !! For example - search this website from the...

select a from a retuns:-

a

-----------

1

2

3

4

5

(5 row(s) affected)

select b from b returns:-

b ...

Or

select replace(convert(varchar(8),getdate(),1),'/','')

You are limited using convert to the pre-defined list (see BOL), but removing the '/' gives you the format you require.

Regards,

Andy Jones

andyj93@hotmail.com

Obviously dependant upon the situation but it is usual to define the primary keys as integer identity fields where the database automatically assigns an incrementing integer to the column. For...

txt is of datatype varchar(50). I don't think the 100W problem is a corruption as the problem first surfaced in a database of electrical components when entering 50W would return...

Thanks for the response Jon,

I'm trying to do a prefix term search as described in BOL:-

<prefix_term>

Specifies a match of words or phrases beginning with the specified text. Enclose a prefix...

Remove the comma after the end and have a consistent column name i.e. city_state not CityState see below:-

update #temploadpac

set city_state =

CASE WHEN Len(city_state) < 4

Then city_state

ELSE Left(city_state...

You can add labels within stored procedures using the syntax (same as VB) :-

Label1:

And reference them by:-

goto Label1

Regards,

Andy Jones

andyj93@hotmail.com

"1- the row of "ALTER TABLE mal ADD @depo money null" it gives back syntax error for @depo"

This is becuase you are trying to add a columnn from a variable...