Originally posted by Grinder
View Post
- Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
- Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!
Collapse
You are not logged in or you do not have permission to access this page. This could be due to one of several reasons:
- You are not logged in. If you are already registered, fill in the form below to log in, or follow the "Sign Up" link to register a new account.
- You may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
- If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.
Logging in...
Previously on "Resources for Learning elements of MS SQL server"
Collapse
-
-
No, don't use Access for the db, use the SQL Server db, but connect from Access using ODBC & bring down the minimal set of results to Access.
Leave a comment:
-
Originally posted by lilelvis2000 View PostAccess? I mean how much are we talking about here and who are the end users? Just yourself or a department or business. Would they mind getting Access snapshot reports or do they want web front end?
I will be the only user. The db will generate a report I present.
Leave a comment:
-
Originally posted by ThomasSoerensen View PostNot a daily task but an regular one. Performed after loading the tables with new data.
So every time I use the db I will: populate tables with data, execute all views in sequence, generate a report, store results for statistics in some tables.
Access? I mean how much are we talking about here and who are the end users? Just yourself or a department or business. Would they mind getting Access snapshot reports or do they want web front end?
Leave a comment:
-
Originally posted by jmo21 View PostYou haven't said what you are trying to accomplish.
Is this just some kind of daily task that will manipulate data?
stick it all in a stored proc and schedule it using a Sql Server task.
You mentioned reports?
You can create a SSRS report that calls a stored proc, and displays the output.
This can be exposed on the internet/intranet pretty easily, or you can set it up so that the output report is emailed, or dropped to a file share
Never used SSRS - does it have wizards?
Leave a comment:
-
Originally posted by ThomasSoerensen View PostI am not an experienced programmer.
Leave a comment:
-
take a look at Sql Server Integration services as well.
it may be overkill for what you are wanting to however.
Leave a comment:
-
Originally posted by jmo21 View PostYou haven't said what you are trying to accomplish.
Is this just some kind of daily task that will manipulate data?
stick it all in a stored proc and schedule it using a Sql Server task.
You mentioned reports?
You can create a SSRS report that calls a stored proc, and displays the output.
This can be exposed on the internet/intranet pretty easily, or you can set it up so that the output report is emailed, or dropped to a file share
So every time I use the db I will: populate tables with data, execute all views in sequence, generate a report, store results for statistics in some tables.
Leave a comment:
-
You haven't said what you are trying to accomplish.
Is this just some kind of daily task that will manipulate data?
stick it all in a stored proc and schedule it using a Sql Server task.
You mentioned reports?
You can create a SSRS report that calls a stored proc, and displays the output.
This can be exposed on the internet/intranet pretty easily, or you can set it up so that the output report is emailed, or dropped to a file share
Leave a comment:
-
As I am going to be the only user, is there a need for a front end? Can't I just work in the SQL MANAGEMENT Center?
Leave a comment:
-
Ok, will a query window will do for now before you write an application.
Sounds like you might want to use temporary tables, or table variables to store data as you go.
Leave a comment:
-
Originally posted by jmo21 View PostAs for your app requirements, I'm not sure what you are meaning by view, as a view is a well defined "thing" in Sql Server.
I know, I meant view in the sense of the "well defined thing"
A query produces a result set (you are calling it a view).
A View in a Sql Server is like a saved query.
I agree
Ie. basic query select x, y, z from Table1
can be saved as a View called View1 for example.
then you can write a query in the form.
Select * from View1 which will give you exactly the same result as your original query.
There are many reasons for this that you can look up.
"how to trigger the execution of the views in a sequence"
Assuming you mean queries, you can call them one by one in your code, or one by one in a stored proc.
At the moment I do not have any front-end/gui code - I plan on using the db from SQL Management Center - I will be the only one on the db
"how to store the result of each view in a more permanent way than just in the output screen of the view - in a new table? in many new tables? what are the options"
they are already in tables, so the first question is why do you want to store them somewhere else? do you need? why can't you just run the query again?
But of course, there is a facility to do that, look up "Select Into" statements.
My queries, stored in view are quite complex and work on a lot of data so 1 query easily takes a few minutes to produce the result. That is why I want to store the result and run other queries against that result - I think if I nest queries/views too much I will perform the same query endless times where actually only 1 time is needed
"reporting capabilities"
look up Sql Server Reporting Services for a starter. There are other reporting packages that can hook up to Sql Server as well.
Leave a comment:
-
As for your app requirements, I'm not sure what you are meaning by view, as a view is a well defined "thing" in Sql Server.
A query produces a result set (you are calling it a view).
A View in a Sql Server is like a saved query.
Ie. basic query select x, y, z from Table1
can be saved as a View called View1 for example.
then you can write a query in the form.
Select * from View1 which will give you exactly the same result as your original query.
There are many reasons for this that you can look up.
"how to trigger the execution of the views in a sequence"
Assuming you mean queries, you can call them one by one in your code, or one by one in a stored proc.
"how to store the result of each view in a more permanent way than just in the output screen of the view - in a new table? in many new tables? what are the options"
they are already in tables, so the first question is why do you want to store them somewhere else? do you need? why can't you just run the query again?
But of course, there is a facility to do that, look up "Select Into" statements.
"reporting capabilities"
look up Sql Server Reporting Services for a starter. There are other reporting packages that can hook up to Sql Server as well.
Leave a comment:
-
Originally posted by AtW View PostI find that best way to learn is to take some real life project and work on it while using reference guides to find out how to do particular things on that particular system: if you are an experienced programmer then all you need is a good reference and test system.
Leave a comment:
- Home
- News & Features
- First Timers
- IR35 / S660 / BN66
- Employee Benefit Trusts
- Agency Workers Regulations
- MSC Legislation
- Limited Companies
- Dividends
- Umbrella Company
- VAT / Flat Rate VAT
- Job News & Guides
- Money News & Guides
- Guide to Contracts
- Successful Contracting
- Contracting Overseas
- Contractor Calculators
- MVL
- Contractor Expenses
Advertisers
Contractor Services
CUK News
- Streamline Your Retirement with iSIPP: A Solution for Contractor Pensions Sep 1 09:13
- Making the most of pension lump sums: overview for contractors Sep 1 08:36
- Umbrella company tribunal cases are opening up; are your wages subject to unlawful deductions, too? Aug 31 08:38
- Contractors, relabelling 'labour' as 'services' to appear 'fully contracted out' won't dupe IR35 inspectors Aug 31 08:30
- How often does HMRC check tax returns? Aug 30 08:27
- Work-life balance as an IT contractor: 5 top tips from a tech recruiter Aug 30 08:20
- Autumn Statement 2023 tipped to prioritise mental health, in a boost for UK workplaces Aug 29 08:33
- Final reminder for contractors to respond to the umbrella consultation (closing today) Aug 29 08:09
- Top 5 most in demand cyber security contract roles Aug 25 08:38
- Changes to the right to request flexible working are incoming, but how will contractors be affected? Aug 24 08:25
Leave a comment: