Viewing 15 posts - 2,101 through 2,115 (of 26,490 total)
Just a guess, but is this what you are looking for?
CREATE TABLE #companies
(
CompanyName varchar(120),
CompanyStatus varchar(20),
CompanyNumber varchar(10),
GroupNumber varchar(10)
December 28, 2017 at 4:18 pm
Hello All,
Sorry all for not getting back sooner. Year end and all of a sudden...
December 28, 2017 at 3:09 pm
The "red" 1 is just a 1. ci1 and ci2 are table aliases.
December 28, 2017 at 2:47 pm
shannonphillips - Thursday, December 28, 2017 2:46 PMNot following your references to the Red 1 char or ci1, ci2 ?
?????
December 28, 2017 at 2:46 pm
December 28, 2017 at 1:59 pm
vsamantha35 - Thursday, December 28, 2017 1:49 PMnot using query hints at this point.
Good, don't, unless absolutely needed. I haven't used any...
December 28, 2017 at 1:55 pm
December 28, 2017 at 1:10 pm
Or if you are using a query hint to force the order.
December 28, 2017 at 12:02 pm
December 28, 2017 at 11:58 am
And why return a VARCHAR(MAX) value? Are you really going to have a value that needs 2GB?
Plus, this query seems to work just fine:
SELECT...
December 28, 2017 at 11:54 am
December 28, 2017 at 11:31 am
Viewing 15 posts - 2,101 through 2,115 (of 26,490 total)