Viewing 15 posts - 2,041 through 2,055 (of 5,109 total)
You say it's looping on itself, but i don't see any loops. I imagine part of the problem is the possible Cartesian product you have by not using an alias...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 16, 2018 at 1:16 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 15, 2018 at 11:33 am
SUBSTRING(InvoiceNumberMapping
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 15, 2018 at 11:29 am
Looks like you haven't set your groups up properly. This'll likely be easier to trouble shoot with consumable sample data and the rdl of your report (which you'll need to...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 15, 2018 at 10:54 am
SELECT
OBJECTID,
OBJECTNAME,
ATTRIBUTEID,
ATTRIBUTENAME,
CATEGORYNAME,
VERSIONNUMBER,
VALUEINT,
VALUESTR
FROM
(
SELECT
A.OBJECTID,
A.OBJECTNAME,
B.ATTRIBUTEID,
B.ATTRIBUTENAME,
B.CATEGORYNAME,
B.VERSIONNUMBER,
B.VALUEINT,
B.VALUESTR,
ROW_NUMBER()OVER(PARTITION BY...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 15, 2018 at 9:40 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 15, 2018 at 8:28 am
You need to give a lot more details here. We have no idea what your package is doing, however, I'd guess you have a script task in there. Help us...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 14, 2018 at 4:29 pm
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 14, 2018 at 3:04 pm
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 14, 2018 at 2:28 pm
Ok, first things first, those implicit joins need to go. It's 2018, you've no excuse for using 30 year old syntax: Bad habits to kick : using old-style...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 14, 2018 at 2:04 pm
Thanks very much for taking time to read and reply my question. It is appreciated....
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 14, 2018 at 11:24 am
Deprecated means that the functionality hasn't been removed, yet. Yet is the key word here. The data types TEXT, NTEXT and IMAGE, for example, have been deprecated since SQL Server...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 14, 2018 at 8:22 am
Huh, and all this time I've been using Derived Column Transformations, or relying on SQL Server to do the implicit conversion. Nice find, and well explained. 🙂
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 14, 2018 at 7:57 am
May 14, 2018 at 4:32 am
YOU're close, but not quite there; seems you don't quite understand how an IIF works, or nested IIF's, so I'll explain that first.
The format of an IIF works...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 14, 2018 at 2:24 am
Viewing 15 posts - 2,041 through 2,055 (of 5,109 total)