sql

MOSS 2007: What is the source of "Directories"?

Hello all, I'm trying to generate a new SharePoint list item directly using SQL server. What's stopping me is damn tp_DirName column. I have no ideas how to create this value. Just for instance, I have selected all tasks from AllUserData, and there are possible values for the column: 'MySite/Lists/Task', 'Lists/Task' and even 'MySite/L...

How the stored procedure truncate the datetime value

I have a table A which contains a column called LastStartTime with datetime type and I have a store procedure sp_XX which is used to query the table's value following is the content of sp: SELECT upper(cast(Id as nvarchar(36))) as 'Id', [Name], [Description], LastStartTime, FROM A RETURN Here is the related code publi...

SQL CE and C# Application

There is a project I'm off to start and thinking of using SQL CE to keep resources small and anyway the data would be simple enough. I was thinking and "heard" that there is a way that u can make your app play with SQL CE without installing the runtime, with adding some dlls and voila. I would like to start using EF4 so it would be EF4...

2 Right Outer Join in SQL Statement

Hi, I have an issue in understanding a very simple yet interesting query concerning 2 right outer joins with 'non-sequential' on-expressions. Here is the query: select * from C right outer join A on A.F1 = C.F1 right outer join B on B.F1 = C.F1; Here are the tables: create table A ( F1 varchar(200)); create table B ( F1 varchar(...

ADODB Getting the column count

Hi, I was reading through our code base at my company and I saw something that seemed like it could be done better. $dbRow = $dbh->Execute("SELECT * FROM database.table LIMIT 1"); $tableColumnCount = $dbRow->_numOfFields; Is this the only way to get a column count using ADODB? It just seems silly to have to execute a query so you can...

passing an comma delineated list to a custom wordpress query

Ok, so here's what is going on... I am pulling a list of the most popular post titles from Google Analytics and I'm placing them in an array $thisnumber = 0; $start = date('Y-m-d', (time() - (60 * 60 * 24 * 30))); $end = date('Y-m-d'); $limit = $getnumber; $titles = array(); $login = new GADWidgetData(); $ga = new GALib($login->auth_...

Is there a max number of entries per table for SQLiteDatabase Content Provider

Hi, I have an Android app that has a Content Provider with an SQLiteDatabase implementation. I have 1 db that has 3 tables. I noticed that my tables don't get any new row inserted after i reach index number 1000. This limit is unique for each table. So if i have table_a, table_b, table_c, then if table_a row entries max out at 1000, t...

using NOT LIKE for paranthesis

here is my expression: =([Panels] not Like '*IT_AMPH,*' and [Panels] not Like '*AMPH_SN,*' and [Panels] not Like '*AMPH_S,*') can i say this instead: = not ([Panels] Like '*IT_AMPH,*' Or [Panels] Like '*AMPH_SN,*' Or [Panels] Like '*AMPH_S,*') are these expressions the same? *i need to mention that my question is not about logic i...

MySQL Subquery is failing on MySQL 4.0 with invalid syntax error

I'm running a pretty basic subquery on MySQL 4.0.30. My goal is to get the user permissions from the mysql.user table for any user with grants on a specific database, as noted in the mysql.db table. The query looks like this: mysql> select * from mysql.user where User IN (select User from mysql.db where Db='db_name')\G As you can...

count() query taking more than 20 seconds

Table_a = 7022536 rows Table_b (GTT) = 5601 rows Query: SELECT COUNT (a.ssn_head) FROM table_a a, table_b b WHERE b.hoh = a.head AND a.flag = 'Y'; takes 20+ seconds to bring 17214 records. Explain plan is: Plan hash value: 1901401324 -------------------------------------------------------------------------------- | Id |...

Visual Studio 2008

A while ago, i did a little course about the 3.5 framework. There a mechanism in VS2008 to keep track of the users logged, their roles..., and there are some sql files that create the tables' structure needed to keep track of users, roles..., and this files are installed in the during the instalation of vs2008, but I cannot find it. Can ...

SQL Count function

I'm a student this is part of a homework assignment. Thanks for any advice. I have 2 tables. Employee has a column last_name, Job_title has a exempt_non_exempt column it's data type is bit. 0 for hourly 1 for salary The primary key and foreign key is job_title for both tables. I need to find out How many employees are salaried and how...

SQL server database design question

I have a Users table and a Totals table which has an integer field for the total number of users. I thought about writing a console app that counts the Users table and then updates the Totals table. And then make a Task scheduler events that executes this app every 10 minutes. Is there a more elegant way to do this? ...

How do I get first name and last name as whole name in a MYSQL query?

I want to be able to do something like this SELECT `first_name` + " " + `last_name` as `whole_name` FROM `users` So basically I get one column back whole_name which is first_name and last_name concatenated together with a (space). How do I do that in SQL, or more specifically, MySQL ? Thanks ...

SQL: Single select query from 2 Non-Joining tables

I have 2 tables which doesn't have any references to each other and I'm trying to create a third table (for reference lookup) by selecting from fields from both tables. TableA has an A_ID TableB has a B_ID I want to create Table C which has a 1 to 1 reference between A_ID to B_ID where A_ID = FirstID and B_ID = SecondID, I can't join ...

sql join within join?

I need your help building a SQL statement I can't wrap my head around. In a database, I have four tables - files, folders, folders_files and links. I have many files. One of them is called "myFile.txt". I have many folders. "myFile.txt" is in some of them. The first folder it appears in is called "firstFolder". I have many links to m...

How to prevent null values for table-valued function parameters?

I have a TSQL Table-Valued Function and it is complex. I want to ensure that one of the parameters cannot be null. Yet, when I specify NOT NULL after my parameter declaration I am presented with SQL errors. Is it possible to prevent a parameter of a Table-Valued Function to be assigned null by the calling SQL? ...

how to get certain numbers

Hi Guys, I have a column in excel which is exported from a sql database. The columns read like this: 'Payment Funds: (654321) Company charged Public - Payment of transfer. Charged from account xyz to abc (into autopac agent).' The reference number: 654321, account: xyz and abc; comment: (into autopac agent) - are different for all ...

SQL - select first in value set by priority?

I'm fairly inexperienced in SQL and this seems like it must be an easy task, but I'm not sure how to go about it. Basically I want to select a single row from table A where field "someField" is in a pre-determined set "someSet", but I want it to look for each value in the set individually. For example, let's say "someSet" contains 5, 6,...

SQL Join Types and Performance: Cross vs Inner

So, I've been seeing a lot of SQL examples on this site. I have a question about the relative performance of inner joins (plain JOIN) and cross joins (SELECT foo FROM bar,baz WHERE). Turns out the question has already been asked: http://stackoverflow.com/questions/1018822/inner-join-versus-where-clause-any-difference But I still have...