general mock (fake) database creation approach ?

Hello, friends and gurus. May I have some advice on general approach you
guys take to generate a mock database with fake data in it?
Thanks
--
SincerelyIf you have real data available, you can scramble the data (especially
names) to make demo data. Otherwise, it's just a lot of work. There are
lots of options. Randomize. Get some other data source and pretend it's
what you want. Refactor census data. Get imaginative.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Frank RS" <FrankRS@.discussions.microsoft.com> wrote in message
news:C2C3586F-FC2F-4476-B1F3-F74265142799@.microsoft.com...
> Hello, friends and gurus. May I have some advice on general approach you
> guys take to generate a mock database with fake data in it?
> Thanks
> --
> Sincerely|||Frank,
I don't know if this will help or not, but what we have found that works
well is use stored procedures that return "fake" data; at least enough to
return data that will suffice for formatting, grouping, etc.
"Frank RS" <FrankRS@.discussions.microsoft.com> wrote in message
news:C2C3586F-FC2F-4476-B1F3-F74265142799@.microsoft.com...
> Hello, friends and gurus. May I have some advice on general approach you
> guys take to generate a mock database with fake data in it?
> Thanks
> --
> Sincerely

Gen Script - Include Role Permissions

I need to generate a script that includes the permissions set within a role
on various tables.
How?
KevinFrom the Generate SQL Scripts dialog, check the "Script object level
permissions" box on the Options tab.
"Kevin Evans" <kevin@.convenientcomputing.com> wrote in message
news:e3oK4eL2DHA.4060@.TK2MSFTNGP11.phx.gbl...

quote:

---

> I need to generate a script that includes the permissions set within a

---

role

quote:

---

> on various tables.
> How?
> Kevin
>

---

Gantt charts?

I have a table with start and end dates for useage of an asset and would
like to generate a sort of gantt chart for a date range. ie a horizontal
bar graph like Microsoft Project with the assests down the left-hand-side
and dates along the top.
Is this possible with SSRS? I feel like I have read about RS features that
would assist with this but can not now find an example.
Any ideas would be much appreciated.
cheers,
Paul.On Apr 28, 9:08 pm, Paul Ritchie <REMOVEpritc...@.xtraREMOVE.co.nz>
wrote:
> I have a table with start and end dates for useage of an asset and would
> like to generate a sort of gantt chart for a date range. ie a horizontal
> bar graph like Microsoft Project with the assests down the left-hand-side
> and dates along the top.
> Is this possible with SSRS? I feel like I have read about RS features that
> would assist with this but can not now find an example.
> Any ideas would be much appreciated.
> cheers,
> Paul.
I myself haven't done Gantt charts via SSRS: it seems to be a rare
topic. This company seems to have experience in this area:
http://www.randsmanagement.com/
I would suggest using a stacked bar chart to accomplish this.
Regards,
Enrique Martinez
Sr. Software Consultantsql

Function to Convert Amount to Words for Check Printing

I am thinking someone out there must have already developed this....

I am using Report Services to generate checks and need to convert the $ amount into words on the "Pay To" line.

I searched Google and found a couple of VB/ASP routines that do this, but I would need to do it via a SQL Proc since the reporter does not provide the capability to reference and/or call custom VB functions from within.

Does anyone have / know of SQL function that may be publicly available or are willing to share that does this or perhaps can suggest a better way to handle?

Thanks.

If you use SQL Server Reporting Services, then you could add VB Code functions and then use it in your Expressions.

Also you could create .NET Stored procedures/user defined functions and use it in you Transact-SQL code.

|||

It is absolutely amazing. Just by typing in 'sql function amount to words' into the Google? search bar, I got back dozens of hits, these look like good possibilities.

http://www.novicksoftware.com/udfofweek/Vol1/T-SQL-UDF-Volume-1-Number-46-NumberToWords.htm
http://www.devx.com/vb2themax/Tip/19053
http://code.filehungry.com/product/languages/sql/miscellaneous/123_tsql_functions

Google? is your friend...|||

Thanks. I figured out that even though the project explorer didn't list class as a new type of item which could be added, I could add a class to the reports project via the menu.

Appreciate your help,

Annette

|||

Funny how I did exactly the same Google search and didn't get the same results (or perhaps they were not listed on the first few pages I checked (there were 10 pages of results).

Google is definitely our friend and so are people like yourself who take the time to answer these posts.

Thank you,

Annette