Great time in France
Wed, 7 Jun 2006 15:31:39 +0100
Hello
I had a fantastic time in France, hope to visit again soon.
I found a holiday cottage from these guys www.looktogo.co.uk http://www.looktogo.co.uk
Regards,
Dancer: ). ...
|
Date Query
Mon, 5 Jun 2006 19:25:02 -0700
I'm using sql 2000 and Access 2003. I trying to query on a date field. I need
to display any records from the current date and greater then. What criteria
do I use to display these records?
Thanks,
Paul Scott ...
|
Missing name type for name entity
29 May 2006 07:07:13 -0700
Hi,
I keep getting this error whenever I try to describe any of the
entities in my database using their given name:
Missing name type for name entity in phrasing.
I'd like to know the exact cause of this problem, though I think my
biggest question is: what is a "name type"?
Any help will be appreciat ...
|
SQL Scripting DB Role Permissions
Wed, 24 May 2006 14:31:02 -0700
I have created a user role in my SQL 7 database. I would like to copy this
role to 8 other servers. I created the role using Enterprise Manager. Can
you advise how to query this out to SQL Script so that I could just run the
script on the other servers to create the role and then assign users as
require ...
|
Special Character
Wed, 24 May 2006 13:04:01 -0700
Is there anyway to query out the special character ' i.e. foot. We have a
table in a database that has data in it containing the foot and inch
characters. We need to remove these and I can find using 'like' with the "
inch but can't with the ' foot. ...
|
selecting colunm with a space ''
Sun, 21 May 2006 21:07:02 -0700
When I submit a sql :
select * from view from column=''
the view is pointing to oracle table with ole db provider for oracle
In mssql2000, the result return rows which containing a space ' '
However, in mssql2005, the result return no rows .
Any advise on it?
...
|
select date list
Mon, 15 May 2006 07:58:02 -0700
i am trying to write a query in sql server 2000 that returns the list of days
between two dates.
it should return something similar to
for i = 1 to 100
select getdate() + i
next i
how can SQL server do such query.
thanks ...
|
|
|
UPDATE TABLE1 ONLY WHEN ALL RECORDS IN COLUMN IN TABLE2 ARE TRUE
Sun, 14 May 2006 04:59:02 -0700
Table2 has multiple records joined to single record in Table1. I want to
UPDATE column in Table1 only if all joined records in Table2 are True.
Help would much apprec. ...
|
Last order date for each customer
Mon, 8 May 2006 09:32:01 -0700
I would like to write a select statement in query analyzer which would return
the last order number per customer given a specific order type. (Which would
be 1 record per customer) Thanks. ...
|
Help on : Could not find stored procedure 'recurse_oids'
Mon, 8 May 2006 06:11:02 -0700
Hello everyone,
I'm on MS SQL SERVER 2000.
When runing this simple delete statement:
delete from sd50.cdm_locations where loc_oid =146836832983830528
I get the following error:
Server: Msg 2812, Level 16, State 62, Line 15
Could not find stored procedure 'recurse_oids'.
The statement has been t ...
|
