Viewing 15 posts - 2,041 through 2,055 (of 5,111 total)
What do you mean "mapped"? Do you mean the service account that the SQL Server Agent runs under doesn't have a user on that database? If not, then no the...
May 16, 2018 at 3:37 am
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...
May 16, 2018 at 1:16 am
May 15, 2018 at 11:33 am
SUBSTRING(InvoiceNumberMapping
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...
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...
May 15, 2018 at 9:40 am
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...
May 14, 2018 at 4:29 pm
May 14, 2018 at 3:04 pm
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...
May 14, 2018 at 2:04 pm
Thanks very much for taking time to read and reply my question. It is appreciated....
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...
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. 🙂
May 14, 2018 at 7:57 am
Viewing 15 posts - 2,041 through 2,055 (of 5,111 total)