I need some links which guide datetime in sql statement !!
Such as : I have a datetime column in my table , I need to calculate
the total orders in the today, or yesterday ...
Any one know ?
Thank you very much .
Hi! I am a beginner doing ETL processes, searching for a step by step detailed guide. Actually I could not map the columns, getting errormessages, and moreover I need to add sql.
I have "played" with DTS packages but I am now trying to do the following in an ActiveX VB script
Open a connection to database/table <---- Can't find how to do this! Read a record from the table Alter the content based on some rules Post the record back to the table
Simple eh? If anyone has any examples or can point me to a good source of examples.
I've gone through the Microsoft press study material for Exam 70-229. It is okay but not really comprehensive. I'd appreciate any supporting book that deals with the exam topics inside out... And info on any site which offers good practise exams is also appreciated.
Dear All, please provide me the complete installation guide links like on which operating system, which version can install like that... i've searched in google, but i'm not satisfied. please provide the link from experts side....
thank you very much
Vinod Even you learn 1%, Learn it with 100% confidence.
I am trying to do following thing:i got a table which contains some words....all i need to do is whenever i see a word starting with 'R', i need to remove the starting 'R' and update it in the same table... could anyone help me out here.....thanks a lot in advance.........
Hello room, I am newbie to Database mirroring. I have 3 window server 2003 running in window virtual server 2005. Server1 of sql 2005 instance: -- SQLDev01 Server2 of sql 2005 instance: -- SQLDev02 Serve3 of sql 2005 instance: -- SQLDev03 The servers are running on DC and the sql servers was setup with Window authentication mode only. Also, All the sql instances'services are running under single domain user name. e.g: sqladmin.
I have tried to setup manually and t-sql and both running into some issues. Can anyone help and share t-sript to setup database mirroring.? Thanks for the help. TJ
Hey forum...i'm a newbie to SQL, but not IT. However I'm or a network admin than a database admin...so this is completely new.
All i'm trying to do is setup one single database for my mail server to use for grey listing entries. it is using Access right now, and i want to setup a SQL Express database and DSN for it to use.
Does anyone have a good pointer for beginning SQL people?
The overly complex MSDN library is proving virtually useless to me. To give you some background, I've programmed PHP / MYSQL websites, in-depth VBA programs for Excel and a bit of non-database work in various languages - I'm an amateur.
I've just bought a new PC (2g Ram, Core 2 Duo, Vista Home Basic) and would like to run Web Developer Exp, VB Exp and SQL Server 05 Exp.
Note. I have installed all three and run through Microsoft's video tutorial, until I hit a snag at the start of Tutorial 2. When try to create a new SQL Database in WebDev, an error saying either SQL Server is not installed or operating correctly (could Microsoft provide a more specific error or what????)
The questions Microsoft need to answer are:
1. What are the hardware requirements for SQL Server 05?
2. What are the operating system requirements for SQL Server 05?
3. What does IIS have to do with SQL Server 05?
4. How do you know if you meet the IIS requirements for running SQL Server 05?
5. Exactly what elements of SQL Server 05 are affected by different levels of IIS?
6. Can anti-virus or firewall software cause issues.
I have a table which contains all the transaction details for which I am trying to create a CUBE... The explanation below in brackets is only for clarity about each field. Kindly note that I am using the following table as my fact table. Let's call it tblFact
This table contains fields like transaction date, Product (which is sold), Product Family (to which the Product Belongs), Brand (of the product), Qty sold, Unit Price (at which each unit was sold), and some other fields.
I have created a Product dimension based on tblFact. I don't know if this is a good idea or not :confused: Is it okay and am I on the right track or should I base my Product Dimension on some other table (say tblProducts and then in the Cube editor link tblProducts with tblFact based on the ProductID field? Please guide.
Now coming to my last question: Currently I am also creating my Time Dimension based on tblFact. Is this also a wrong approach? 1. Should I instead create the Time Dimension based on a different table (say tblTime) and again link up tblTime and tblFact in the Cube editor?
2. if yes, then how do I create tblTime from tblFact in a manner that it only contains all the transaction dates.
3. Assuming that I should take the tblTime approach, then should this table (tblTime) also contain the ProductID - representing the Product which was sold for each date in tblTime?
I realize that this is a lenghty post but reply and more importantly guidance from the experienced users will be greatly appreciated becuase I have recently started learning/playing around on the OLAP side of things and I know that this is the time that I get my foundations correct otherwise I'll end up getting used to some bad practice and will find it difficult to change my approach to cube designing later down the road.
So many thanks in advance and I eagerly look forward to reply from someone.
Please point me towards some good trusted (possibly economical) Data Conversion tools for converting legacy system SQL 2000 (XML, Image all data type) db data to SQL 2005 database (and possibly to Oracle too) in a totally different db schema/structure.
I'm new to DB Mirroring, and I am trying to get it going in a test enviroment between two SQL 2005 Dev Servers. I have followed documentation that I have found but cannot get past a 1418 error when establishing a connection between the servers initially. Does anyone know of any good step by step guides that I could look at, in case I have missed something stupid.
Would please any here give me any advices for where can I find the SQL Server 2005 Integration Services Installation Guide? The one I found online (http://msdn2.microsoft.com/en-us/library/ms143506.aspx) is just confused me, which is just about the installation of SQL Server 2005 different version.
In sp_create_plan_guide documentation, it's written:
When SQL Server matches the value of statement_text to batch_text and @parameter_name data_type [,...n ], or if @type = 'OBJECT', to the text of the corresponding query inside object_name, the following string elements are not considered:
White space characters (tabs, spaces, carriage returns, or line feeds) inside the string. Comments (-- or /* */). Trailing semicolons
On SQL Server 2008 SP3, I created a plan guide for a query. Now, if I execute the query exactly how it was defined in the plan guide, SQL Server match it and use the plan guide to optimize the query.
However, if I add just a space between a column name and an operator in the WHERE clause, the plan guide is ignored. How come it doesn't ignore the extra space, like mentioned in the documentation?
How do you make a live link in SQL 7 to another database? I currently do such things in Access 97 but how do you do it in SQL? I just want to keep a permanent live link to a table in another database.
I am new to SQL Server Development. I will be working on a project which requires a good understanding of SSIS. What are the usual scenarios or tasks I will be given when working on SSIS? Please help!!
Is there a way of searching tables and linking to the relationship used.
I need to find a list of tutors and the session they teach (both available in a session table)
i then need to find the list of members that are enrolled onto each session.
In the session table the relationship allows me to view what members are on each session but i cannot find a code that allows me to see what tutors teach what session and what members attend these lessons.
I spoke to my tutor who did not offer too much help but did say it may be possible to use the "AND" function
Have good grasp of mdb's. Beginner with sqlHave sql db of charity organisations with contact details, all fairlysimple. Have one Field for web addresses entered www.xxxxx.co.uk anotherfor emails entered aaaa@bbbb. Unable to work out how to make these active.Its certainly not like mdb's!Created Page with dropdown list which when clicked gives details ofselected charity. Want the above 2 entries 'live'.Any help from the collective intelligence would be gratefully received.Graham
I downloaded and registered Visual Studio Express Edition. I got this nice email back with links to demos, tutorials, and starter kits. Unfortunately, the links to most of the starter kits are broken. Can I still get these things?
hi, i have headers at the top of my list and would like for people to click the pubs link and it orders the pubs alphabetically descending and when they click again to ascend also to do this with towns and addresses and postcodes?!