Viewing 15 posts - 5,011 through 5,025 (of 5,109 total)
Although this doesn't answer your question, why does a customer have the ability to delete a table? If this is something they definitely shouldn't be doing, it most definitely worth...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 10, 2016 at 7:06 am
You posted this last month as well, asking exactly the same question.
I'm pretty sure that this isn't a function of SSRS though. I haven't seen it in 2008 to...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 9, 2016 at 3:30 am
Luis Cazares (6/8/2016)
For a fast sequential read of a table to move data from one system to another, you could also use SSIS.You're doing ETL work, use the ETL tool.
This...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 8, 2016 at 7:55 am
Sounds like your after a *shivers* Cursor.
Would this do the job?
Create Table #Loop (ID int, Name varchar(20))
Insert into #Loop
VAlues (1, 'Steve'),
(2, 'Jane'),
(3, 'George'),
(4, 'Harold')
Declare @Name varchar(20)
Declare Loop_Cursor Cursor...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 7, 2016 at 8:09 am
I'm not 100% sure on the logic of your table here. What I've created below definitely isn't scalable if you were to have a department without 2 employees (what even...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 7, 2016 at 4:28 am
How are you going to show arrows in a chart? Visually this should be pretty apparently if you are showing it in a chart, as the line/bar will be higher...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 7, 2016 at 4:09 am
A Foreach loop is what you're after.
I have something similar, that checks our SFTP "In boxes" once a day to see if we're received any new files. Files in specific...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 6, 2016 at 7:38 am
If you're using the calendar, that shouldn't be a problem. Are you able to confirm the browser they are using?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 6, 2016 at 3:27 am
When you say latest version, do you mean 2016? if so, 2016 has had an overhaul with Mobile Devices in mind. Here's a link to the MSDB article about creating...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 6, 2016 at 2:57 am
This sounds like you're entering a date that isn't valid but effectively "could be". Take, for example 31 January 2016. I would type this as 31/01/2016, but an American would...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 6, 2016 at 2:55 am
Thom A (6/3/2016)
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 3, 2016 at 3:33 am
The fact that the error says that your connection failed, really doesn't suggest there's a problem with the variable mapping, and is the connection manager. Especially if you have the...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 3, 2016 at 2:31 am
I would hazard a guess that it's hardware limitations. Are you running sufficient RAM on your server? Are you running any other services apart from SQL on the server?
SQL Server...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 2, 2016 at 7:36 am
I assume you're talking about the display at the top of the page, where you select your dates, and other parameters? If so, this isn't a problem with SSRS, it's...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 1, 2016 at 9:56 am
For questions like this, it best to give us some sample data and table set up.
Can you provide some create and insert statements? It would also probably help to...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 1, 2016 at 9:02 am
Viewing 15 posts - 5,011 through 5,025 (of 5,109 total)