What version of SQLServer you are running?

I have tried:

select cd.* from [SERVERNAME].[master].[sys].[tables] cd

And it does work fine as expected.

Actually, should mention the following if your query uses joins between...

There is...

At least one,...

In your case it's very simple:

You just need to apply query optimisation techniques and your query will fly.

andrei.burdun (7/26/2011)

---

Thanks, but if I insert into tbl1 the following row in addition to your rows, the approach will not work anymore:

insert into tbl1 values

(null, '10', '1');

This row should...

Simple answer is Yes you can join to TVF (actually is main reason it was designed for).

Example:

CREATE FUNCTION fn_List ( @p1 int ) RETURNS TABLE

AS

RETURN

(

SELECT @p1 AS...

I've found your sample inconsistent. I guess you will have all pairs of related Id's

I have updated your sample to have all ID pairs. However my query should work...

What cluster Id you would give to company named as "Alfa Beta Omega Ltd"?

Do you check company names do match by the first word only?

In this case I do usually use ForEach loop container and simply copy the file into “Work” folder and renaming it to the fixed name. Then connection can be configured...

frfernan (9/30/2010)

---

Eugene Elutin (9/29/2010)

---

1. Your "Movements" table example looks very familiar to me (and I guess to many who worked with transactional data). From practical prospective I can say that...

1. If your clustered index is period and project_code, you better not insert anything which will be placed between existing data. Also, as you insert all data will be sorted...

The best thing I would suggest is to try insert all 8000 rows once (or in batches) with all required data populated.

If it is absolutely impossible in your case, I...

Post edited...

He is so well known that even googling for "Joe Celco" will find him easely! 😉

frfernan (9/29/2010)

---

...

At end of day, if you need to consolidate all movements (money movements, or warehouse movements) for this day - or week, or month -, you probably will start...

Nevyn (9/29/2010)

---

...

On the subject of non-clustered indexes, the issue would be the number of columns to be included. Even though they are only at the leaf level, it seems...

Nevyn (9/29/2010)

---

...NOTE: I have considered the idea of having an identity column for primary key and clustered index, and using a non-clustered index for this, but the issue is that...