Database

Re: newbie: returning multiple top 30 items

6-Aug-07 23:47

It's a really bad idea to try to "flatten" your structure this way. There are many ways that you could retrieve the data, but one approach would be to retrieve the data in the items information, and then perform a separate select inside the same procedure to retrieve the options based on the same criteria as you used to retrieve the item.

Then, all you need to do is (assuming you are using .NET), retrieve from the first table into a DataAdapter and retrieve the second table into the same DataAdapter as a new DataTable. In the data adapter, you would then create a relationship between the first DataTable and the second DataTable.

That's it. Search Google for creating master detail in ADO.NET.

Deja View - the feeling that you've seen this post before.

DQNOK7-Aug-07 9:09

DQNOK

7-Aug-07 9:09

Phillip Hodges wrote:
Hope that makes sense..

Uh, well maybe, sort of, a little...

If the 30 options are fixed (constants), then maybe you do want a PIVOT table like Colin suggested. Otherwise, I am confused about what you want. Perhaps an example would help. Or, if you already have what you need, well that'll work too.

David

change table owner to dbo

hepsy.i6-Aug-07 23:35

6-Aug-07 23:35

Hi i have imported tables from local to server and when i do those the tables will have owner as the project name or ..
But i'm unable to use the table in my stored procedure with a different owner its giving an error saying invalid object....
Can some one just help me by letting me know how i can change the owner to dbo...
If i create a table on the server then the owner is dbo only
but if i import only i'm getting this error

Hepsi

Pete O'Hanlon6-Aug-07 23:42

6-Aug-07 23:42

sp_changeobjectowner 'itemname', 'owner'

Deja View - the feeling that you've seen this post before.

hepsy.i6-Aug-07 23:53

6-Aug-07 23:53

should i write a stored procedure can u explain it clearly PLEASE because i'm new to these...
THANK YOU

Pete O'Hanlon6-Aug-07 23:55

6-Aug-07 23:55

hepsy.i wrote:
should i write a stored procedure

Errm no. Just execute it in Query Analyzer or Enterprise Manager.

Suppose you want to change the owner of the table myTable to dbo, you would enter

sp_changeobjectowner 'myTable', 'dbo'

and then execute it directly (using F5).

Deja View - the feeling that you've seen this post before.

hepsy.i7-Aug-07 0:01

7-Aug-07 0:01

Thank you very much ...
But my problem is i dont have query analyzer in my sys ..
Is there another way of doin this
Please help me..
THANK YOU

Pete O'Hanlon7-Aug-07 1:27

7-Aug-07 1:27

You could always write a program to execute the query. Be aware that you need to have admin privileges to change the information.

Deja View - the feeling that you've seen this post before.

hepsy.i7-Aug-07 1:55

7-Aug-07 1:55

Thank you,
I got it by using....
by opening table and clicking show/hide sql pane
Tahnk you

Mike Dimmick7-Aug-07 3:06

Mike Dimmick

7-Aug-07 3:06

Pete O`Hanlon wrote:
or Enterprise Manager

If you meant the new tool in 2005, it's called Management Studio.

The more I use this tool the more I realise that it's schizophrenic - it's actually both Query Analyzer and Enterprise Manager stuffed into one multiple-document-interface application. There are two query editors - one if you use Open Table (Enterprise Manager), another if you select New Query (Query Analyzer). All in all it's a bit of a mess.

Stability. What an interesting concept. -- Chris Maunder

Pete O'Hanlon7-Aug-07 3:25

How to install MSDE 2000 client components by command prompt

7-Aug-07 3:25

You're right - I did mean Management Studio, and yes - it is a complete and utter mess. I particularly hate the stored procedure templates - the old Enterprise Studio way was fine for me. Nothing got in the way.

Thanks a lot MS. Mad | :mad:

Deja View - the feeling that you've seen this post before.

Far sh6-Aug-07 22:58

Far sh

6-Aug-07 22:58

Hello Friends,

Actually i want to ask, how to install the SQL Server Desktop Edition 2000 Client Tools only from the Command Prompt ? i have gone through the internet but all the responds were about SQL Server Desktop Edition 2005, and it does not work for SQL Server Desktop Edition 2000.
I just could find the below command to install the full package:

setup.exe sapwd=abc123 sequritymode=sql disablenetworkprotocols=0

Could you please help me to get this done,

Appreciate your kind consideration,

Best Regards,
Farhad.

Re: How to install MSDE 2000 client components by command prompt

Mike Dimmick7-Aug-07 4:18

Mike Dimmick

7-Aug-07 4:18

There are no separate client tools for MSDE 2000. The only tool supplied by Microsoft is osql. The SQL Server 2000 ODBC driver and OLE DB provider are part of the Microsoft Data Access Components (MDAC) version 2.6 and later. Windows XP comes with MDAC 2.7 (under Windows File Protection) and Windows Server 2003 with version 2.8. You must run MDAC_TYP.EXE to install these, if using an older version of the OS (Windows 2000 comes with MDAC 2.5 under Windows File Protection).

See How to manage the SQL Server Desktop Engine (MSDE 2000) or SQL Server 2005 Express Edition by using the osql utility[^].

Stability. What an interesting concept. -- Chris Maunder

Full Text Searching Questions

Brendan Vogt6-Aug-07 22:43

Brendan Vogt

6-Aug-07 22:43

Hi,

I am using SQL Server 2005, and I have a couple of questions. My contains can look something like the following:

...CONTAINS(fldBriefDescription, ' "metal" ');
...CONTAINS(fldBriefDescription, ' "metal" AND "hooks" ');

I have a textbox for my search text.

If the user types in hook, and I need it to bring back records that contain the word hook and hooks, and not just hook.

If I type in somthing like today's then it bring back no results. I know for a fact there is such text in the brief description table field. Is it possible to bring back the same results if I type in todays instead of today's or just plain today?

If I type in "metal hooks" then I need it to search for metal hooks, and not just metal and hooks.

I need to use a CONTAINSTABLE to rank the results, and I do not understand how this works. Please can some help me construct the CONTAINSTABLE??

Please can someone help.

Regards,
ma se

SQL Query

sangramkp6-Aug-07 22:05

sangramkp

6-Aug-07 22:05

I have a table MyTable with columns col1,col2,col3,col4,col5 in which col1,col2,col3 comprises of composite primary key.

I want to find the number of rows that have different col3 values for same col1 and col2 values.

I want a stored procedure which will provide @c1, @c2 as parameters

Need help

Re: SQL Query

Pete O'Hanlon6-Aug-07 22:14

6-Aug-07 22:14

What have you tried so far? While I could do the query for you, it's helpful to see that you have attempted to do this yourself.

As a hint though, consider using the DISTINCT and COUNT() functions with the parameters to get the count of each. Have a go, and then let me know if you need more help (posting the SQL that you've attempted).

Deja View - the feeling that you've seen this post before.

help ....

B.A6-Aug-07 20:43

6-Aug-07 20:43

hi

i run a query in sql server 2005 , that show me follow error message ! how can solve this problem?

<br />
Msg 468, Level 16, State 9, Line 1<br />
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Arabic_CI_AS" in the equal to operation.<br />
<br />

tanks

originSH6-Aug-07 22:00

originSH

6-Aug-07 22:00

1. "help ...." is not a good post title. "Collation problem in equals operation" would have been a much better one.

2. http://www.google.co.uk/search?hl=en&q=Cannot+resolve+the+collation+conflict+between++and++in+the+equal+to+operation.&btnG=Search&meta=[^] Google knows alot about this problem.

B.A6-Aug-07 22:14

6-Aug-07 22:14

yes

you say right

tanks so much

Pete O'Hanlon6-Aug-07 22:06

6-Aug-07 22:06

Cross posting is not a good idea. I believe that Christian has already answered this one for you.

Deja View - the feeling that you've seen this post before.

B.A6-Aug-07 22:11

6-Aug-07 22:11

yes
but in SQL part usually response not fast .

Pete O'Hanlon6-Aug-07 22:17

6-Aug-07 22:17

That doesn't matter. There are rules for using the forums, and you have to respect them. The forums are frequented by developers who give their time freely, so you operate on their timescales. This is one of the reasons why you don't use the word Urgent in your post anywhere.

Plus, you do need to think of more meaningful titles than help.... You'll find that a better post title will generally get you an answer quicker than random wording.

Please see this[^] article for more information.

Deja View - the feeling that you've seen this post before.

B.A6-Aug-07 22:54