Database

*Developer Day Scotland - Free community conference
*Colin Angus Mackay's Blog
*Latest Scottish Developers Newsletter

7-Mar-09 12:20

It depends on what you mean by merge. But at a most basic level SQL Server is designed to be used by multiple users simultaneously.

I suppose if the uploaded data is meant to be uploaded in a specific sequence and the second set of data starts being "merged" before the first then you have a problem. If the data doesn't have that sort of constrant then I don't see there being a problem.

Will the two sets of data being uploaded overlap in anyway? e.g. they both cause the same row to be updated. If that is the case who wins? In other words which update gets retained, and which is overwritten or thrown away? If there is no over lap then there is no problem.

If the two sets of data pertain to only new information that is being added to the database then I don't see any real problem at all.

But, it really all depends on what you mean by "merge"

Vogon Building and Loan advise that your planet is at risk if you do not keep up repayments on any mortgage secured upon it. Remember that the force of gravity can go up as well as down.

Server 08 Execute SQL

enipla6-Mar-09 9:45

enipla

6-Mar-09 9:45

In SQL Server 08, the 'Execute SQL' ability is grayed out in the Query designer.

I don't see how it could be permisions because if I right click on the table and choose 'Edit top 1000 rows' I get the thousand rows.

Thanks

Colin Angus Mackay7-Mar-09 12:14

*Developer Day Scotland - Free community conference
*Colin Angus Mackay's Blog
*Latest Scottish Developers Newsletter

7-Mar-09 12:14

I'm not being silly, but does the query window have the current focus? The only time it greys out for me is when the Query window loses focus.

Vogon Building and Loan advise that your planet is at risk if you do not keep up repayments on any mortgage secured upon it. Remember that the force of gravity can go up as well as down.

enipla10-Mar-09 3:14

enipla

10-Mar-09 3:14

Yep it has focus. I open the query designer, add a table to it and right click in the designer.

The Execute SQL option is grayed out.

Is this how you operated it?

Thanks

Colin Angus Mackay10-Mar-09 13:29

*Developer Day Scotland - Free community conference Delegate Registration Open

10-Mar-09 13:29

enipla wrote:
query designer

Actually, I just discovered there is a thing called a Query Designer. I normally just write queries. I never knew about this crazy thing.

It is greyed out for me too.

Have you considered just writing the query SQL yourself? That isn't greyed out.

enipla11-Mar-09 3:28

enipla

11-Mar-09 3:28

Yeah, I can write the query myself, but the designer is VERY helpful, and that's how I'm used to doing it.

It worked in previous versions.

This is nuts. MS help hasn't been able to find anything.

uniting 3 tables

suni_dotnet6-Mar-09 5:28

suni_dotnet

6-Mar-09 5:28

Hi All,
iam using if else for updating and inserting, i need to do this for 3 tables how can i unite them using unions or join..

IF EXISTS (SELECT col1,col2,col3,col4
FROM TableB)

UPDATE TableB
SET col2=TableA.col2,
col3=TableA.col3,
col4=TableA.col4
from TableA
where (TableB.col1 = TableA.col1
and TableA.Col5='no')

ELSE
INSERT INTO TableB (col1,col2,col3,col4)
select TableA.col1,TableA.col2,TableA.col3,TableA.col4

from TableA
where TableA.Col5='no';

and i need to repeat this code for TableC and TableD (along with TableA) for updating TableB. How can i unite all in one procedure.Hope iam clear if not i can...Please help...
may be the solution is simple but i dont know...
i tried but unable to ...
i cannot use 3 sp's, i need all in one procedure
Thanks in advance

Re: uniting 3 tables

Colin Angus Mackay7-Mar-09 12:05

*Developer Day Scotland - Free community conference
*Colin Angus Mackay's Blog
*Latest Scottish Developers Newsletter

7-Mar-09 12:05

I don't fully see what you are trying to do. But if "unite all in one procedure" you mean that it all happens as one operation then you might want to look at transactions. If you wrap all of this up in a transaction it will appear as one procedure. Nothing else accessing the database will be able to see a half updated set of data. They'll either see the data as it was before the transaction, or they'll be locked out until the transaction is complete and when the lock is released they'll see it as the complete result.

Vogon Building and Loan advise that your planet is at risk if you do not keep up repayments on any mortgage secured upon it. Remember that the force of gravity can go up as well as down.

conditional select statment

Meax5-Mar-09 22:31

Meax

5-Mar-09 22:31

i have these data in the database table, Meetings

MeetingID Details Hour Minute
1 Meeting Details1 14 10
2 Meeting Details2 14 15

how can i select all the fields of MeetingID 2?

<br />
SELECT     MeetingID, Hour, Minute, Details<br />
FROM         Meetings<br />
WHERE     (Hour =<br />
                          (SELECT     MAX(Hour) <br />
                            FROM          Meetings)) AND (Minute =<br />
                          (SELECT     MAX(Minute) <br />
                            FROM          Meetings))<br />

but this code doesn't fetch any record

J4amieC5-Mar-09 22:42

J4amieC

5-Mar-09 22:42

Of course it doesn't - the row with the max hour might not be the same row as the row with the max minute.

If you stored the meeting time in a single field (of type datetime or smalldatetime) which would be the right solution, this would be easy.

SELECT TOP 1 * FROM Meeting ORDER BY MeetingDateTime DESC

As it is with your table you can just do

SELECT TOP 1 * FROM MEeting Order BY Hour DESC, Minute DESC

Meax5-Mar-09 23:14

Meax

5-Mar-09 23:14

thanks for helping out

Rupesh Kumar Swami5-Mar-09 22:58

Rupesh Kumar Swami

5-Mar-09 22:58

whether you search for MeetingID =2 or for which where Meeting time is maximum

I think you want to get the all detail of meeting for which meeting time is highest. use following query

 SELECT *<br />
FROM mettings<br />
WHERE (hour*60+minute) =(select max(hour*60+minute) from mettings)

hope this helps

Rupesh Kumar Swami
Software Developer,
Integrated Solution,
Bikaner (India)

My Company
Award: Best VB.NET article of June 2008: Create Column Charts Using OWC11

Meax5-Mar-09 23:16

Meax

5-Mar-09 23:16

thank you for helping out

J4amieC6-Mar-09 0:08

J4amieC

6-Mar-09 0:08

Rupesh Kumar Swami wrote:
SELECT *
FROM mettings
WHERE (hour*60+minute) =(select max(hour*60+minute) from mettings)

Why? Multiply the hour by 60 and add the minutes? If anything the other way round, surely?

Luc Pattyn6-Mar-09 0:42

Luc Pattyn

6-Mar-09 0:42

the math is fine, it is calculating minutes since midnight.
On a big table it could be slow...

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

- before you ask a question here, search CodeProject, then Google
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get
- use the code block button (PRE tags) to preserve formatting when showing multi-line code snippets