Viewing 15 posts - 3,916 through 3,930 (of 5,109 total)
Considering that your images don't seem to tie anything together, this is very difficult to tell you anything. What is the SQL you are running. What is the Sample data?...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 12, 2017 at 5:46 am
How are you defining which ID needs to be updated with which URL?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 12, 2017 at 2:57 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 12, 2017 at 2:46 am
Ok, this does seem like it's going to be quite complex. I think I have an idea (or two), but it's going to take a bit to really set up...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 12, 2017 at 2:04 am
Images aren't really helpful here. You need to paste your SQL and upload your .sqlplan file.
Considering that you're changing, what seems like every url to the same thing,...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 12, 2017 at 1:57 am
This isn't cascading anymore, this is one parameter selects all the others.
I think, because you haven't really defined your question in a post, things are getting missed as...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 11, 2017 at 11:08 am
This is not valid SQL:SELECT CityID,
CityName
FROM DevtestDB.dbo.City
WHERE CountryID = @Country1, @Country2, @Country3 ... @Country7
The reason for that set up in that example was...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 11, 2017 at 9:31 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 11, 2017 at 9:10 am
This still sounds like cascading parameters. Did the topic i linked to above not help you on this matter? This shows how you can limit the parameters based on a...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 11, 2017 at 8:27 am
One possible problem I could see is if your business opening hours change. Is this likely, and if so, how would you cater for it?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 11, 2017 at 8:21 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 11, 2017 at 8:07 am
Duplicate of topic: https://www.sqlservercentral.com/Forums/1870160/export-data-to-Excel-using-sql-stored-procedure
Please only create one topic per question, as you'll get better answers and discussions.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 11, 2017 at 8:02 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 11, 2017 at 7:45 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 11, 2017 at 7:42 am
Can you upload the execution plan from the ID 446211 UPDATE statement? It would be good to see what it's planning for one of those updates. You may want to...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 11, 2017 at 7:13 am
Viewing 15 posts - 3,916 through 3,930 (of 5,109 total)