September 9th, 2008
msquared (Administrator)
|
Posting Guidelines
Posting GuideLines
Please follow these guidelines when posting questions. Submitting clear and concise questions allow those reading to understand... more »
sticky
|
|
Find Parent Record Where Child Records Contain Same Value
I'm building a view in SQL Server 2000 Enterprize Manager to find any parent supply request records that are "Open" where all of the child detail... more »
|
|
displaying record between two dates errors
Good Day Everyone,
Requesting for your expertise please, in my program the user has to enter the agent name and the from date and to date inorder to... more »
|
|
How to compare 2 databases
Hi all,
Can anyone tell me that who can i compare 2 databases.
I have a backup database and a current database. I want to know what is the... more »
|
|
Mssql Page Number Query help TOP , NOT IN ??
I'm trying to add simple page support, the page is php/mssql based.
Anyone know why this doesn't work? I found the "NOT IN" command online but I'm... more »
|
|
MSSQL DB Space usage
How to find out the space usage for all the databases in MS SQL thru SQL Query Analyzer?
Normaly i used to view thru SQL Server Enterprise Manager... more »
|
|
read and set object roles programatically
I have a large DB product running under MS SQL 2005 on windows server 2003 SP2.
I have problems with the uninformed changing permission on... more »
|
|
Design Question - Money data-type
hi,
i want to ask about money datatype, what makes it special or different that we better use it for a currency related field (like the price of a... more »
|
|
Trace on sql table
Hi all,
I have a sql server 2000. and i have one of the table in my database is getting value from some store procedure or view.
This database is... more »
|
|
Sql query for sorting the output in the descending order
Select distinct b.contributor, blogaddress,count(b.contentid) RecipeCount,isnull(c.cnt,0) Other
from weblogs.dbo.blogentries b left outer join... more »
|
|
Constraint - check integer string
hi,
i have a field named 'nim', in my table which is a char(10) field.
i want to create a constraint that checks the field so the field must be 10... more »
|
|
How do i SUM up values returned by TOP 5 and COUNT statement?
I want to be able to SUM the values returned using the TOP 5 and COUNt statements. So far I've tried from many angles and can't get it to work, very... more »
|
|
Multiple datasets Reporting Services problem
Hi All,
I have report that uses two datasets(both get image from database using the same stored procedure). Stored procedure needs one parameter... more »
|
|
How We create a password protected database in sql
1 Reply |
Posted by: veer
| Last post by ck9663, Yesterday
hi
i want to create a database with password like in ms-access
so whenever any body wants to open the database it has to be enter the... more »
|
|
replicating data between master and slaves
Hi All,
In our organization we are using Slony to replicate data between master and slave on POSTGRESQL databse ,
My requirement is ,what is the... more »
|
|
Multiple Sum and Join
I have two tables i would like to join to show bonus earned this month and total this year.
First table: empl.
emplID | Name
1 | Bob
2... more »
|
|
Problem placing results of generated select statement into dynamic temp table
How can I place the results of a dynamically generated select statement into a (#) temp table?
This has me stumped, any help would be greatly... more »
|
|
How to find login name and password for sqlserver 2005
Hi all,
How to find login name and password for sqlserver 2005 in sql server authentication mode,
In my sys i have installed .net and... more »
|
|
SQL query/unique entries only
Hello,
I have a query listed below which works but...
The data below is what the query displays. There are hundreds of records I am bringing up and... more »
|
|
Working out a percentage using sql
I have a table that holds four questions and the values assigned to that question. The value can only be Yes or No.
The results will look... more »
|
|
SQL newbie, need help cleaning up my SQL (works, but ugly)
Okay, this works, but there has GOT to be a cleaner way of doing this.
Suggestions please.
DECLARE @TMP TABLE
(
HOLD1 NUMERIC,
HOLD2 NUMERIC,
HOLD3... more »
|
|
Strore large texts in mssql and dispaying them in php
I have a text field where I wish to enter a large text around 8000 words and a div where I want to diplay it.
To save I have a textarea with post I... more »
|
|
How to find the frequent access table's (hit)
How to find the table which is frequently accessed. more »
|
|
SQL Server does not allow remote connections.
Hi.
I've got the some problem when the connecting to SQL Server from Local Computer to the my own SQL Server.
And, Massage is a " An error has... more »
|
|
DB2 linked server from sql server 2005
Ok, I do not know what I am doing wrong. I have linked servers setup from SQL server 2005 to db2 using odbc dsn.
I open sql server management... more »
|
|
SQL Using a single variable to store multiple results
Ok so currently I have a store procedure that does roughly this:
SELECT
IDX, FirstName, LastName, Email, Phone, etc, etc2, etc3
FROM
... more »
|
|
