SQL Server :: SQL Select IN "parse 30 Rows Randomly"
Mar 2, 2011
I am having a table which holds the following columns, questionID, subjectID, question I want to select 30 rows randomly. I am using the following query.
[Code]....
Its working fine. I have created as SP for that as follows,
[Code]....
Its parsing successfully. But when I am executing that SP by exec spTest '1,5,6' I am getting an error
[Code]....
how to resolve this. I want to parse that parameter(@subjects) as string(Combination of subjectID) only.
I have a database with images in it and now I want to randomly select an image from the database and view it on the aspx page.I know how to read images from a database depending on the id.Database I am using MS Sql and c# programming.
I have a problem in collapsiblepanelextender (CPE), prolong i am searching one, ie. i have four collapsiblepanel with four radiobuttons, i select ratiobutton in random if i select one other CPE must be collapse
i have a select statement which returns a column value.
id like to display the lowest column value there is, but if there are multiple rows with the same (and lowest) value id like it to be random which one of the rows is selected.. how would i do this? my select statement is currently:
SELECT TOP (1) url, ABS(r1 - @r1) + ABS(r2 - @r2) AS difference FROM type ORDER BY difference
this picks the one lowest result for me, but if there are multiple duplicate lowest results id like to select them, and show one at random..?
i want to select rows between 15 to 30 from sql server so i am writing this:SELECT uid, nname, nemail, ntelephone, naddress, ndate, uname, upassword, usertype, umonth, nregistration, regdate, paydetail, servicetype, serviceperiod,
I have one big DataTable with X rows. I want to select Y rows from it and bind them to a new ViewList. While doing it, I want to delete these rows from the DataTable (Having X - Y rows).
What is the best and fast way to do it?
I don't know if it is better to create a new DataTable to have the Y and after that bind them to a ViewList or something else?
I'm also looking for example in code how to select/delete rows from DataTable.
I came across a situation where a user selects no of rows from dropdown , depending upon the user input, automatically that no of editable rows should appear to input data...(maximum 8 rows only)
I have a gridview which right now is getting loaded with four pages of data. There are 50 rows per page. My problem is I need the "select all" button on my page to select 180 rows, not just the 50 on the page. This is my javascript:
Code: function sel() { var frm = document.forms[0]; isSelected = !isSelected; for (var i = 0; i < frm.elements.length; i++) { var e = frm.elements[i]; if (e.type == 'checkbox' && e.name.indexOf("ckSelected") > -1) e.checked = isSelected; } }
I am more a C# person than javascript, but I am deducing that I need something other than document.forms[0] to represent the entire gridview. Or perhaps, I can't do this in javascript at all. Do I need server code to run and set a session variable, then when the user clicks the button to do something with all his selected rows (it goes to a detail page), query that session variable to see if it's all rows instead of iterating through each gridview row individually to see if the checkbox is checked?
I have one table named 'dbo.ac_Products' Within this table there is a column named 'ProductId' There is also another table named 'dbo.ac_CatalogNodes' Within this table there is a column named 'CatalogNodeId' and a column named 'CatalogNodeType'
I need to delete all the rows from 'dbo.ac_Products' and 'dbo.ac_CatalogNodes' where 'ProductId' = 'CatalogNodeId' and 'CatalogNodeType' = 1
After use regular expression to get html code and put into string variable as :
dim s as string ="<table><tr><td>abc</td></tr>....................</table>
Number of rows in above table in s variable may changed,because i get html from other site. So i want to ask : have best way to continue parse rows in table which i get "abc" string.
my grid view contains a column having a text box. when i post back the page, i have to select all the rows where the value of each row's text box is > 0. how can i do it ?
Is there a way to select certain rows and for each row, perform a function? Specifically, I want to select specific rows and then send them an email.
Here's a breakdown:
1. Select * from STUDENTS where status = active 2. For each row that is returned, take the $email column and email the student message 3. Repeat until all qualifying rows have been completed.
How to select top n rows from a datatable/dataview in asp.net.currently I am using the following code by passing the table and number of rows to get the records but is there a better way.
public DataTable SelectTopDataRow(DataTable dt, int count)
{ DataTable dtn = dt.Clone(); for (int i = 0; i < count; i++) { dtn.ImportRow(dt.Rows[i]); } return dtn; }
I have a table in the db with one column containing a URL like http://site.com/users/*/profile.I am given a URL (like http://site.com/users/234/profile) and want to select all the rows in the db that match the url (in this case * is a wildcard).
I was thinking of using Regex to do this, by replacing the * with regex for any character. But am unsure as to what the SQL or LINQ code should be for the selection.
I want to select many rows from my SQL Server database and combine them in a certain manner. Currently, I've been using the following method to get these rows:
My query was SELECT ID FROM TBLCARS WHERE (ID IN (1, 5, 3, 6))
this will usualy produces the result 1,3,5,6 order.But i want the result in the specefied order of ids.ie:1,5,3,6;ie;first get the row with id 1,then with id 5,then id 3,and last 6.
I have a table with number a fields that repeat them selves ... then on submit saves to sessions to be used later on.I was to use a + and - button to enable and show more or less fields. So far i have an asp:table with a number of rows which are disabled and not visible.
When a user clicks +, i want it to disable the next hidden row. The easiest way i thought of doing this is with a select statement but i can't get it to work.This is what i have:
[Code]....
No matter how many times i click the button all i get is 1 as the value for noCreationRows.
I have an ASP.NET 3.5 website application using C# and SQL 2005 running on a web server. Now the application has the ability to create new aspx pages with content and the relative aspx.cs and design.cs pages needed on the fly and store them in the base directory on the server. Think of it as a crued Visual Studio website on the server for admin to click a few options on a page then the new pages are created for them without the need of a web developer. This all works fine and the code is working 100% (for the moment).
My problem now is the following: When i now navigate to this newly created page i get the following error - Parse Error : Could not load type 'Namespace.PageName'
I've looked into the reasoning and microsoft say "These errors occur if the .aspx page contains a reference to a code-behind module and if the application has not been built." Which now makes sense the application does not realise that these new pages are part of its system even though i can navigate to them.How do i get the system to recognise these new pages and rebuild itself accordingly?Now i cannot rebuild the system localy then reupload to the server, this needs to be accomplished on the server by the system, because the site cannot afford to have down time everytime admin decide to add new pages.
