I’m trying to get my head around a query and I just can’t figure it out. I would appreciate if someone give me a pointer. As a simple example of what I’m trying to achieve, I have these records in the …
Tag: sql
Change a Nullable column to NOT NULL with Default Value
I came across an old table today with a datetime column called ‘Created’ which allows nulls. Now, I’d want to change this so that it is NOT NULL, and also include a constraint to add in a default …
Make DataBase portable
I’m developing a local application with a DataBase in SQL Server 2008 and Visual Studio, C#, I created and connected to the Database in the application, but when I pass to work to another computer, copy the all solution files, the information that had been saved in it doesn’t exist, actually the e…
Can I use non-aggregate columns with group by?
You cannot (should not) put non-aggregates in the SELECT line of a GROUP BY query. I would however like access the one of the non-aggregates associated with the max. In plain english, I want a table …
Statistics on Query Time (PostgreSQL)
I have a table with a billion rows and I would like to determine the average time and standard deviation of time for several queries of the form: I have a thousand random values for col1 stored in another table. Is there some way to store how long each of these queries took (in milliseconds) in a separate tab…
SQL query to select where A=’foo’ and where (A=’bar’ and B=’baz’)
I’ve got the next SQL query: SELECT FIRST_NAME, LAST_NAME FROM MYTABLE WHERE STATUS = 1 AND VARIABLE IN ( ‘PR’, ‘AR’ ) AND SPECIAL = 1; SPECIAL is an additional condition which is added if I …
select from access database file and insert to sql Database
I have an access database file (test.mdb) and I need to write a stored procedure which will select some records from tblTest in test.mdb and insert them into tbsqlTest in my sql database . ==> I need a SP like this : Answer If you’re willing to permit Ad Hoc Distributed Queries on your SQL Server, yo…
insert char into string at multiple positions sql
how would i like to convert accounting GL number 99999999999999999 to 999-99999-99-9999.999 in a query to MSSQL server 2005 i dont need to update the data, just have the STRING be converted on …
named pipe problem using php to connect ot ms sql 2008
I’m am getting a named pipes error when I try to connect to ms sql server 2008 using a php script running an sqlsrv_connect command. In the ms sql configuration stuff tcp/ip, shared memory, and named pipes are all enabled. Everything is stored on the same server, the database, and the php script so I…
Is a Union Query needed
I need a little help writing a query. I have this data… I need to query the data and have an output something like this The idea here is to select the direction, the LowNum and then the nextNumber. Also when the direction changes to start over. (That’s why I think I need a Union, maybe get the Nor…