Posting Guidelines
Posting GuideLines
Please follow these guidelines when posting questions. Submitting clear and concise questions allow those reading to understand... more »
sticky
|
|
SubQuery Question
Hello Everyone, i have a rather chunky Query:
SELECT top 100 percent EMDET.DET_NUMBERA, EMDET.DET_G1_NAME1A, EMDET.DET_SURNAMEA,... more »
|
|
Mulpliplcation of all values in a column plus converting negative values
I need to multiplicate all the values in a coloumn with a constant and returning them in a (eventually new) column.
My second problem is that there... more »
|
|
Match two tables.
Hi all,
I am using SQLServer2000. I have two same tables. I want a query to check whether these two tables have same data. How can i check... more »
|
|
How are parameters passed in Triggers?
Hi All,
May i know how do we pass parameters in Triggers and if no parameters are passed then how they get fired...??
Thanks & Regards
Nitin... more »
|
|
SQL Permissions
i Loaded SQL Express on my notebook and i run my application on it which creates new database.
I get error 'Create Database permission denied in... more »
|
|
Alter Or Create Procedure?
HI.
I have to Alter a procedure if it exists or Create the procedure if it doesn't in SQL Server 2005.
I can manage to determine if it exists or... more »
|
|
Reporting Services close download interface without exporting
Good day All,
When I export on a workstation from reporting services to excel the download window closes without the file being created. The file is... more »
|
|
SQL caclcualted field
How do I create the SQL for the following. I have a table of meetings, but I want to generate a calculated field for each discussion point relating... more »
|
|
Stored Procedure
Hi
I have to convert the following query into stored procedure
"select DoctorMaster.FirstName+''+DoctorMaster.MiddleName+''+DoctorMaster.LastName... more »
|
|
Dynamic ORDER BY
I am working on adding sorting functionality to an online store.
The query works fine when it has a hard coded ORDER BY, but not when the ORDER BY is... more »
|
|
Sql query date problem
Hello guys, I need some help.
I have a table with a date field and i have a problem when i want choose data between two dates, like for example:... more »
|
|
Faster way to check if a record needs updating
1 Reply |
Posted by: abev
| Last post by Delerna, 3 days ago
First I check if the ABBR exists, then I update it. It seems like I am making 2 requests - 99% of the time I would never send the wrong parameters so... more »
|
|
Foreign key
I have a table name product
that have column productCode (primary key), name address , ph , warehouse .
I want to create a new table with columns... more »
|
|
Variable database name in stored procedures
I am trying to create a stored procedure that runs a smaller query first to determine the database to run the second query on. Below is a sample... more »
|
|
SQL Query Assistance
Hi
We are using Microsoft CRM and we have exported a list of service activities to a dynamic Excel worksheet. I have attempted to insert the name of... more »
|
|
mSQL + Perl = Phantom rows
I'm writing a PERL script to access and insert rows into a Microsoft SQL. i'm using MS SQL Server Management Studio Express (2005) to architect... more »
|
|
Crystal reports
i have a payroll program that can start new companies, a company has its own database. they will always be the same tables etc inside all the... more »
|
|
Securing Tables/Views
Hi,
Is there a possibility to allow a user only for a particular view, without allowing him to open the tables directly ?
Couldn't find a way,... more »
|
|
Insert a record that has been deleted
I need to insert the records in table2 that have been deleted in table1 how should I proceed? Will trigger help me out?
If so some one plz help how... more »
|
|
Calculating Opentime between several records.Using SQL Server 2000.
Using SQL Server 2000. Basically, I am trying to calculate each minute of an employee scheduled time during their work shift. In the table below... more »
|
|
Log file needs shrinking
Hello,
I need help with shrinking the actual log file. I keep shrinking the trans logs but then it just reverts back to a 1 gig size trans log fille... more »
|
|
How to compare date,month,year
hi,
Im storing Issue date in database.
Issuedate stored as varchar.
and then compare to Passing string date('03/06/2008')
what is query to... more »
|
|
SQL Query Email
I have a data table that contains STATUS and ADJCODE. I need to write s SQL query that counts records by STATUS and ADJCODE and send an email to a... more »
|
|
Calculating Opentime between several records
Basically, I am trying to calculate each minute of an employee scheduled time during their work shift. In the table below shows only the times that... more »
|
|
Violation of PRIMARY KEY constraint..how to solve this error?
Hai everybody :). I have problem and need help.
ERROR:
ERROR Violation of PRIMARY KEY constraint 'PK_Table1_01'. Cannot insert duplicate key in... more »
|
|
