I'm building a report in Reporting Services 2005 based on a SSAS 2005 cube. The basic idea of the report is that they want to see sales for this fiscal year to date vs. last year sales year to date. It sounds simple, but being that this is my first "real" report based on SSAS, I'm having a hell of a time. First, how would one calculat...
I am trying to rename a field in my database through SQLite.net and am getting a syntax error. My SQL that I have tested is: UPDATE candy SET name="Godiva" WHERE name="Sees"; and that works fine. I am using an SQLiteCommand with a CommandText of: UPDATE candy SET @field_name=@new_name WHERE @field_name=@old_name; and my code snipp...
Hi, I've another question I wish to sort a list of IP address. Are there any functions in Postgresql to use with the order by like INET_ATON in MySql ? My current IP is on string format. Thx. Narglix ...
I am working on a project that requires me to hop into to separate DB's. So I have figured that I need to have multiple functions inside of my VB page. The only problem I am having,is I am not to sure how to get this all accomplished. So far I have figured out the overall structure, just need help implementing that structure. Here is...
I manage a research database with Ruby on Rails. The data that is entered is primarily used by scientists who prefer to have all the relevant information for a study in one single massive table for use in their statistics software of choice. I'm currently presenting it as CSV, as it's very straightforward to do and compatible with the ...
Hello, I've got a database with video ids and N keywords for each video. I made a table with 1 video ID and 1 keyword ID in each row. What's the easiest way to order keywords by frequency? I mean to extract the number of times a keyword is used and order them. Is it possible to do that with sql or do I need to use php arrays? Thank...
Considering below tables and relationships: parent --1:Many-- children --1:Many-- subchildren Parent may or many not have children records. children always have subchildren records. I want to write a query to select parent names where any if matched parent.name,children.name or subchildren.name. Here I understand I have to do a ...
I'm creating a sql select query for an access database, and receiving a circular reference error, because my alias name is the same as a column name in my expression. Here is the fragment of my query: switch([CULET]='N','NONE', [CULET]='S', 'SMALL',[CULET]='VS','VERY SMALL', [CULET]='SL',' ',[CULET]='MD',' ') AS [Culet] This specif...
My current method is this: SELECT TOP 1 ID FROM DATAENTRY ORDER BY ID DESC This assumes the latest inserted item always has the highest unique ID (primary key, autoincrementing). Something smells wrong here. Alternatives? ...
This is about as beginner as it gets regarding AJAX, but here it goes. I want to have one checkbox somewhere on an ASP.NET web form (ASPX). When the user clicks the checkbox, I want one of those spinning indicators to show. While that spinning indicator is showing, I want an update operation to occur in the database to reflect that th...
I'm somewhat new to SQL and need help with query syntax. My issue involves 2 tables within a larger multi-table join under Transact-SQL (MS SQL Server 2000 Query Analyzer) I have ACCOUNTS and LOGINS, which are joined on 2 fields: Site & Subset. Both tables may have multiple rows for each Site/Subset combination. ACCOUNTS: ...
I am creating a sql query for an access database that will be exported to a text file. The requirements include a line feed separating each line. Does that happen by default, or its something that I need to add in? If I need to add it, how do I do that? TIA ...
Hi Based on the following table ID Effort Name ------------------------- 1 1 A 2 1 A 3 8 A 4 10 B 5 4 B 6 1 B 7 10 C 8 3 C 9 30 C I want to check if the total effort against a name is...
I recognized that calling a method on an Oracle Object Type takes longer when the instance gets bigger. The code below just adds rows to a collection stored in the Object Type and calls the empty dummy-procedure in the loop. Calls are taking longer when more rows are in the collection. When I just remove the call to dummy, performance ...
The following is not working :( Select @CurrentTableName = TableName from @tempTableNames Where ID = @ID Select @NumberOfColumns = SELECT count(*) FROM information_schema.columns WHERE table_name = @CurrentTableName Select @SqlStmt = 'SELECT count(*) FROM ' + @CurrentTableName Select @NumberOfRwos = exec @SqlStmt ...
suppose I have tables Employee, Locations. and I have a view viewEmpLocation which is made by joining Employee and Locations. Now If I update the view, will data in original table get updated. ...
I have no problem with converting ER to SQL tables, but I don't know how can I convert EER to SQL tables? as you Know that EER has "is a" specification and inheritance, but I don't know how relational databases can connect with inheritance specification ...
I have a question relating to databases and at what point is worth diving into one. I am primarily an embedded engineer, but I am writing an application using Qt to interface with our controller. We are at an odd point where we have enough data that it would be feasible to implement a database (around 700+ items and growing) to manage...
When I query for only one record/row, sqldatareader is giving correct result but when i query for multiple rows, its giving error on the client side. below is my code. please tell me what is the problem here. [WebMethod] public static string SendMessage(string order) { string Server = "alyeyey"; string...
I always take precautions regarding SQL INJECTION ATTACKS when data is saved between someone's iPhone and a remote database on the cloud. But is it also necessary to do the same... when just saving data (using sqlite) from someone's cell phone, to a database that's just on their own phone? What's the worse they can do? Delete their ow...