| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Hi all.
Below is a complex query generated by a persistence system,
and the relevant tables. This SQL is too complex for my skills,
and it gets this...
joeNOSPAM@BEA.com
|
03-02-2008 01:15 PM
Robert Klemme  | 3 | 16 |
| | | how to set color of checkbox , not the Text area
the area where the check appears
thanks
davel
Analizer1
|
03-02-2008 12:21 PM
Erland Sommarskog | 1 | 32 |
| | | Hi.
I used to have sql server 2000 and used dts to import data from oracle
databases.
Now I've been using sql server 2005 express, and don't see how...
kishjeff
|
03-02-2008 12:19 PM
Erland Sommarskog | 1 | 21 |
| | | I have a piece of code that uses the db-library with sql server
2000/2005 and runs the following delete statement:
DELETE FROM TABLE1 WHERE COL1...
phdscholar80@yahoo.com
|
03-01-2008 06:43 PM
Erland Sommarskog | 2 | 12 |
| | | I know how to access different tables on the same server by prefixing
the table with the database name. Is there anyway to prefix the
server name to...
compquest
|
02-29-2008 03:36 PM
compquest | 2 | 17 |
| | | SiSense is pleased to announce the beta release of its first product
Prism -
a Powerful, innovative Do-It-Yourself productivity software...
Erins.Ghost@gmail.com
|
02-29-2008 10:43 AM
Erins.Ghost@gmail.com | 0 | 16 |
| | | Hello folks,
Are there any tools that can transfer database and it's content from
SQL Server Standard version to SQL Server Express database?
I...
tapsavirtanen@yahoo.com
|
02-28-2008 05:35 PM
Erland Sommarskog | 1 | 16 |
| | | Hello,
I have one simple query joining two tables with left outer join on 3
fields and using MIN on two fields. These two tables have lot of...
dsdevonsomer@gmail.com
|
02-28-2008 02:10 PM
dsdevonsomer@gmail.com | 6 | 14 |
| | | Hello,
I have a (big) table which is not normalized, but for i need at the
moment i think
that's no problem. Indeed, what i would like to do is to...
rui dias
|
02-28-2008 08:18 AM
Plamen Ratchev | 5 | 16 |
| | | ado net and c# 2.0
i get different versions of excell files
how can i get correct version of xls files
select the data out of the sheets
if i open...
Analizer1
|
02-27-2008 05:54 PM
Analizer1 | 0 | 51 |
| | | Hi!
We have SQL Server 2000 on virtual machine (slowly). We run a pair of
stored procedures from ADO.NET 2.0 (WebService):
- first procedure: insert...
edi
|
02-27-2008 05:40 PM
Erland Sommarskog | 1 | 13 |
| | | I get the following error when i try to update a table with the a
trigger (trigger script below),
"Error Message: The row value(s) updated or deleted...
pyrahna
|
02-27-2008 05:35 PM
Erland Sommarskog | 6 | 17 |
| | | Does anybody knows the reproducing steps for above 3 sql errors?
Rakshit
Bakshi
|
02-27-2008 03:37 AM
Bakshi | 0 | 16 |
| | | I have a table DEFINITION with this content:
def_id game_id generaldef_id definition
========================================
1 ...
pompair
|
02-27-2008 12:33 AM
mr.mcgoo@gmail.com | 4 | 11 |
| | | Using SQL 7, going into EM, and clicking on one of the databases, I see two
maintenance plans listed. One of them is active, and the other has...
Neil
|
02-27-2008 12:10 AM
Neil | 0 | 15 |
 | | I have a query which works fine when hardcoded which is as follows
SELECT SchemaFields.SchemaID,...
Vic
|
02-26-2008 08:13 PM
Vic | 21 | 29 |
| | | W?adys?aw Bodzek (wbodzek_nospam (AT) poczta_nospam (DOT) onet.pl) writes:
I get fours spot for device one, and 4:20 for device two.
Here is a...
Erland Sommarskog
|
02-26-2008 05:45 PM
Erland Sommarskog | 0 | 9 |
| | | I'm trying to get all records that are 7 days pass duedate
(fieldname)
Select * from Library
where duedate > getdate()
How do I get it to show only...
JJ297
|
02-26-2008 03:04 PM
JJ297 | 2 | 10 |
| | | I wonder if anyone can help me with the following error message.
We use Sql 2000.
I wanted to backup the transaction log of a database with this...
David Greenberg
|
02-26-2008 08:23 AM
Dan Guzman | 1 | 9 |
| | | Hi!
I'm trying to do a log backup of a SQL Server 2005 database with Backup Exec
v11d (incl. SQL agent).
But I get the following error:
The item...
Jens
|
02-26-2008 03:31 AM
Jens | 0 | 10 |
| | | Hello,
I would like to do a little query in T-SQL.
I have two tables:
PERSON (PERSONID, PERSON)
PHONE ( PHONEID, PERSONID, TYPE, PHONE) -- TYPE...
Ina
|
02-25-2008 11:42 AM
Ina | 2 | 9 |
| | | I have a two node Windows 2003 cluster running 4 instances of SQL
2000. The two nodes we have now are blade servers that have dual
3.0GHz processors...
Chris Gelhaus
|
02-25-2008 11:39 AM
Chris Gelhaus | 0 | 12 |
| | | MAINFRAME Training with IBM Certification
Mainframe industry has shortage of people. Mainframe Education gives
you the competitive advantage you'll...
sonu
|
02-25-2008 04:38 AM
sonu | 0 | 11 |
| | | Hi,
I'm attempting to perform a snapshot backup of SQL database, due to
some space constraints the snapshot creation fails.
From the SQL trace log I...
velu5
|
02-25-2008 12:00 AM
velu5 | 0 | 12 |
| | | Hi all,
I have a table with this structure:
Customer ID | Transaction date | Transaction type
1 | 1/2/2008 | F
1 ...
myemail.an@googlemail.com
|
02-24-2008 04:13 AM
myemail.an@googlemail.com | 3 | 11 |
| | | I am trying to call a stored procedure in a while loop but for some
reason it only returns 1 row whereas I am expectint 12 rows
Here is the stored...
Vic
|
02-23-2008 10:14 PM
Plamen Ratchev | 5 | 10 |
| | | Hi,
could you tell me please what are the ways of the query string
encryption in T-SQL ? I would like to have a storage procedure that
encrypts e.g....
mielnik.bartek@gmail.com
|
02-23-2008 02:42 PM
Tom van Stiphout | 1 | 11 |
| | | Hi there,
I have learned to create very, very basic queries at work, but I would
like to expand my knowledge. I live in Northern California,...
Juana
|
02-23-2008 01:28 PM
Jack Vamvas | 2 | 12 |
| | | Hi Faculties,
I have two queries which give me the same output.
-- Query 1
SELECT prod.name, cat.name
FROM products prod INNER JOIN categories...
jackal_on_work@yahoo.com
|
02-23-2008 07:06 AM
Peter Deacon | 6 | 11 |
| | | I have a question on the UPDATETEXT function (SQL 2000)
The below query works and only updates the record where p.pub_id =
pr.pub_id.
I just don't...
Artie
|
02-22-2008 05:22 PM
Erland Sommarskog | 3 | 20 |
| | | I use an MsAccess frontend app that uses a 2 table view defined in
Sql(2005). When i link the view manually I can say (and cache in
Access) what...
addepad
|
02-22-2008 09:05 AM
Tom van Stiphout | 1 | 11 |
| | | Hello All,
I have a database of various artist's average annual auction prices,
which I would like to graph. In some years there are no sales for...
-cicada-
|
02-21-2008 11:37 PM
Plamen Ratchev | 1 | 14 |
| | | What is a good simple way to scan the servers in your network for SQL
Servers?
Does anyone have any scripts or code that would show me how to...
mjlefevre
|
02-21-2008 09:51 PM
Tom van Stiphout | 1 | 15 |
| | | Hello
I hope someone can help me. I need to know what the status codes mean
for the results of the sp_MSenum_subscriptions SP from the
distribution...
funksome@gmail.com
|
02-21-2008 02:19 PM
Thefunksomecat | 2 | 13 |
| | | I have to give a little presentation on database theory, and I'm
looking for a few good examples of questions that cannot be (easily)
answered if a...
eric.nave@gmail.com
|
02-21-2008 10:57 AM
Anith Sen | 5 | 21 |
| | | Hi
I've two tables
TableA
id
name
TableB
id
Cacho
|
02-21-2008 03:41 AM
Cacho | 2 | 11 |
| | | Hi,
I have a SQL database that accepts data loads from Lotus Notes thru
ADO calls. We have several tables and from the ADO connection these
tables...
Query Builder
|
02-20-2008 06:15 PM
Erland Sommarskog | 1 | 10 |
| | | Hi, I'm using MS SQL server 2005.
I have two identical databases - with one exception: they have different
names (etc database1 and databse2), but...
zgb
|
02-20-2008 06:14 PM
zgb | 4 | 11 |
| | | I do a number of transaction oriented queries such as:
select top 1 * from data_table where ((='data_value') AND
(>6556))
Now would this be possible...
quincy451@yahoo.com
|
02-20-2008 06:00 PM
Erland Sommarskog | 1 | 11 |
| | | Hi
Iam new to this group
SO can any one provide me with dumps of 1z0-007
regds
AJax
ajax
|
02-20-2008 12:34 AM
Ed Murphy | 6 | 10 |
| | | Hi,
We have shifted one of our data processing to a new instance of SQL
2005. For this a new DB was created in SQL2005 and it is not an
upgrade of...
Tawfiq
|
02-19-2008 05:31 PM
Erland Sommarskog | 3 | 13 |
| | | I was wandering if I could put a print inside a select or a select in a
print.
I know I can put a select inside another select which correlated...
Marc
|
02-19-2008 05:25 PM
Erland Sommarskog | 2 | 13 |
| | | Dear Job Seekers,
Greetings from walkincareers.com - The Ultimate Walk in jobs Portal.
For the Walk-In drives across India kindly log on to the...
jobsearch.india02@gmail.com
|
02-19-2008 08:28 AM
jobsearch.india02@gmail.com | 0 | 12 |
| | | The following procedure took about 24 hours to run. I've tried
changing the nested queiries to joins, getting rid of the @Cutoffdate
variable...
remylawrence@gmail.com
|
02-19-2008 07:42 AM
Greg D. Moore \(Strider\) | 4 | 11 |
| | | I'm having a performance Issue with my Production SQL Server (2 x Xeon
Dual-Core Woodcrest 1.6Ghz, 2GB RAM, IIS, SQL Server). In general the
querys...
Andres Rormoser
|
02-19-2008 06:00 AM
Andres Rormoser | 9 | 10 |
| | | Can anyone help me to transfer data results from a SQL query to
input forms on a web page using vba or whatever will work. I work
on a web page...
jcnone@none.com
|
02-19-2008 04:03 AM
graformix.com - professional design studio | 3 | 12 |
| | | I have an application that uses MicrosoftSQL as the backend. I also have
associated applications that run on a LAMP server. I'd like to setup
MySQL...
Michael
|
02-19-2008 03:51 AM
graformix.com - professional design studio | 4 | 14 |
| | | I'd like to announce a free tool that is now available from my web site.
It's not something that I've written myself, but it's a small...
Erland Sommarskog
|
02-18-2008 05:28 PM
Erland Sommarskog | 0 | 12 |
| | | Hi,
I was wondering if someone could help advise me.
Basically i have a client who wants to upgrade from a desktop ms
access solution to a web...
csgraham74
|
02-18-2008 05:24 PM
Erland Sommarskog | 3 | 12 |
| | | Hello All,
I have a parent table ASSET:
CREATE TABLE .(
IDENTITY(1,1) NOT NULL,
(50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT
NULL
) ON
hharry
|
02-17-2008 08:33 PM
hharry | 2 | 13 |
