Viewing 15 posts - 31 through 45 (of 88 total)
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...
November 15, 2014 at 1:37 pm
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...
November 14, 2014 at 3:46 pm
Thanks Sean, but getting the following error
Conversion failed when converting date and/or time from character string.
November 10, 2014 at 10:49 am
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...
November 10, 2014 at 10:40 am
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...
August 5, 2014 at 3:01 pm
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...
August 5, 2014 at 2:49 pm
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...
August 5, 2014 at 2:40 pm
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...
August 5, 2014 at 2:10 pm
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...
August 5, 2014 at 1:10 pm
Hi, I do not believe the tables that are in the Database are being updated by an external application.
August 5, 2014 at 12:58 pm
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...
August 5, 2014 at 12:57 pm
When I deploy a SSIS package I would do this in Visual Studio by clicking on File > Save Copy of
A new window would appear which would say "Save...
June 30, 2014 at 4:25 pm
I am not quite sure? How would I know if the package is stored on the msdb or disk?
Thanks
June 30, 2014 at 3:26 pm
How would you parse the XML? Do you have any sql code that would do this? Thanks
June 26, 2014 at 11:57 pm
Viewing 15 posts - 31 through 45 (of 88 total)