January 29, 2013 at 3:11 pm
Hi,
Not sure if I am explaining this correctly..
But what I want to do is create a "My" table on a reporting server with existing data to do less linking..
example I call it my_clients conation client name(concat(last,First) sex dob, eye color etc.......
I then want to run a job nightly to update it..
If someone can point me in a direction to read about I'd really appreciate it
Thanks
Joe
January 29, 2013 at 3:50 pm
*scratches head* This seems like standard ETL and warehouse work. Are you looking to know the keywords to reseach on? I'm not sure what you're looking for here.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 29, 2013 at 3:59 pm
yes keywords etcc..
I did write a small view then created a job then creates a table from the view
Since its a report server I can run the job overnight to update the table?
Cheezy way of doing it?
January 29, 2013 at 4:20 pm
jbalbo (1/29/2013)
yes keywords etcc..I did write a small view then created a job then creates a table from the view
Since its a report server I can run the job overnight to update the table?
Cheezy way of doing it?
Nah, pretty standard for small datasets, though I personally would probably build it in SSIS simply due to comfort levels.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply