you have two queries that could potentially be comparing more than one row to a single value;

one is a simple test for a value:

if (select UNITE_COUT_MATERIEL from DIM_INTER_MATERIEL) =...

nicklibee I'm sorry if you took any of the comments here as harsh.

Sean and I,as well as other regular volunteers here have both contributed to tens or hundreds of thousands...

you still will need occupied/empty records at the individual seat level; you might organize them in cubes, but your level of detail is deeper;

i'd also like to see the DDL...

Sean Lange (6/25/2013)

---

I have a feeling this thread is going like the last one from the poster. http://www.sqlservercentral.com/Forums/Topic1465520-391-1.aspx

Lots of completely vague posts and suddenly, voila! The OP posts a complete...

that's an application error,and not SQL server.

a lot of applications will have a default connection timeout of 30 seconds, unless someone explicitly adds some longer timeouts to the connection string.

if...

ok if you have a master table of regions, you can join it agaisnt your transacitons? table?

;With Regions(REGION)

AS

(SELECT 'a' UNION ALL

SELECT 'b' UNION ALL

SELECT 'c' UNION ALL

SELECT...

well here's a runnable query base don your copy/paste, but i couldn't figure out where the b 0 0 data came from for the desired results;

if you can explain it...

lmacdonald (6/25/2013)

---

Oh nice, that may just work )

However my linked server is actually on the same machine, but another instance. There is a syntax error, it does not like...

ahh, you missed the point.

I created...

For Linked servers, i know you can do DDL commands, like CREATE TABLE, via EXECUTE AT;

I'd bet any other commands like the ALTER and CREATE ENDPOINT would work just as...

duplicate post.

There's no need to post the same question in multiple forums.

The Recent Posts>>Posts Added Today function which most people use shows us your post immediately.

crossposting will wastes people's time...

duplicate post.

There's no need to post the same question in multiple forums.

The Recent Posts>>Posts Added Today function which most people use shows us your post immediately.

crossposting will wastes people's time...

grab the trial version...

i don't think there is a hard and fast rule you can just say, it depends on the data and how often it gets accessed;

SQL will use all the RAM...

Lidou123 (6/25/2013)

---

Hi Lowell,

Thank u for your answer.

I tried to connect via linked server and that wooooorks !!!!!!!!!!!!!!! 🙂

Thank U.

So, now I can create a report and deploy it ??

Or I...