Viewing 15 posts - 2,206 through 2,220 (of 5,109 total)
Are you trying to run the report, or preview it (you state "RUN", however, the dialogue says preview, which is confusing)? Generally, with SSRS, you use Preview on a report;...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 9, 2018 at 8:29 am
Jeff Moden - Wednesday, March 7, 2018 7:48 AMI still want to know why Mr. Britton has 100,000 instances. 😉
Obviously more money...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 7, 2018 at 7:55 am
I really don't know what you're trying to say here I'm afraid.
You need to (probably) provide some sample data here (Saying my data is "like" this doesn't mean...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 6, 2018 at 9:35 am
On it's own, error message 31089 doesn't mean a lot. As you're running this in the SSISDB, the logs will tell you far more information. Have a look at these...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 21, 2018 at 9:19 am
What do you mean my "tried to open"? You don't open a .mdf file, you have to attach it to the Instance. What steps did you take to get the...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 21, 2018 at 4:28 am
SSIS tasks have to be run using Windows Authentication; they cannot be run by SQL Logins. EXECUTE AS does not even get around this; as that is impersonation it's not...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 19, 2018 at 10:14 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 19, 2018 at 7:08 am
There's no logic to cause that error, that's why. you're setting the value of the error message, but you're not raising one; and your INSERT statement (as far as we...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 19, 2018 at 3:36 am
Also depends what you're trying to do. Developer edition is for, as the name suggests, development. The licence agreement means you can't use it for any production/live work. If you...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 19, 2018 at 3:30 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 16, 2018 at 9:03 am
Hmm, another interesting tool they've added to SSMS 17.5. SQL Data Discovery and Classification.
Data Discovery & Classification introduces a new tool built into SQL Server...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 16, 2018 at 3:11 am
I am getting below error
Msg 208, Level 16, State 1,...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 15, 2018 at 12:28 pm
Little more ugly (well, a lot more), someone might have a better answer, however, this works XML_1_3 logic:
WITH StartEnd AS(
SELECT t.[TYPE], t.BATCH_NO, t.Xml_name,
...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 15, 2018 at 10:18 am
Actually it is like ID 1 and 2 into 1 xml_name so...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 15, 2018 at 10:07 am
There a lot of guesswork on this, but, perhaps...
WITH Groupings AS(
SELECT DISTINCT s.ID, t.[TYPE], t.BATCH_NO, t.Xml_name, s.bank, s.[name]
FROM #temp t
CROSS APPLY...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 15, 2018 at 9:51 am
Viewing 15 posts - 2,206 through 2,220 (of 5,109 total)