Re: CURSOR bad in Oracle and MySQL as well? - Database Discussion Boards

Mycroft Holmes20-Apr-09 23:19

20-Apr-09 23:19

Highly likely your file is on your local c drive and you are executing the bulkcopy on the server so it is looking at the servers c drive!

Never underestimate the power of human stupidity
RAH

Chart Action

Hakmeh Mohannad19-Apr-09 19:15

Hakmeh Mohannad

19-Apr-09 19:15

Hi I have to reports A and B
A is main report which contain pie chart
when i click on any part of the chart i'll jump to the next report B

now i have two ways to do this

one: select Jump to report action but the problem is am displaying the report in aspx page using ReportViewer because i only have one reportviewer and can only define one path for it

two: select Jump to url action and it alomst work but am stil facing another problem which is how to get the value from the clicked part of the chart and pass it throw Query String, if i wrote the url in following case it will consider it all as string
- http://www.mysite.com/mypage.aspx?Param=&Fields!myField.Value -

but if i wrote it like next one it will discard the url i wrote and took me directly to the server of reporting services and display thw value of the field
- "http://www.mysite.com/mypage.aspx?Param="&Fields!myField.Value - it will take me to
- "http://ReportingServicesAddress/"XXX

so can you help me with any one of those

thank in advance

Help in Querry

Saiyed Alam19-Apr-09 3:42

Saiyed Alam

19-Apr-09 3:42

Hello
I have a column name RegionID in my table name tblAllSale. The column RegionID has values like

C1H1D01
C1H1D02
C2H1D01
C2H1D02
C3H1D01
C3H1D02
.......

Now I need to show all the columns of the table based on the first two character of the column name RegionID. Something like this:

C1 AZN BVG 54
C1 AZK HNJ 76
C2 AVK JMK 45
C2 ALO HNO 89

Now how can I do this..??

Thanking in Advance
Johnny

Re: Help in Querry

Luc Pattyn19-Apr-09 3:49

Luc Pattyn

19-Apr-09 3:49

googled "SQL substring": http://www.1keydata.com/sql/sql-substring.html[^]

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

Avoiding unwanted divs (as in "articles needing approval") with the help of this FireFox add-in

Re: Help in Querry

Saiyed Alam19-Apr-09 3:58

Saiyed Alam

19-Apr-09 3:58

Thanks.

Re: Help in Querry

Niladri_Biswas1-Jul-09 18:09

Niladri_Biswas

1-Jul-09 18:09

Try this,

SELECT SUBSTRING('C1H1D01',1,2)

Smile | :)

Niladri Biswas

CURSOR bad in Oracle and MySQL as well?

devvvy18-Apr-09 22:33

devvvy

18-Apr-09 22:33

hello

CURSOR bad (Performance) in Oracle and MySQL as well? Or just M$SQL?

Thanks

dev

Re: CURSOR bad in Oracle and MySQL as well?

Colin Angus Mackay18-Apr-09 22:44

Colin Angus Mackay

18-Apr-09 22:44

Cursors generally don't perform well in any database. Although I read that Oracle have done a lot of work to optimise cursors so it may not be as bad in Oracle. However, it is generally best to do as much as you can using set based queries (i.e. queries that operate on a lot of rows at once) as that is what databases are good at.

*Developer Day Scotland - Free community conference Delegate Registration Open

Re: CURSOR bad in Oracle and MySQL as well?

devvvy18-Apr-09 22:45

devvvy

18-Apr-09 22:45

Thanks

dev

Re: CURSOR bad in Oracle and MySQL as well?

N a v a n e e t h20-Apr-09 17:08

N a v a n e e t h

20-Apr-09 17:08

Colin Angus Mackay wrote:
I read that Oracle have done a lot of work to optimise cursors

Yes that's right. In fact, I think it is the only way to return a set of results from a oracle stored procedure.

Smile | :)

Navaneeth

How to use google | Ask smart questions

Query Problem ( INNER JOIN)

mrkeivan18-Apr-09 0:24

mrkeivan

18-Apr-09 0:24

Hey, Guys Let me just lay out the problem:
I have 2 tables

table Function
FID
FName

Table Materials
MID
MName
FunctionID1 (foriegn key for FID)
FunctionID2 (foriegn key for FID)

Now I want to select all columns from Materials table, instead of FunctionID1 and FunctionID2, I want to have their related text (FName).

SELECT M.MID, M.MName, F.FName, F.Fname FROM Materials AS M INNER JOIN Function AS F
ON FunctionID1=F.FID OR FunctionID2=F.FID 
WHERE FunctionID1 = X(input) and FunctionID2 = X(input)

I want this query to search for records in which FunctionID 1 is The input or FunctionID2 is equal to related input!!!! buy when I do this, It fetches two rows for a row and in each one FunctionID1 and FunctionID2 are the same !
How should I fix this???

Re: Query Problem ( INNER JOIN)

Mycroft Holmes18-Apr-09 2:21

Mycroft Holmes

18-Apr-09 2:21

If the content of the rows is the same DISTINCT might be useful. Using OR in a join statement is always going to cause you problems.

You may also want to use sub selects, do your initial filtering in the from (select)

Select *
from (Select * from Function where Id1 = @ID1) X

Never underestimate the power of human stupidity
RAH

Re: Query Problem ( INNER JOIN)

Syed Mehroz Alam18-Apr-09 19:26

Syed Mehroz Alam

18-Apr-09 19:26

How about using two joins like this:

SELECT M.MID, M.MName, F1.FName, F2.Fname 
FROM Materials AS M 
INNER JOIN Function AS F1 ON M.FunctionID1=F1.FID 
INNER JOIN Function AS F2 ON M.FunctionID2=F2.FID 
WHERE FunctionID1 = X(input) and FunctionID2 = X(input)

Regards,
Syed Mehroz Alam

My Blog
My Articles

Computers are incredibly fast, accurate, and stupid; humans are incredibly slow, inaccurate and brilliant; together they are powerful beyond imagination. - Albert Einstein

Re: Query Problem ( INNER JOIN)

Ben Fair21-Apr-09 11:08

Ben Fair

21-Apr-09 11:08

Actually, I think you'd want to use two LEFT OUTER JOINS, as you'll want to return a match on FunctionID1 or FunctionID2 (unless I've read this all incorrectly):

select M.MID, M.MName, F1.FName [F1Name], F2.FName [F2Name]
  from Materials M
  left outer join Functions F1 on F1.FID = M.Function1ID
  left outer join Functions F2 on F2.FID = M.Function2ID
 where F1.FID is not null or F2.FID is not null

The WHERE clause will elimitate records where neither the Function1ID nor Function2ID match the input value. And the double LEFT OUTER JOINs will cause records where either the Function1ID or Function2ID match the supplied input value to be pulled.

Hope in one hand and poop in the other; see which fills up first. Hope and change were good slogans, now show us more than words.

Insert Trigger for Updating Count of One Column Into Another Column.

VikashGohil17-Apr-09 20:54

VikashGohil

17-Apr-09 20:54

Hello,

I am new to Writing Triggers in SQL Server 2000.

I have not written any triggers uptil now.

So it would be great if someone helps me in this problem.

I have a table with a field Serial No and SrCount

I want to write a trigger such that when a record is added in the table, it will take the serial no of the new record and get the count of that serial no present in the table and update the SrCount field in the new record with the Count Results.

Please anyone could help, I am totally new to triggers.

Any help could be of great help.

Thanks in Advance. Sniff | :^)

Re: Insert Trigger for Updating Count of One Column Into Another Column.

Eddy Vluggen18-Apr-09 0:57

Eddy Vluggen

18-Apr-09 0:57

Do you know how to update the SrCount without using a trigger?

I are troll Smile | :)

Re: Insert Trigger for Updating Count of One Column Into Another Column.

Mycroft Holmes18-Apr-09 2:25

Mycroft Holmes

18-Apr-09 2:25

Feels like a design error to me, I would ask why you need to count stored in another table.

Triggers are EVIL, debugging triggers can become a support nightmare. If it was essential I would do the update in the insert procedure rather than use a trigger (achieves the same thing, almost, but is easier to support).

Never underestimate the power of human stupidity
RAH

Re: Insert Trigger for Updating Count of One Column Into Another Column.

Le centriste23-Apr-09 9:24

Le centriste

23-Apr-09 9:24

Stay away from triggers. You should do that within the stored procedure that does the insertion.

Also, be aware of concurrency issues (like race conditions).

SQL Server convert

sasan5617-Apr-09 7:21

sasan56

17-Apr-09 7:21

Hi Can i convert an SQL Server 2005 bank file to SQL Server 2000?

Re: SQL Server convert

Henry Minute17-Apr-09 8:37

Henry Minute

17-Apr-09 8:37

In theory, and depending entirely on the structure of the 2005 database, possibly.

But given the way you have worded the question, I doubt it.

Why would you want to?

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

E-R Diagram Draw Help PLS

LostChip17-Apr-09 6:17

LostChip

17-Apr-09 6:17

Helloo all..I need to identify the entities and relationship for a company's database and then draw a suitable set of E-R diagrams. Draw a DFD and perform a structure Analysis to produce and appropiate Structure Chart. I am stuck with this and would like to ask if anyone could help me out with this.

Need a database to keep track of the stock in each outlet as well as customer information. It has supplies of electrical goods which include such items as:

cables
plugs and sockets
light bulbs
fire alarms
security alarms
CCTV equipment

these goods are produced by different manufacturers, a particular outlet will have different manufacturer's versions of the same item. In the new database must be stored the following:

the address and telephone numbers of all the outlets
a stock inventory for each outlet, stating the quantity of each item currently in stock and the date of the next delivery. for each item must be listed:

a full specification of the item
the manufacturer's contact details
the item's current price
any discounts currently available

Re: E-R Diagram Draw Help PLS

riced17-Apr-09 6:31

riced

17-Apr-09 6:31

This smells like homework so I refer you to all the responses that such questions elicit on this forum. Smile | :)

Regards
David R

Query HElppp.....!!!!!

Marla Sukesh16-Apr-09 23:50

Marla Sukesh

16-Apr-09 23:50

I Have 3 Tables
1.
Productmaster:
Columns:ProductId,PName,PDescription

2.
Attributes:
Columns:AttributeID,attName
this Table has Three Entries
1 Brand
2 Category
3 Artist

3.ProductAttributeValues
Columns:paId,ProductId,AttributeID,AttributeValues

Conditions:1 Product can have Multiple Attributes

Needed Output
--------------------
ProductId | ProductDesc | Brand | Category | Artist..
1 sadasd Brand1 Category1 Artist1
2 sadasds Brand2 Category3 Artist4

I NOt Getting What should I Do To Get This O/p
Pls Help Me
Please
Thanks in Advance

Re: Query HElppp.....!!!!!

Rajesh Anuhya17-Apr-09 0:08

Rajesh Anuhya

17-Apr-09 0:08

Try This

select * from Productmaster a,ProductAttributeValues b,Attributes c
where a.ProductId=b.ProductId and b.AttributeID=c.AttributeID

Thanks

Rajesh B --> A Poor Workman Blames His Tools <--

Re: Query HElppp.....!!!!!

Marla Sukesh17-Apr-09 0:14

Marla Sukesh

17-Apr-09 0:14

u r not getting this is not so easy
there r 3 entries for each product in productattributevalues table
thats why i am adding 3 columns to the output with values displaying attValue

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.