well, syntax wise, it's fine for SQL2008; i was able to create it without a problem.

on a SQL2005 or compatibility 90 database, i get an error because SQL2005 did not...

i would do a backup and restore as -a-new-database name so both sources are on a single instance, and then review the differences for either specific insert/update/delete, or a MERGE...

mister magoo i have a kinda-sorta solution i use for that issue; instead of a drag and drop, i have a keyboard shortcut in SSMS that i call on any...

psingla (6/26/2013)

---

use

if (select TOp 1 UNITE_COUT_MATERIEL from DIM_INTER_MATERIEL)= 'Unité'

or

if exists (select 1 from DIM_INTER_MATERIEL where UNITE_COUT_MATERIEL = 'Unité')

both the above query will work in your case.

sub query...

if you know the shape of the data being output from the procedure, you can insert it directly into a table;

for example, if your proc returns a single column table...

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...