| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Hi,
I have two tables TableA and TableB. I have a stored procedure which
runs every morning and based on some logic dumps rows from TableA...
Nick
|
09-15-2007 05:50 PM
Erland Sommarskog  | 2 | 39 |
| | | Hy, could someone help me in this:
In design mode, i want to put pictures in database. I made column named
pics, and its type as image. How can I...
Zeljko Bilandzija
|
09-15-2007 05:28 PM
Erland Sommarskog | 4 | 57 |
| | | Hi,
I was wondering whether any of you is monitoring MSSQL server 2005
(whatever information could be obtained) from a remote Linux server with
the...
aleu@vp.pl
|
09-15-2007 08:12 AM
aleu@vp.pl | 0 | 58 |
| | | Hi,
I have two tables TableA and TableB. I have a stored procedure which
runs every morning and based on some logic dumps rows from TableA...
Nick
|
09-15-2007 06:47 AM
Nick | 0 | 49 |
| | | Hot Jobs - HCL - Noida/Chennai/Gurgaon/Mumbai
1. Senior Citrix Admins - Noida / Chennai
2. Sun Solaris Admins - Noida/Mumbai/Chennai
3. HP Unix...
dbaguru
|
09-15-2007 01:48 AM
dbaguru | 0 | 51 |
| | | I have the following stored procedure:
ALTER PROCEDURE .
@thirty datetime
AS
BEGIN
SET NOCOUNT ON;
DECLARE @Repeat...
Nate
|
09-14-2007 05:54 PM
--CELKO-- | 3 | 48 |
| | | Hi,
I have the following three tables below containing Resources,
Categories and a link table so each Resource can belong to one or more
Categories....
nick@nova5.net
|
09-14-2007 05:39 PM
nick@nova5.net | 2 | 42 |
| | | Greetings,
A novice needs some advice:
I am able to bulk insert data from a text file into a table. Is it
possible to run a query and insert the...
junkmail115@gmail.com
|
09-14-2007 05:36 PM
Erland Sommarskog | 2 | 58 |
| | | Opened Forum ! http://sqlwarrior.freehostia.com/forum
SQL Warrior Forum
The most opened forum on the world !
Every one can join and asks question,...
highspamer@gmail.com
|
09-14-2007 04:39 AM
highspamer@gmail.com | 0 | 50 |
| | | Opened Forum ! http://sqlwarrior.freehostia.com/forum
SQL Warrior Forum
The most opened forum on the world !
Every one can join and asks question,...
highspamer@gmail.com
|
09-14-2007 04:38 AM
highspamer@gmail.com | 0 | 51 |
| | | where can i find a example on how to
build a script to reindex all my tables
Tks
DaveP
DaveP
|
09-13-2007 06:06 PM
DaveP | 2 | 61 |
| | | Dear Experts,
While running a query with a lot of joins, I got the following...
Emin
|
09-13-2007 05:45 PM
Erland Sommarskog | 3 | 49 |
| | | Hi, i've big problem!
i've sql 2000 std and windows 2003 svr standard. when i try to create
or modify a Dts Package connection i've receive an...
dreamsurf@gmail.com
|
09-13-2007 03:20 PM
dreamsurf@gmail.com | 0 | 63 |
| | | I posted this in one of the VB forums but I'm starting to think it
might be more appropriate to have it here, since it really seems to be
a SQL...
HC
|
09-13-2007 02:12 PM
Beowulf | 11 | 109 |
| | | Does any body have any VB (inside of Access) examples of creating SQL
produces inside a access form via vb and then executing those procedures...
Michael Kintner
|
09-13-2007 01:45 PM
David Portas | 1 | 53 |
| | | Two tables:
Fruit
fruitID, fruitName
Basket
buyerID, fruitID
(ie. we can see which buyer has what fruit in their basket)
tescodiscolondon@googlemail.com
|
09-12-2007 10:44 PM
Ed Murphy | 2 | 56 |
| | | We are running a query in SQL Server 2005 that makes use of temporary
tables and table variables. Occassionally a call to this query locks
up and...
Sputnik
|
09-12-2007 06:08 PM
Erland Sommarskog | 1 | 55 |
| | | How import database mysql to mysql server 2005?
--
magix
info
|
09-12-2007 05:06 PM
Greg D. Moore \(Strider\) | 1 | 45 |
| | | Hi,
I was trying to restore my database and received the error described
in...
Leisses Loud
|
09-12-2007 09:03 AM
Leisses Loud | 4 | 58 |
| | | I'm Trying to create a linked server from an SQL Server to another SQL
Server on another machine.
Can anyone suggest some good reference material or...
gdev
|
09-12-2007 03:43 AM
Erland Sommarskog | 1 | 60 |
| | | SQL Server 2005
All of a sudden we cannot log in using sa. The "enforce expiration"
option is not set.
How could this have happened outside of a...
Bill E.
|
09-11-2007 07:09 PM
Bill E. | 5 | 55 |
| | | Need help with a query.
I need to get a date from table1 where the symbol is equal to OQY7 but
the symbol in table table2 is OQY07.
How do I get it...
amj1020
|
09-11-2007 05:36 PM
Erland Sommarskog | 1 | 52 |
| | | SQL Server 2005
MS JDBC driver 1.1
OK - I've gotten to the point where I understand specifying
integratedSecurity=true;
in the JDBC URL connection...
aj
|
09-11-2007 12:46 PM
aj | 0 | 53 |
| | | all these while i've only used varchar for any string
i heard from my ex-boss that char helps speed up searches. is that
true?
so there are...
Nick Chan
|
09-10-2007 11:11 PM
Nick Chan | 4 | 72 |
| | | Hi all,
i wanna ask about dinamyc Function (FN).
This is my table :
CREATE TABLE .(
IDENTITY(1,1) NOT NULL,
(20) COLLATE...
aCe
|
09-10-2007 09:05 PM
Ed Murphy | 4 | 87 |
| | | Hello,
I have a table that contains multiple prices for multiple
location (yes I know is should have been done with an Xref table or
something, but I...
Ray
|
09-10-2007 05:23 PM
Erland Sommarskog | 3 | 55 |
| | | Hi
Below is a table with sample data to explain what I want to achieve.
trackID member marker
allele1
------- ------...
Rex
|
09-10-2007 05:18 PM
Erland Sommarskog | 2 | 53 |
| | | Hi,
My GIS software has a tool to count the number of points within a
grid.
This is fine for small recordset, when you get into the tens...
Clive Swan
|
09-10-2007 02:18 PM
Ed Murphy | 6 | 49 |
| | | Hello,
Where can one find the identity column for a table in the
INFORMATION_SCHEMA or the sys tables? Or is there a function that can
return the...
Wing9897@hotmail.com
|
09-10-2007 01:15 PM
kb | 2 | 54 |
| | | CREATE TABLE Agents
(ID COUNTER NOT NULL CONSTRAINT constraintName_pk PRIMARY KEY,
Name VARCHAR(255),
Supervisor INTEGER,
MasterCalendarVisible...
bodyboarder20@gmail.com
|
09-10-2007 12:55 PM
bodyboarder20@gmail.com | 1 | 52 |
| | | There is little evidence that the sql community understands the
concept of a table as a variable let alone its significant
implications. Yet there is...
steve
|
09-10-2007 12:15 AM
steve | 0 | 39 |
| | | Hi everyone,
Can any one please help me with MS BizTalk and Oracle Database
Adapters?
I am an Oracle E-Business Suite Applications Database...
danielbjennings@gmail.com
|
09-09-2007 09:12 PM
danielbjennings@gmail.com | 0 | 57 |
| | | hi,
I had a query on sql database, we know we usually store files of
different type in sql database and its helpful for searching and
retrieving...
apondu
|
09-09-2007 06:24 PM
Erland Sommarskog | 1 | 49 |
| | | Hi:
I need to add some records in a table called location(primary key:
loc_id). What I want to do is for each location in the table, I add
the same...
Hamilton sucks
|
09-08-2007 03:11 PM
David Portas | 6 | 67 |
| | | What properties to you set to make a SQL 2005 recordset updatable?
In Access,...
Charlie
|
09-08-2007 09:53 AM
Dan Guzman | 2 | 47 |
| | | Hi,
I have a database that I update every minute with financial data.
On another machine, a different user will need to get these updates
as
soon...
Enter The
|
09-08-2007 09:49 AM
Enter The | 0 | 61 |
| | | Hi,
I have a database that I update every minute with financial data.
On another machine, a different user will need to get these updates as
soon...
webmaster@financialcharting.com
|
09-08-2007 08:30 AM
webmaster@financialcharting.com | 0 | 47 |
| | | Hello,
I'd like to start by saying I'm not a DBA, rather I am a Java
developer. But I'm learning more and more about database design, and
it's very...
csimam@gmail.com
|
09-07-2007 05:16 PM
Erland Sommarskog | 8 | 45 |
| | | Hi,
I have two tables Trade table and Cons table. Records are inserted in
both the tables independent of each other. There are fields like
Exc_Ref,...
Nick
|
09-07-2007 06:58 AM
Nick | 2 | 61 |
| | | Hi All,
Can u please suggest me some books for relational database design or
database modelling(Knowledgeable yet simple) i.e. from which we...
vicky
|
09-07-2007 06:55 AM
vicky | 3 | 46 |
| | | I'm a newbie w/ SQL Server 2005.
We will be connecting to SQL Server 2005 via JDBC. We have made this
work by using an SQL Server account, rather...
aj
|
09-06-2007 05:29 PM
Erland Sommarskog | 1 | 34 |
| | | Hi,
I am studying data mining features of SSAS and for a workshop I've
created 2 views derived from vTargetMail view of AdventureWorksDW.
Train data...
ist
|
09-06-2007 05:23 PM
ist | 2 | 70 |
| | | Hi,
I have created a For Each Loop Containers to loop through the files in
the directory and process them. If it does not find any files in...
KR
|
09-06-2007 02:30 PM
KR | 0 | 48 |
| | | Hi,
I have two tables Trade table and Cons table. Records are inserted in
both the tables independent of each other. There are fields like
Exc_Ref,...
Nick
|
09-06-2007 01:29 PM
Nick | 0 | 68 |
| | | Is there any way to clear out the LDF file or reduce in size?
thank you in advance fro any help,
Michael Kintner
Michael Kintner
|
09-06-2007 11:52 AM
Pete Berry | 3 | 49 |
| | | Is there a query that will let me see what SQL users has what access
to which DBs and what lvl access they have?
click37@gmail.com
|
09-06-2007 10:35 AM
click37@gmail.com | 4 | 61 |
| | | Having some trouble getting my head around setting access to specific
schemas- here's my problem:
I've created a specific schema that I only want...
gdev
|
09-06-2007 03:20 AM
Erland Sommarskog | 1 | 40 |
| | | Hi all again,
I need an output like :
is possible to create output like that, without querying manually
cause too many dynamic columns in my...
aCe
|
09-06-2007 12:32 AM
Ed Murphy | 1 | 57 |
| | | Hi
I would like to group rows based on order and similarity in a single
sql-query if possible:
A, 1, 50
A, 2, 50
A, 3, 100
A, 4, 50
A, 5, 100
jan_soderman@yahoo.se
|
09-05-2007 03:17 PM
Hugo Kornelis | 1 | 48 |
| | | Hi everybody
Can I replicate a database onto a seperate instance of SQL? I need to
replicate a database to a stand-alone machine with no...
Driesen via SQLMonster.com
|
09-05-2007 10:47 AM
vijay | 4 | 77 |
