Viewing 15 posts - 2,236 through 2,250 (of 2,648 total)
August 28, 2018 at 12:29 pm
I'm thinking this might be some setting in SSMS. How are you running the insert?
Does this work?DROP TABLE dbo.TestText;
GO
CREATE TABLE dbo.TestText(myText text NOT NULL);
August 28, 2018 at 10:34 am
One quick thing to try is to add at the end of the SQL statement " OPTION (OPTIMIZE FOR UNKNOWN)"
So the last lines of your SP would look like:
August 28, 2018 at 10:18 am
August 28, 2018 at 7:47 am
August 28, 2018 at 6:26 am
August 28, 2018 at 5:46 am
August 28, 2018 at 5:12 am
August 27, 2018 at 12:48 pm
August 27, 2018 at 9:06 am
August 27, 2018 at 7:00 am
August 27, 2018 at 6:27 am
I'm now getting an error
August 27, 2018 at 6:27 am
Those columns are for the defined year, I want to select the same...
August 26, 2018 at 11:16 pm
August 26, 2018 at 10:56 pm
Viewing 15 posts - 2,236 through 2,250 (of 2,648 total)