Minimum Value Of 2 Fields

Dec 20, 2004

i need to create a dynamic field, which returns the minimum value of 2 fields.

A B C(i need)
500 600 500
350 250 250
825 950 825

select A,B,min(A,B) as C from MyTable

i know this query is wrong,
pls help me to solve this problem


RGDS
BAHA

View 4 Replies


ADVERTISEMENT

Get The Minimum Value

Sep 17, 2007

In my table I have values like (2,3). I want to get the minimum value from the column

View 12 Replies View Related

Set The Minimum Permissions

Apr 26, 2007

Hi All,How do I set just enough permissions on a database so that a developer cancreate new objects and modify them without giving him administratorprivilege. At the moment the db objects are dbo and execute permissions aregranted to indevidual through a schema.GRANT EXECUTE ON [dbo].[My_Prcsedure] TO [MySchema]Thanks

View 2 Replies View Related

Find The Minimum Value

Mar 15, 2007

How can I find the minimum value of column?

Select salonuid, avg(LPPA),[Find the minimum](LPPA) from kpi.dbo.employee_data group by salonuid

The Yak Village Idiot

View 2 Replies View Related

Finding Minimum Value

May 5, 2006

How to find the minimum value from time Timestamp column ?

I want get the eralier timestamp vlaues from the avaliable list

when iam using Aggregate transformation ..its again giving all the list of vlaues

Thanks
Niru

View 4 Replies View Related

Minimum/Maximum Of Two Values

Dec 6, 2004

Hallo Cracks,

what I try is a little bit heavy, maybe, but I only miss the minimum/maximum fuction - or I didn´t found it; not here in the Forum and also not in the onlinehelp of the SQL Server.

What I try to do:

I have 2 columns in my table; a start- and an end-date. For this period of time between end and start i have to calculate the days for the years. Here my thoughts (for the current year):

Is the startdate <= 31.12.2004 and the enddate >= 1.1.2004 i have to calculate die datediff between max(1.1.2004/startdate) and min(31.12.2004/enddate)

like this sqlstatement:

SELECT CASE WHEN dbo.Phases.phasenstart <= CAST(CAST(YEAR(GETDATE()) AS
varchar) + '-31-12' AS smalldatetime) AND dbo.Phases.phasenabschlussist >=
CAST(CAST(YEAR(GETDATE()) AS varchar) + '-01-01' AS smalldatetime)
THEN 365 ELSE 0 END AS Expr2,
FROM dbo.Phases
WHERE (phasenstart IS NOT NULL) AND (phasenabschlussist IS NOT NULL)

instead of 365 there must be the above calculation. Is start=3.1.2003 and end=30.1.2004 I expect as result only the 30 days in 2004.

thanks in advance and kind regards :-)
Cappu

View 2 Replies View Related

Get Minimum Start Date

Nov 12, 2014

I'm looking at the following Records:

cust_no item_no start_dt end_dt price
1060 2931 2011-02-06 9999-12-31 1.23
1060 2931 2011-04-18 9999-12-31 2.00

I want to be able to pull the records with the earliest date 2011-02-06 ...

There were other records with this same customer and item number. I used this script to return the two above.

select *
from price
where end_dt > getdate()

Now I need to add something so it only returns the record with the earliest date. I'm going to run this on a table that has many customer and item combinations.

View 3 Replies View Related

Display Minimum Of Two Values

Apr 13, 2015

I want the minimum of two values to be display like below without using the case

MIN(3.00,4.00)

output:

3.00

View 2 Replies View Related

Select Minimum Between Two Values

Jul 27, 2006

Hello,I need to select the minimum between the result of a function and anumber, but i can't find a smart way. By now I'm doing like thefollowing, but I think is very expensive because it evaluates thefunction twice:select case when (myfunction())<100 then (myfunction()) else 100 endAny idea is appreciated.Thank youRegards--elimina carraro per rispondere via email

View 4 Replies View Related

SQL - How To - Minimum Number Of Steps

Jun 20, 2007

Hi. I have an 'Attendance' table like this:PIN Year Category Days1 2006 Authorized 11 2006 Available 21 2006 Personal 32 2006 Authorized 42 2006 Available 52 2006 Personal 63 2006 Authorized 73 2006 Available 83 2006 Personal 94 2006 Authorized 104 2006 Available 114 2006 Personal 121 2007 Authorized 131 2007 Available 141 2007 Personal 152 2007 Authorized 162 2007 Available 172 2007 Personal 183 2007 Authorized 193 2007 Available 203 2007 Personal 214 2007 Authorized 224 2007 Available 234 2007 Personal 24I need to sum the days by PIN, Year and Category (that's easy...) ANDobtain a layout like this:PIN Auth 2006 Avail 2006 Pers 2006 Auth2007 Avail 2007 Pers 20071 1 23 13 14 152 4 56 16 17 183 7 89 19 20 214 10 1112 22 23 24How can I do this by queries without writing too many intermediatesteps ?What I have done is this (5 queries, 2, 3, and 4 building on top of1,and 5 building on 2, 3, 4).1 = Table1_Crosstab:TRANSFORM Sum(Table1.Days) AS SumOfDaysSELECT Table1.PIN, Table1.YearFROM Table1GROUP BY Table1.PIN, Table1.YearPIVOT Table1.Category;Then, based on that,2 = Authorized:TRANSFORM First([1 = Table1_Crosstab].Authorized) ASFirstOfAuthorizedSELECT [1 = Table1_Crosstab].PINFROM [1 = Table1_Crosstab]GROUP BY [1 = Table1_Crosstab].PINPIVOT [1 = Table1_Crosstab].Year;3 = Available:TRANSFORM First([1 = Table1_Crosstab].Available) AS FirstOfAvailableSELECT [1 = Table1_Crosstab].PINFROM [1 = Table1_Crosstab]GROUP BY [1 = Table1_Crosstab].PINPIVOT [1 = Table1_Crosstab].Year;and4 = Personal:TRANSFORM First([1 = Table1_Crosstab].Personal) AS FirstOfPersonalSELECT [1 = Table1_Crosstab].PINFROM [1 = Table1_Crosstab]GROUP BY [1 = Table1_Crosstab].PINPIVOT [1 = Table1_Crosstab].Year;and finally5 = AllSELECT [2 = Authorized].PIN, [2 = Authorized].[2006] AS [Auth 2006],[3 = Available].[2006] AS [Avail 2006], [4 = Personal].[2006] AS[Pers2006], [2 = Authorized].[2007] AS [Auth 2007], [3 = Available].[2007]AS [Avail 2007], [4 = Personal].[2007] AS [Pers 2007]FROM ([2 = Authorized] INNER JOIN [3 = Available] ON [2 =Authorized].PIN = [3 = Available].PIN) INNER JOIN [4 = Personal] ON[3= Available].PIN = [4 = Personal].PIN;It works, but... I am sure that this is an awkward way of doing it.Isthere any other, more elegant, way, please ? Besides, what if I hadnot 3, but 15 categories, for example ????Thanks a lot for your time reading this, Alex

View 4 Replies View Related

Get Minimum Day In A Continuous Series

Jun 6, 2006

Hi,

l've a series of day which record the date of an event. l would like to count the # of continuous days for the event. In this case, it would be 14/5, 15/5, 16/5, 17/5, 18/5, 19/5 and 20/5. Any idea to do this in SQL?




Date
-----
20/5
19/5
18/5
17/5
16/5
15/5
14/5
09/5
07/5
06/5
05/5

View 7 Replies View Related

How To Find Out Minimum Size

Aug 21, 2006



hello

i have one doubt.can anybody clarigy it.

every time i am doing my database shrinking manually.

what i am asking i find out every time when i shrink my database that sql is showing minimum size of database to shrink.how can its getting minimum size

but i need to find out how to get minimum size of particular database programatically.

thanx



View 3 Replies View Related

Minimum Install To Run DTSRUN.EXE Utility

Oct 27, 2000

What is the minimum installation on a user's PC to enable them to run a DTS package using the DTSRUN utility in a DOS bat file. The user currently does not have the mssql7inn directory on their PC. I don't want to install all of the components of SQL Server 7.0 on their PC, i.e., Query Analyzer, Enterprise Manager, etc. Does the server referenced in the DTSRUN command line need to be registered on their PC?

View 1 Replies View Related

Get Minimum And Maximum Values From Field?

Sep 16, 2012

I am trying to get the minimum and maximum values from a field in SQL Server 2008 Express, but I cannot even get started because I keep getting this error that I cannot figure out.

View 6 Replies View Related

Capture Records With Minimum Claim ID

Jan 19, 2014

I need to capture records with the minimum claim ID when the prov, diag, and the billed are the same, but the claim id and check id are different.

EXAMPLE:
CLAIM DOS PROV DIAG BILLED CHECK#
2001 02/05/11 500 252.5 30.00 35
2015 02/05/11 500 252.5 30.00 56

On this example, I would need to capture the record with Claims ID 2001 and exclude the other.

View 4 Replies View Related

Minimum Time Difference Between Tables

Sep 3, 2013

I receive the following result set from TableA (In Time)

7/9/2013 9:27:00.000 AM
7/9/2013 10:24:00.000 AM
7/9/2013 11:25:00.000 AM
7/9/2013 1:23:00.000 PM
7/10/2013 7:27:00.000 AM

Then we receive the following result from TableB (Out Time)

7/9/2013 9:30:00.000 AM
7/9/2013 10:29:00.000 AM
7/9/2013 1:37:00.000 PM
[NULL]
[NULL]

We may not always get Out Times in TableB so I want to merge these into one table to have the In Time and Out Time in separate columns in that one table. In this example with the red type those should be In Time and Out Time for mapped unique identifiers from each table and yet the purple color coded example would have an In Time of 11:25 AM and the Out Time would remain as NULL.

I am using this block of code but is not working the way I want it to because the 11:25am In Time is getting mapped to the 1:37pm Out Time.

and out_time = (select min (out_time)
FROM tableB WHERE
tableB.record# = tableA.record#
and tableB.loc_id = tableA.loc_id

GROUP BY tableB.record#, tableB.loc_id )

It seems I need to focus on the minimum datediff for each record line but can't figure that part out.

View 2 Replies View Related

Minimum Install MSI For SQL Server 2005

Jun 6, 2007

Off of the MSDN SQL Server 2005 Enterprise Edition, what is the MSI I should use to install SQL Server 2005.

I have to Upload all files to a server, and this is going to be painfully slow. Can anyone tell me what the minimum is to upload and install SQL Server Enterprise (not Express)?

(For 32 and 64 bit non-Itanium machines)

View 7 Replies View Related

Instaling Sql2005 With Minimum Parameters

Dec 10, 2007



I have went thru template.ini . it seems very complicated. i only want to innstall sql express edition
with instancename, security mode and sapwd. ihave givem it in template.ini
[Options]
SECURITYMODE=MIXED
INSTANCENAME=DCS123
SQLACCOUNT=sa
SQLPASSWORD=changeme
with cmd line parameter d:sql2k5setup.exe /qb / settings c: emplates.ini
it made an error message invalid ini file make sure the file exists , have access and has the correct entries.

i tries to input all details in command line.
d:sql2k5setup.exe SECURITYMODE=MIXED INSTANCENAME=DCS123 SQLPASSWORD=changeme
it also failed to work.

we cant input more details like user account etc..
kindly help us in this rgards

View 4 Replies View Related

Varchar Minimum Length Check

Oct 7, 2007

Hi,

I have a column set to varchar(12) so I can ensure that the length of the string entered will never be more than 12 characters but I want to limit the string to a minimum of 8 characters, so I end up with a string that is from 8-12 characters long. How do I ensure the minimum length of 8 characters? I'm using SQL Server 2005 if that helps. I tried adding a check constraint like so:

DATALENGTH(UserName) >= 8

But I keep getting an error when I save the table, so any help would be very much appreciated.

Thanks

View 3 Replies View Related

Master Db - Minimum Permissions For Guest

Jan 7, 2008



Hi All:

I hope I'm in the correct forum for this question. If I'm not, forgive me and point me in the proper direction.

I have SQL Server 2000 databases that I am trying to secure. To that end I've deleted the guest account from all but the master and tempdb databases.

Within the master db I've denied access of any "flavor" to all objects but spt_values, syscharsets, sp_MSSQLDMO80_version, and sp_MSdbuserpriv (only because I've discovered they are necessary).

Can anyone tell me where I might find the absolute minimum permissions configuration for the guest account in master?
I have no third party vendor software accessing my SQL Server 2000 databases. The thought of

Demographics:
SQL Server 2000 sp4 running on Windows 2003 Server with the current service packs.


Any help is greatly appreciated.

caeriel

View 1 Replies View Related

Enforcing Minimum Cardinality In SQL Server

May 8, 2007

I am trying to understand constraints and minimum cardinality.



In a relationship between 2 tables, t1 and t2, with a parent to child relationship of


1 to 1 or more
how is the minimum cardinality enforced?

If both sides of the relationship require at least one occurrence, how would the insert be done? How can you insert into table t1 when it has a constraint that there must be an occurrence in table t2, or vice versa?

Any help in understanding this is greatly appreciated!

View 4 Replies View Related

How To Create A User With Minimum Privileges

Jul 19, 2015

I have a database for which I need the permissions to execute stored procedures, perform CRUD operations on tables, execute functions and SQL jobs. What should be the SQL command if I am to create a user for this database who will have the most minimum privileges to carry out these activities?

View 4 Replies View Related

Minimum Scale Of Y-axis Ignored When Using Negative Value

May 21, 2007

I want to display a chart with a minimum y-axis of -10%. When use the value -0.10 the result is a minimum of -100%. Is this a bug?

-Jeroen

View 2 Replies View Related

Minimum Install To Use SQLOLEDB Enumerator?

Jan 17, 2008

Hi,

I have a client application that creates a COM object using the program ID 'SQLOLEDB enumerator' to get an ISourcesRowset. Once I retrieve the ISourcesRowset, I call ISourcesRowset.GetSourcesRowset to obtain a list of available servers.

This works if the client computer (the one running the application) also has SQL Server (or SQL Express) installed. But on a clean computer after installing SQLNCLI.MSI, the call to GetSourcesRowset returns an error 80004005.

My question is, what do I need to install on my client's machines so I can retrieve available servers using this method? Is there another MSI that needs to be installed? Do I need to install SQL Express Client_Components? Or is there something else?

Thanks in advance for any information you can provide.

-Eric Harmon

View 1 Replies View Related

Minimum Invoice Date Query For Client ID

Oct 13, 2014

I have a table with data like the following:

ClientID InvoiceDate
1 2012-01-01
1 2013-01-01
2 2012-01-01
2 2013-01-01
3 2012-01-01
3 2013-01-01

I would like to return a distinct ClientID and also the minimum InvoiceDate for that ClientID, so that the data looks like this:

ClientID InvoiceDate
1 2012-01-01
2 2012-01-01
3 2012-01-01

View 1 Replies View Related

Minimum MDAC Version Requirement (Error)

Aug 8, 2006

Hi everyone;

I'm just getting started. I'm on Window 2000 pro with service pack 4 etc...
I installed "C#" and "Microsoft Visual Web Developer 2005 Express Edition" -thats fine.

I then installed "Microsoft SQL Server" (SQLEXPR.EXE) it was good until it did a check:

Everything checked and passed fine except for the 2nd to last one:
- Minimum MDAC Version Requirement (Error)
Messages
* Minimum MDAC Version Requirement

* The system does not have the required version of Microsoft Data Access Components (MDAC) for this SQL Server release. For details, see Hardware and Software Requirements for Installing SQL Server 2005 in Microsoft SQL Server Books Online.


- Edition Change Check (Success)
Messages
* Edition Change Check

* Check Passed
-----------------------------------------------------------------

So I was wondering where did I go wrong. I have lots of hard drive space too.

CPU is 1.80GHz - with 523,056 KB RAM

I did some research but there seems to be 100's of pages.

View 4 Replies View Related

Mean, Minimum, Maximum, Standard Deviation Of Time

May 7, 2007

I have a report that calculates mean, min, max, stddev of somer exercises for a class (pushups, situps, trunk lifts, etc). I also have to calculate those for the 1-mile run time (ex: data -- 7:56, 6:35, 9:45 ( in minuteseconds). Obviously the standard Avg(), Min(), Max(), StdDev() functions won't work for time. So I put in some custom code to convert the time to seconds so I can use the standard functions on the seconds and also code to convert that answer back to minuteseconds. Max() works, but for example when I try to calculate the min(), it includes nulls from the dataset as zeros (not every student has to do the mile run). So the min is always 0. How can I exclude nulls from being calculated. The min() function excludes nulls so it returns the correct min() on integer data. What else can I do?

View 3 Replies View Related

Transact SQL :: Include Minimum Item Values Only

Aug 3, 2015

My sql gives me the results as shown in #TEMTAB Table.some times Mitem_id is repeated for the same Group_id,SGroup_id  with different item_id

ex: SQ322,SQ323,SQ324,SQ325 are repeated here.
CREATE TABLE #TEMTAB
(Group_id int, SGroup_id int, item_id int, Mitem_id varchar(10)
,YN varchar(2),value varchar(8),reason varchar(20))

[code]...

View 8 Replies View Related

Subreports: Parameter Value Dropdown Shows Sum And Count Fields But Not The Actual Data Fields.

Jan 28, 2008


I have just started using SQL Server reporting services and am stuck with creating subreports.

I have a added a sub report to the main report. When I right click on the sub report, go to properties -> Parameters, and click on the dropdown for Parameter Value, I see all Sum and Count fields but not the data fields.

For example, In the dropdownlist for the Parameter value, I see Sum(Fields!TASK_ID.Value, "AppTest"), Count(Fields!TASK_NAME.Value, "CammpTest") but not Fields!TASK_NAME.Value, Fields!TASK_ID.Value which are the fields retrieved from the dataset assigned to the subreport.

When I manually change the parameter value to Fields!TASK_ID.Value, and try to preview the report, I get Error: Subreport could not be shown. I have no idea what the underlying issue is but am guessing that it's because the field - Fields!TASK_ID.Value is not in the dropdown but am trying to link the main report and sub report with this field.

Am I missing something here? Any help is appreciated.

Thanks,
Sirisha

View 3 Replies View Related

Creating A Table In SQL Server With Fields From Other Tables And Some Fields User Defined

Feb 20, 2008

How can I create a Table whose one field will be 'tableid INT IDENTITY(1,1)' and other fields will be the fields from the table "ashu".
can this be possible in SQL Server without explicitly writing the"ashu" table's fields name.

View 8 Replies View Related

Public Overridable ReadOnly Default Property Fields() As ADODB.Fields

Jan 26, 2008

sir

I have got this error message to establish connction with recordset vb .net, Can you please rectify this

Too many arguments to 'Public Overridable ReadOnly Default Property Fields() As ADODB.Fields'

my code like this


rs = New ADODB.Recordset

rs.Open("Select * from UserLogin where userid='" & txtUserName.Text & "'", gstrDB, DB.CursorTypeEnum.adOpenStatic)


If txtUserName.Text = rs.Fields.Append(userid) Then


MsgBox("OK", MsgBoxStyle.OKOnly, "Confirmation")

End If


thanks

View 1 Replies View Related

Minimum Memory Requirments To Run SQL 2005 Workstation On Windows XP

Feb 22, 2006

We have a couple XP machines with only 256Mb of RAM and have Windows 2000 client tools installed. What are the minimum hardware requirements for SQL 2005 (Workstation) on an XP desktop?

My boss thinks since we have been blissfully ignorant and running fine with 256Mb then their is no need to upgrade memory in these machines.

I need a link to backup my argument.

This link wont help

http://www.microsoft.com/sql/editions/standard/sysreqs.mspx

As it doesn't specify workstation requirments to run SQL 2005.

View 2 Replies View Related

T-SQL (SS2K8) :: Select Minimum Date From Related Table

Apr 2, 2014

I am working on a query that seems very simple, but I just cannot seem to get it correct.

I want to be able to select Only 1 MemberAddress with the MIN(MoveDate) for each of the 3 Members. The results would be this:

Joe Smith, 2000-03-10, 1034 Sturgis Road, 115, Portland, Or, 77665
Sally Jones, 2001-01-02, 8970 Pierce Road, 25, Clear Bay, Washington, 96547
Beth Moore, 2006-05-30, 456 W. Blane Ave, NULL, Charleston, West Virgina, 56897

DECLARE @Members TABLE
(
MemberRowID INT IDENTITY(1,1) NOT NULL
,FirstName VARCHAR(20)
, LastName VARCHAR(20)

[Code]....

I am not opposed to using CTE, I really like them, but I cannot figure this one out. But I will try most anything.

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved