So my site's main page display's applications for a PMP. Users can rate these apps with 'Like', 'Dislike', or 'Neutral/None' (every app is rated Neutral/None by default.) On the main page I wanted to list the games by the highest difference (So it would take the total Like's and Dislike's then add them together.) I'm having difficulty m...
Hi I have the following table with 10 unique rows, BookingID is a FK containing a random number. The number doesn't need to be in sequence. BookingID, Description 1000 Foo 3000 Bar 1500 Zoo I need to insert an sequential index called ID which goes from 1..x how do I do that in SQL Server 2005? I was thinking to wri...
I am not new to programming, but when it comes to databases, my concepts are messed up. I would like to know how to program in databases.. I am not sure which book to refer to ..and also I have to consolidate my concepts in databases. Any resource with good images, on joins, normalization would be of great help Is there any resource/ bo...
How does eBay end their auctions and mark the winner? Assume there is an auction end date in the database, once that time has passed the current time, the auction needs to be closed, mark the winner, etc. How is something like this handled in sql 2005? Do they query the db every second to find the expired auctions? Obviously they need to...
If you have the following tables and relations: A Product table A Price Point table (one or more prices for a product) A Version table (groups of products sold in the same area) and the constraint that only one product price can exist in any given version. How would you construct the tables to reflect the constraints? To illustrate ...
I have a collection of Obj's, I want to go through the collection, and set a property if a condition is true, so in normal world it would be: foreach (var o in obj) { if (o.SomeProperty == Something) { o.SomeOtherProperty = true; } } Anyway to do this, using Linq, to make it in a single line? ...
Note: I have not used Logparser before. Thanks in advance & appreciate your suggestions. ...
Hi guys I knew that you can develop customised code to generate pdf report via SQL Server Reporting Services (web services API). My question is: can you utilize the same mechanism to convert any HTML code into pdf file? My team lead wants me to convert html to pdf in this way to try to utilize the existing report services reference. ...
I want to use SQLite update query to update the database in iphone. Could anyone provide me with the code how to do that? ...
I've got a SQL query I fail to improve right now. It works, but it's a bit ugly. I want to fetch: an id from table A a name from table B using a WHERE clause which in itself fetches a value from another SQL query. I would like to replace the following two instances of this SQL query used for the WHERE clause, with one instance: SE...
i need to accept only Y/N for is_master variable declare below. For example if i use the below statement in SQL script the user can enter any character. I want to restrict user to enter only y Y n or N Accept is_master prompt ' Is the user a Master user (Y/N) : ' ...
Hi guys, I have about 50.000 of records to import in a Magento store. What I have already tested: The file is about 50 MB. Splitted files API Magento Classes Splitting the file doesn't improve the speed of the importing of the products. Api are very slow. Magento Classes are slow. This is a snipped of code using the Magento Classes...
My table is a dynamic one. E.g.: id SUBJECT 1 his 2 math 3 sci 4 opt 5 ENG 6 SOC The number of rows is not limited. There could be a hundred. I want output like this: ID 1 2 3 4 5 6 HIS MATH SCI OPT ENG SOC I could use a pivot query, but I would have to know the number of colum...
Thinking of building a nested category "system" using "chained strings" for lack of a better term. Here's the plan: A category slug could be something like "shopping-clothing-womans". This would correlate to a 3 deep category: Shopping > Clothing > Woman's. An object in the database would have a category field, containing the slug. Let...
So Im really wanting to do Database working as a job when I graduate. I've Gotten Books/CD's. Video Tutorials/Learning (Nuggets) and everything. I've had prior experience with MySQL for a Databases class and I absolutely LOVED it. Anyways I know there are 2 types, Database Admins and Database Devs. I assume the Admins manage them where...
$sql = "SELECT * FROM table"; $result = mysql_query($sql); while($row = mysql_fetch_row($result)){ // PRINT COLUMN NAMES WITH EMPTY VALUE } how can i do this? thanks ...
Hello, everybody. I know, that this topic has been discussed yet. But, unfortunately, I didn't find any solution in existing answers.So, I have the next code: public List<List<string>> DataTableParser(IQueryable<T> queriable) { //I missed the unnecessary code return queriable.Select(SelectProperties).ToList(); ...
I am gettting SQL time out error in my .net service. As the service is already installed on the production, is there any way I can increase the timeout for the service from App.Config file. At present, I am getting this exception after one minute, I have to make it to around 10 hours because the stored procedure we are using takes 2-2 ...
Hi all, I have a simple (hopefully) SQL question for you, any help would be much, much appreciated :). I have two tables which I would like to join. One Is Users, lets say it's called users One is a kind of history of that user, lets say its called users_history. The relationship of these two is a one users to many users_history rel...
how do one call a stored procedure that has date input . spName getDate() does not work. the question is about calling within ms sql managment studio. ...