How best to alter a SQL SELECT statment's field list to a COUNT(*) using PHP? e.g SELECT blah, blah, blah FROM tbl_blah WHERE blah; to SELECT COUNT(*) FROM tbl_blah WHERE blah I have considered mysql_num_rows... but I am pretty sure it would be more efficient to edit the statement. I am guessing it could be solved with a regex expr...
From what I gather about the IN expression, this should work: DECLARE @list varchar(255) SET @list = '''Item1'',''Item2''' SELECT * FROM Table WHERE Item IN (@list) And it should select those items in @list. The items exist in the table. If I execute the query separately for Item1 and Item2 (Item = Item1, then Item = Item2)...
How do i list all tables in a schema in Oracle SQL? ...
I'm trying to write a sql statement which returns bad rows from my table. I have a table with rows: Key | Date | Indicator 1 | 10/10/08 | SE 1 | 10/11/09 | CB 1 | 10/12/09 | CE 1 | 10/13/09 | TR 2 | 1/1/09 | SE 3 | 10/10/08 | SE 3 | 10/13/09 | CE 3 | 10/15/09 | SL So what I want returned would be all rows where a key has an in...
I have a table, a simple table, only has 3 fields. ID Type Date Example of Data (recordset showing 3 of 300) 154 | page | 2010-02-08 154 | link | 2010-02-08 154 | form | 2010-02-08 Id: just an id for a client Type: can only be 3 things that are already populated ('form','page','link') Date: just the date it was cr...
Hello I want to generate a Unique Random number with out using the follow statement : Convert(int, (CHECKSUM(NEWID()))*100000) AS [ITEM] Cause when I use joins clauses on "from" it generates double registers by using NEWID() Im using SQL Server 2000 *PD : When I use Rand() it probably repeat on probability 1 of 100000000 but this ...
I have a site using the asp.net membership schema. I'd like to set up a trigger on the aspnet_users table that inserted the user_id and the user_name of the new row into another table. How do I go about getting the values from the last insert? I can select by the last date_created but that seems smelly. Is there a better way? ...
DB: SQL Server 2005 We have a table that has data in this manner: Project Year Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov ...
I would like to create a stored procedure that takes in a string of comma separated values like this "1,2,3,4", and break it apart and use those numbers to run a query on a different table. so in the same stored procedure it would do something like select somefield from sometable where somefield = 1 select somefield from sometable wher...
Question in short: How tot do this in MVC.NET? Question in long version: Im trying to use a DateTime column in a SQL Table for version tracking (this in itself is proposed as a solution to re-attaching a Linq2Sql data class after being passedback by a editview for the table) But now i get 'row not found or changed'-exception. on the ...
Have the following Stored procedure for a search form. I use Linq and have problem to get the result of this procedure....am I in the wrong way in procedure or in linq? You can see my linq down here too..I have tried different ways..but now i need your help :) ALTER PROCEDURE [dbo].[SearchPostit] ( @message varchar(1000)='', @write...
I need to somehow put these two queries into one query: 1 select fac_name, datename(month,b.startdt) as 'month', year(b.startdt) as 'year', count(a.empfk) as '#filled' from tbl_tmx_attempt a left outer join tbl_tmx_activity b on a.activityfk = b.activity_pk left outer join tbl_tmx_actloc c on b.activity_pk = c.activityfk left o...
I've got a query that looks like this: select a.title, is.filename from articles a join article_images ai on ai.article_id = a.article_id join images i on i.image_id = ai.image_id join image_sizes is on is.image_id = i.image_id where is.size_name = '96x96'; So there is an N:N relationship between articles and images, and an N...
I am working on a contest site where there are two types of users, normal site members, and judges. Each can use a drag and drop tool to order the entries in a particular contest in the order they choose. When they are done the relevant entry ids are attached a ranking value that can then be used to determine which entry in contest got t...
Hoping some of you mysql experts can help me out. I have searchtag data that is stored in a nested set. TABLE searchTags searchTagID searchTag lft rgt (I am using nested sets because there are times when I need to easily select entire branches of the tree.) I would like to construct a query that will return a resultset of nodes ...
For instance, the way we're doing it now is like thus: (in the web.config) <location path="somePath"> <system.web> <authorization> <allow roles="approvedRoles"/> <deny users="*"/> </authorization> </system.web> </location> And what I would like to do instead is to store this information in SQL somewhere so that we can mani...
I have a some questions about local and service-based databases: Does using a service-based database require the user to have SQL Server installed? If so, is there ANY way around it? Does a local database require the user to have SQL Server installed? What is the difference between a local database and a service-based database. (I am tal...
I have a dataset that looks like this: Account Cost Centre TransNo aaa 111 43443 aaa 111 32112 aaa 111 43211 aaa 112 32232 aaa 113 56544 bbb 222 43222 bbb 222 98332 ccc 111 88778 I need a column added that is a counter of the numbe...
WARN NHibernate.Util.ADOExceptionReporter - System.Data.SqlClient.SqlException: Invalid object name 'X'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Ru...
Using SQL Server 2005, I'd like to run a stored procedure and insert all of the results into a new table. I'd like the new table to have its columns automatically configured based upon the data returned by the stored procedure. I am familiar with using the SELECT ... INTO syntax: SELECT * INTO newtable FROM oldtable Is this possibl...