Viewing 15 posts - 346 through 360 (of 1,491 total)
Test data :
You have over 4000 points and have been shown how to post test data on numerous occasions.
March 15, 2022 at 9:58 am
You need to create the point from the Latitude and Longitude for each row. Something like:
(geography::STPointFromText('POINT(' + Latitude + ' ' + Longitude + ')', 4326)).STDistance(@destination) /... March 14, 2022 at 8:30 pm
You either need to filter in the JOIN or do something like WHERE (a.Type = 1 OR a.Type IS NULL)
https://sqlbolt.com/lesson/select_queries_order_of_execution
March 10, 2022 at 9:43 am
Maybe the user is in a role etc. These two queries may help you:
SELECT P.state_desc COLLATE DATABASE_DEFAULT + ' '
+ P.[permission_name] COLLATE DATABASE_DEFAULT + ' ON '
+...
February 25, 2022 at 7:57 pm
Sharing violation.
Something else is trying to open the file at the same time you are trying to copy it. Speak to you infrastructure team. Possible causes are server backups,...
February 23, 2022 at 8:13 pm
SELECT @rescli = rescli, @qtt = qtt FROM INSERTED
This suggests the trigger does not really work. Triggers need to allow for multiple rows being inserted/updated....
February 20, 2022 at 12:48 pm
As you have the data in a separate database ownership chaining is not going to to work.
I would be inclined only to give the users access to SPs in the...
February 17, 2022 at 7:45 pm
You could start by creating the temp table with COLLATE DATABASE_DEFAULT and getting rid of all the COLLATE DATABASE_DEFAULT in your joins. All the casting is not going to help...
February 14, 2022 at 5:55 pm
You may also want to see if you can get class diagrams from the developers. Even a base class diagram gives you an idea of the required data structures.
February 9, 2022 at 3:58 pm
I suspect your main problem may be your applications as SQL2000 and SQL2005 allowed old style outer joins. Unless your applications always use stored procedures you will need to work...
January 28, 2022 at 4:59 pm
SELECT T1.userid, T1.maildate, X.addr_update_dt
FROM #t1 T1
CROSS APPLY
(
SELECT TOP (1) T2.addr_update_dt
...
January 28, 2022 at 10:45 am
You can use dbatools
January 27, 2022 at 5:56 pm
Hello,
Does anybody have an idea for the reason and how can the problem be solved?
Grant is correct about wanting to create a view in a sp but to answer...
January 27, 2022 at 1:00 pm
On looking at this again this may be a safer approach:
WITH Rules
AS
(
SELECT id, [value]
,CASE
...
January 18, 2022 at 10:42 am
This should cope with more edge conditions than my original query:
WITH Rules
AS
(
SELECT id, [value]
,CASE
...
January 17, 2022 at 6:25 pm
Viewing 15 posts - 346 through 360 (of 1,491 total)