Viewing 15 posts - 301 through 315 (of 1,583 total)
You could try a derived column, using scripting to achieve this, or take advantage of the built in .Net scripting
This link may be of some assitance - http://stackoverflow.com/questions/18659418/ssis-transform-split-one-column-into-multiple-columns
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 18, 2014 at 9:55 am
The report works fine in IE 11. Using your query, I also see that when I run the report in IE 11, a log entry is added to the report...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 18, 2014 at 9:51 am
This should get you what you want - I can't remember the exact post but this code comes from stackoverflow or somewhere similar SELECT 'PK',
kc.name,
...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 18, 2014 at 9:46 am
To be honest, I'm not 100% sure...I guess it would depend on how you are doing it via SSIS. I would assume with the SSIS approach you are using...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 18, 2014 at 8:43 am
Any other dependencies? i.e the table is replicated? Etc?
You could drop the primary key and the NCI's, and issue the ALTER TABLE <<TABLE>> ALTER COLUMN <<Column>> bigint - When complete,...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 18, 2014 at 8:16 am
karthik babu (3/18/2014)
if this result is arrived dynamically or looping using any other logic it will be perfect!!
When is the assignment due? 😉
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 18, 2014 at 7:58 am
Typically you would use INTERSECT to compare the results of 2 queries/tables (data sets) - can you share what you have come up with so far, and what your expected...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 18, 2014 at 7:49 am
I actually did see an improvement by disabling the NCI's but I believe this was due to the fact that I had all of them sitting on their own filegroup...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 18, 2014 at 7:00 am
Perhaps I could just disable the NCI's? I believe this accomplishes the same thing or am I wrong in that assumption?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 17, 2014 at 3:38 pm
Open the working report up in SSRS, go to properties and click the "Edit" button, this will allow you to download the RDL file.
Go to the same report that's broken,...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 17, 2014 at 3:33 pm
Is it possible you had a typo somewhere? Please see this article for a similar issue
http://www.sqlservercentral.com/Forums/Topic465265-149-1.aspx
If the Agent can't start, the reason for it is logged in the OUT file,...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 17, 2014 at 3:28 pm
Did you check all logs (event viewer as well), if not errors reported, did you just run RECONFIGURE or did you specify RECONFIGURE WITH OVERRIDE?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 17, 2014 at 2:05 pm
Do other reports work/render properly?
Are you 100% certain the data sources are set correctly? It's typical when deploying SSRS reports from BIDS to turn off the "overwrite data sources"...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 17, 2014 at 2:03 pm
And here is a pain-free way to script them all out and store them into a table (for safe keeping) 🙂
http://www.sqlservercentral.com/scripts/Indexes/101725/
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 17, 2014 at 11:51 am
Keep in mind that the counters are reset with each server restart, so the results you see may be skewed/incomplete depending on how long your server's been up and the...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 15, 2014 at 11:43 am
Viewing 15 posts - 301 through 315 (of 1,583 total)