|
|
|
July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
SQL Server 2000 on XP Posted by Rajani at 10/29/2004 7:23:02 PM Hello,
Can i install SQL server 2000 on XP Prof? is there any seperate version
for XP Prof?
Where can i get Free SQL Server 2000 book in PDF foramt. I cannot able to
purchase books. I cannot bare.
Thank You ...more >>
IIF in SQL server Posted by MichaelK at 10/27/2004 12:51:12 PM Is there a way in SQL Server to run the simple query
having something like IIF function in Access.
Similar to this easy query.
SELECT Mobile,iif([PlanType]=1, "New", "Upgrade") As Type FROM Acts WHERE
(RepId = 2194)
Thanks,
Michael
...more >>
Get the smallest timespan between two entries Posted by mike at 10/27/2004 3:49:07 AM Hi all,
we have a table with a column of type "datetime"
We want to get the smallest timespan between two entries.
Now we get this timespan with the following query (it works but it's to
slow, it runs 5 secs with 250000 entries):
select min(Datediff(minute,a.rectime,b.rectime))
from ...more >>
& in the where clause Posted by JIM.H. at 10/22/2004 5:09:06 AM Hello,
SELECT discounts.*, discounttype AS Expr1
FROM discounts
WHERE (discounttype = 'Initial & Customer')
This query in pub database does not bring anything because of ‘&’ in where
clause. How can I get this working without removing & in the table?
Thanks,
Jim.
...more >>
Sum a Union Query Posted by news.microsoft.com at 10/21/2004 3:55:50 PM Hi
I have data in 3 tables that I want to add together to get a total figure
So far I have an sp that uses a union query that gives me 3 totals (1 from
each table)
How can I now add these 3 totals together? is it a subquery of somesorts or
do I have to make a temp table of the union quer...more >>
Update Question Posted by John at 10/18/2004 12:47:03 PM can you update date a column with an if then statement. This is a simple
example and I want to do something more complex, but I can't figure out how
to do this simple example. can someone help?
update car set field1 = (if (select passengers from car where id=1)='3' begin
'2'
end)...more >>
Problem doing a count query using 2 tables Posted by chazz at 10/17/2004 8:01:03 AM I've got one table that holds various information fields and a field for the
city, and another table that holds city and state (and zip, etc). I want to
query both tables to show the number of states for which records in the first
table were submitted. Problem is that although I can query a ...more >>
Problem doing a count query using 2 tables Posted by chazz at 10/16/2004 1:43:02 PM I've got one table that holds various information fields and a field for the
city, and another table that holds city and state (and zip, etc). I want to
query both tables to show the number of states for which records in the first
table were submitted. Problem is that although I can query a ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SQL 2000 fails to detect NULL values Posted by Yaocuauhtzin at 10/6/2004 2:11:01 PM I have this query in SQL 2000, I get wrong answer
SELECT B.ID, ISNULL(B.ID,'Is Null')
FROM secuenciales A
LEFT JOIN (
select b.id
from (select 'Isnt Null' id) b
LEFT join secuenciales d on 1=0
) B ON 1=0
ID
--------- ---------
NULL Isnt Null
(1 row(...more >>
Consolidate Rows on Select Posted by Dan at 10/4/2004 12:49:37 PM I want to condense several rows of a table using a select
statement, function, or stored procedure
For Example
mytable :
1 a
2 b
2 c
2 d
3 a
so that my select should result in
1 a
2 b,c,d
3 a
Any ideas or suggestions?...more >>
pivoting issue Posted by Miguel Salles at 10/4/2004 10:59:04 AM Hi,
I have a expenses table, in this table I have the account, exp_date,
exp_type and amount fields.
I have three exp_type (real, budget and myu) I would like to create a table
with
the fileds account, year_month, real_amount, budget_amount and myu_amount.
I am kind of lost now. How ca...more >>
Qualify customer information Posted by Stefnils at 10/4/2004 5:53:02 AM
Can anyone advise me of how to make sure that a customer is inputting
correct information into the database.
I am building a website, where customers are not logging in, but request
info. by name, addr. and postcode/city, email. I want to check if the
customer exists in the database or no...more >>
Views Posted by ?? at 10/4/2004 3:29:04 AM Is it possible to use variables in a view...
Ex: Create view zz as
Declare @user
Set @user = 1
Select * from sometable where @user = 1
i think you get my idea...
Is it possible?...more >>
Text Search Posted by Ibrahim Awwad at 10/3/2004 1:35:02 AM Dear All,
I have table for items, some of the Items codes are including text codes.
When I try to use
Select From **** Where **** like '****'
I don't get the correct record until I put the Upper case or lower case text
corrosponding to What's in table.
EX. to look for 'DISCOUNT' i can...more >>
database errr,URGENT Posted by shif at 10/2/2004 1:17:29 AM Hi
I am using mssql7 server.unfortunatily the space of the
hard disk reached below 10mb and while saving data
server has showned the disk full error.
After making enough space i restared the server,the server
has started,but one of the main database is showing an
error.msg 945 Level 14 stat...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |