Jeff, The Yesterday_Amount should show the Amount the Amount the ID was for yesterday. Thanks

Thanks for your help

So am I right in saying if the field KeyRef is not one of the followings:

NULL

*CORRECT*

***FAILED***

'' (Empty)

Then it does not meet the condition so It will not get passed to...

Hi,

So I have found this website that has a user defined function

http://www.hexcentral.com/articles/postcodes-distances.htm">

http://www.hexcentral.com/articles/postcodes-distances.htm

CREATE FUNCTION dbo.GetDistance

(@e1 float, @e2 float, @n1 float, @n2 float)

RETURNS float

AS

BEGIN

RETURN...

I only want the short post code not bothered about the full post code, the website is only doing the short post code so it won't be as many lookups...

Thanks Sean, but getting the following error

Conversion failed when converting date and/or time from character string.

Hi Sean,

Yes I know ID 266966 is not a valid date, I tried to use the IsDate function to exclude these dates but wasn't working either so not sure what...

Thanks i will have a look at your code

Erikir, the ssis package search will work from the query I have provided, I have aslo provided one to search for stored procedures. If i was a new person starting...

Just doing a google search and I have found the following that will do some of my searches:

Search Stored Procedure

sp_msforeachdb'use [?]

SELECT sm.object_id, OBJECT_NAME(sm.object_id) AS object_name, o.type, o.type_desc, sm.definition

FROM sys.sql_modules AS...

1. If you look at the attachment , it is showing blank because when you deploy a ssis package to the server it will stored this to a file i...

Hi,

So say I have a table called "TableA" and have two database one called "Hub" and the other Database called "Adventure". I then want to call a stored procedure...

Hi, ok the end user will be myself then. I know there is a sql script out there that will return the ssis package name, I think it uses the...

Hi, I do not believe the tables that are in the Database are being updated by an external application.

Hi,

I'm not sure how my Question is Vague? Ideally the user will enter the table name as a parameter to the stored Procedure findMyTable('TableA') and this will then run numerous...