Viewing 15 posts - 1,366 through 1,380 (of 5,109 total)
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 30, 2018 at 7:54 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 30, 2018 at 7:31 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 30, 2018 at 6:39 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 30, 2018 at 5:48 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 30, 2018 at 5:26 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 30, 2018 at 4:59 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 30, 2018 at 4:42 am
Then your only method is Dynamic SQL. With a large amount of data, this WILL perform poorly, as you are having to refer to the table dbo.Profile for every Profile....
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 30, 2018 at 4:39 am
That white space is in your design view too; it's appearing as you've designed. You need to move the elements,
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 30, 2018 at 4:19 am
Then all the tables have the same definition? Then this design needs to ideally change. Have a Profile table which has the ID of the Profile; not 1 Profile table...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 30, 2018 at 4:02 am
So wait, the columns are bespoke per table?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 30, 2018 at 3:40 am
Only with Dynamic SQL. This, however, has the smell of bad data design. It might be better to take a step back and show us the set up you have,...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 30, 2018 at 3:25 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 30, 2018 at 3:23 am
No, the only way to to make your query safe is to parametrise it. The documentation example covers how to parametrise your query.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 30, 2018 at 3:06 am
Only where you have used enterprise features of 2008 that aren't in Standard Edition of 2016 and the breaking changes for SQL Server 2012-2016. And, of course, the cardinality estimator...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 29, 2018 at 10:03 am
Viewing 15 posts - 1,366 through 1,380 (of 5,109 total)