Viewing 15 posts - 3,586 through 3,600 (of 11,678 total)
I don't think this is supported out of the box in SSRS.
Are you using Report Manager or SharePoint to view the reports?
March 6, 2014 at 2:42 am
I have a few common SQL scripts at my laptop (creating a date dimension for example). If it is really useful, I tend to blog about it, so that I...
March 6, 2014 at 2:36 am
What exactly are you trying to accomplish? It is not very clear from your question.
It would also be useful if you provided table DDL, sample data and desired output (see...
March 6, 2014 at 12:49 am
Jack Corbett (3/5/2014)
GilaMonster (3/3/2014)
rodjkidd (3/3/2014)
GilaMonster (3/3/2014)
BrainDonor (3/3/2014)
SQL Bits XII has finally been announced http://www.sqlbits.com/.Wooot!
Next problem, what do I submit?
Almost posted last night that site was up. But apparently...
March 5, 2014 at 3:15 pm
Well, typically you just run the SELECT statement and see what if returns. If it is a fairly complex statement, you can add TOP 1 to speed it up (EXISTS...
March 5, 2014 at 3:00 pm
In the package properties, you have LocaleID.
March 5, 2014 at 2:37 pm
Yes, if the SELECT statement returns no rows at all (@SystemComponentTbl is empty in your example), EXISTS will return FALSE and the piece of code will not execute.
It only makes...
March 5, 2014 at 2:35 pm
EXISTS checks if any result is returned. So if the query would return zero, the condition would succeed (probably not what you want).
EXISTS returns false if the query doesn't return...
March 5, 2014 at 2:14 pm
This might not be exactly applicable to your situation, but in my data warehouse I just recreate the ETL flow and import data from the various sources into the database...
March 5, 2014 at 2:10 pm
@Lowell: to script out data, you go to Generate Scripts (1st screenshot) and after selecting the objects you need to click on Advanced in the next screen. There you can...
March 5, 2014 at 2:06 pm
You can get most information from the sys schemas (sys.tables, sys.columns) or from the INFORMATION_SCHEMA tables, but scripting the data is much harder.
Scripting out all of the data can also...
March 5, 2014 at 2:04 pm
Evil Kraig F (3/5/2014)
Koen Verbeeck (3/5/2014)
Evil Kraig F (3/5/2014)
Other than I apparently created a 3! point question for the QotD... 😎(I didn't think it was THAT difficult...)
It was very misleading...
March 5, 2014 at 11:07 am
Evil Kraig F (3/5/2014)
Other than I apparently created a 3! point question for the QotD... 😎(I didn't think it was THAT difficult...)
It was very misleading though 😉
March 5, 2014 at 10:53 am
Evil Kraig F (3/5/2014)
Koen just needs to have more morning coffee. 🙂
... as always :rolleyes:
March 5, 2014 at 10:23 am
Viewing 15 posts - 3,586 through 3,600 (of 11,678 total)