Database

mr_lasseter3-Dec-06 12:59

mr_lasseter

3-Dec-06 12:59

I am not sure in what context you are using this table, but if I was you I would seriously consider rethinking your design. What happens if records get entered into the table out of order? Is there a primary key on this table?

In addition, AFAIK there is no guarantee that select * from table will always pull the results in the same order.

Mike Lasseter

bayangan13-Dec-06 13:23

3-Dec-06 13:23

Actually there are 3 primary keys on the original table. I only pull out 2 definitive fields (value and date) from that table which is pointing out directly to the problem i had. Both fields are not primary keys.

I'm going to use the query in reporting service as a part of DataSet.

Re: query's problem with periode [modified]

mr_lasseter4-Dec-06 2:46

mr_lasseter

4-Dec-06 2:46

How do you determine that the first group of 100 is not the same as the second group of 100?

Mike Lasseter

bayangan14-Dec-06 13:55

4-Dec-06 13:55

This is a bank's application where for each change value, i need to store it's period, calculate tenor (max date - min date) and then times it with pre-stored fee to get amount to charge. Bank charge the customer based on change value, that's why the 100 must not be grouped, it has to be split

Table's below will be included as part of customer's invoice for Nov 2006

Stock        Period                    Amount   Tenor Fee (%) CCY Charge
  Stock001    1 Nov 2006 - 23 Nov 2006 100.000     22    0.03 USD     30
             23 Nov 2006 - 25 Nov 2006 200.000      2    0.03 USD     60
             25 Nov 2006 - 30 Nov 2006 100.000      5    0.03 USD     30
                                              SubTotal:     USD    120

I just wonder whether this query with period could be done with only 1 select statement. Is it possible or not using a bit complex group by statement.

-- modified at 20:04 Monday 4th December, 2006

mr_lasseter4-Dec-06 16:31

mr_lasseter

4-Dec-06 16:31

Is period stored as a field in the table?

Mike Lasseter

bayangan14-Dec-06 23:30

4-Dec-06 23:30

Colin Angus Mackay4-Dec-06 23:47

Colin Angus Mackay

4-Dec-06 23:47

bayangan1 wrote:
Actually there are 3 primary keys on the original table

Sorry for taking a pedantic interlude at this point, but...

A table can contain only ONE primary key. A primary key is always unique. A primary key can consist of multiple columns, this is called a compound primary key, however there remains only one primary key.

Upcoming Scottish Developers events:
* We are starting a series of events in Glasgow in 2007. Are you interested in a particular subject, or as a speaker?
* Developer Day Scotland: are you interested in speaking or attending?

My: Website | Blog | Photos

bayangan15-Dec-06 3:20

SQL server basic open connection problem

5-Dec-06 3:20

Oops, my mistake.. sorry. 3 foreign keys made up to a compound primary key.

tino003-Dec-06 1:10

tino00

3-Dec-06 1:10

Hello,
I'm newer in SQL sever, i'm having a problem to open a connectoin because the system tell me that the Named Pipes Provider aren't working.
I enabled it in the SQL Server configuration (cliente and server), but it sill not working.
Do you have any ideia to solve the problem?

Thanks,
Tino

System.Data.SqlClient.SqlException was unhandled
Message="An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"
Source=".Net SqlClient Data Provider"
ErrorCode=-2146232060
Class=20
LineNumber=0
Number=2
Server=""
State=0
StackTrace:
...

Tino

Re: SQL server basic open connection problem

Paul Conrad25-Dec-06 18:24

Paul Conrad

25-Dec-06 18:24

tino00 wrote:
When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.

You need to configure it to allow remote connections...Look into the Surface Configuration tool that comes with SQL 2005...

If you try to write that in English, I might be able to understand more than a fraction of it. - Guffa

SQL - Middle

Chira Chandra2-Dec-06 22:11

Chira Chandra

2-Dec-06 22:11

Hello All experts,
I am Jayachandra.C, My problem is
I am able to create New User in Oracle database and able to give previleges on sequences, insert, update like. User created. But when i am trying to create a table in the created user table is not creating. Please give me the solution & reason where i failed. please

thank you sir,

Jayachandra.C

Uploading Sql Database

Ashish Porwal2-Dec-06 1:40

Ashish Porwal

2-Dec-06 1:40

Hi....
I have devoloped website in asp.net.
I just upload the project using ftp. Its works,
but i dont know how to upload sql database on server.
Can anybody please help me, Pls give me full details.

I used connectionstring in web.config which works for localhost.
but what connection string i should use for uploding on net.

Re: Uploading Sql Database

Frank Kerrigan4-Dec-06 3:21

Frank Kerrigan

4-Dec-06 3:21

Does you hosting account support SQL or do you have to use an access database ?

Which db are you trying to use.

Blog Have I http:\\www.frankkerrigan.com

Query issue

Tauseef A2-Dec-06 1:38

Tauseef A

2-Dec-06 1:38

can any body tell me query about that if want to delete duplicate records from a table based on serial number and ID , means if i found two duplicate
records for a particular ID and i want to delete the shorter serial number record

hello

Re: Query issue

Eric Dahlvang4-Dec-06 8:02

Eric Dahlvang

4-Dec-06 8:02

Something like this:

delete mytesttable from 
(select id, minSerial 
	from (select count(*) as total,id, 
		(select min(serialnumber)  
				from mytesttable tInside 
				where tInside.id = t.id) as MinSerial
			from mytesttable t group by id)  as tbl 
	where total=2) as tbl
where mytesttable.id = tbl.id and mytesttable.serialnumber=tbl.minserial

--EricDV Sig---------
Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them.
- Laurence J. Peters

Tauseef A1-Dec-06 21:12

Tauseef A

1-Dec-06 21:12

hi

i want to create a variable based connection string in sql server ,using c#.net
i want to give data source field in the connection string after getting it from a computer name variable , is that possible . if so how ,, can any body tell me the syntax

hello

Re: hi

Frank Kerrigan4-Dec-06 5:57

Frank Kerrigan

4-Dec-06 5:57

Use strings....

eg....

<br />
<br />
string connStr;<br />
<br />
string Driver = "Driver={SQL Server};";<br />
string Database = "Database=db_name;";<br />
string connectionType = "Trusted_Connection=yes;";<br />
<br />
connStr = Driver + Database + connectionTypel<br />
<br />

Blog Have I http:\\www.frankkerrigan.com

scale down images in sql server

subai1-Dec-06 20:36

subai

1-Dec-06 20:36

hi i want to scale down an image in sql server 2005 stored procedure to get a thumbnail image from that.i was trying clr but the System.Drawing did not usable there do u have any suggestion ?

I Wish the Life Had CTRL-Z

[Message Deleted]

alexrad1-Dec-06 1:52

alexrad

1-Dec-06 1:52

[Message Deleted]

Eric Dahlvang1-Dec-06 4:07

Eric Dahlvang

1-Dec-06 4:07

Hope this helps:

SELECT CONVERT(DECIMAL (18,2),ROUND(deccolumn,2)) AS deccolumn FROM mytesttable

Also, check this out:
http://www.codeproject.com/script/comments/forums.asp?msg=1278600&forumid=1725#xx1278600xx[^]
Specifically #6.

--EricDV Sig---------
Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them.
- Laurence J. Peters

Marek Grzenkowicz1-Dec-06 4:08

Marek Grzenkowicz

1-Dec-06 4:08

declare @foo decimal(18, 6)<br />
set @foo = 123.45678<br />
select cast(@foo as decimal(18, 2))

And don't shout next time, please.

alexrad1-Dec-06 4:44

alexrad

1-Dec-06 4:44

I'M SORRY FOR NOT TELLING ALL DETAILS
NUMBER OF DECIMALS IS USER'S DATA
IF SOMEONE WANTS 2 DEC IN SOFTWARE EXISTS OPTION FOR SETTING

TAHNGS A LOT 2ALL