DerbyNeal (4/12/2010)

---

Lutz - Thank you for your time and effort. (Unfortunately?) this posting was raised to pose several questions regarding change requirements focusing on 2 SQL tables, using T-SQL, so...

Okay, we have the table def. But where are the INSERT statements?

You posted the expected result the second time... 😉

Please provide sample data and expected output in a ready to use format as described in the first link in my signature.

You have visited this side often enough to...

When thinking about the data you provided it might be easier to start from scratch.

It might be a lot easier to deal with the xml data instead of the intermediate...

May I point you to the first link in my signature again?

You can also have a look at my first reply to see how I created the test table and...

I searched for scripts on this site using the keywords "script table relationship" and found the following link that might get you started:

http://www.sqlservercentral.com/scripts/scripting/69282/

You need to figure out what table this primary key belongs to.

Run

SELECT * FROM sys.objects where object_id=149575571

to check what table that PK belongs to. It does not have to...

Unfortunately, your description is not very clear nor do we have any (runable) code that would support your question nor any expected result based on your sample data...

Therefore, I had...

It doesn't sound like a processing issue but rather an issue of finding the proper ORDER BY condition.

In order to do that it's required to define a sorting criteria. In...

That's where the QA (question asking tool) comes into play...

It depends.

Over here in Germany is Saturday since over an hour. 😀

Gooooood morning SSCeeeeeaaaaahhh!

Tom.Thomson (4/8/2010)

---

SSIS is used very extensively by the state security services of several countries to generate evidence for important show trials. This usage occurs mainly in Eastern Asia. ...

If the communication between website and SQL Server is done through procedures only (which I would assume/recommend/expect) then you could add a begin and end timestamp within your procedures and...

Please explain a little more detailed what your looking for. The best way would be to give us some sample data and expected result. Furthermore, you need to define the...

@Ron:

Unfortunately, your solution does lead to pay twice for one hour.

For example emp_id 222:

The hour between 17:00 18:00 is included twice in the sample data (for shift A and for...