Viewing 15 posts - 4,711 through 4,725 (of 7,187 total)
Are you sure tm37_1_2_online isn't the database name, because dbo sounds like the schema name. Just swap it round with dbo and it should work.
As a bit of background...
February 14, 2012 at 3:22 am
Unless the USERS table exists in the default database for your user, you will need to qualify it with the database (and maybe also schema) name:
SELECT * FROM MyDB.MySchema.USERS
By the...
February 14, 2012 at 3:12 am
ram_kamboz2k7 (2/14/2012)
but does not work.
Error message? File not created? Data in wrong format in file? Other problem? Please be more specific, and help us to...
February 14, 2012 at 3:02 am
Welcome to SQLServerCentral. We're all to help you, however most of us draw the line at doing your homework for you. Please have a go at doing it...
February 14, 2012 at 2:53 am
Beware of SQL injection when you use dynamic SQL. I recommend you read this.
John
February 14, 2012 at 1:55 am
Please will you post some sample data and expected results based on that data? I'm struggling to understand whether you want everything between 7:30 and 8:30 on a particular...
February 13, 2012 at 8:37 am
Yes. After you restore the database from the backup, transactions commenced while the backup was being taken will either be rolled back or rolled forward, so that the database...
February 10, 2012 at 8:29 am
If you look at the properties of the Union All editor, you'll get a list of all columns in one input alongside a list of all columns in the other....
February 10, 2012 at 8:15 am
OK, so the MAJ Clients OLE DB Command only feeds the Union All (Tous les clients) transformation? Can you not restrict the number of columns in the output of...
February 10, 2012 at 6:57 am
Can you show us what your data flow looks like, please?
Thanks
John
February 10, 2012 at 4:31 am
Would you not just remove a column from the input?
John
February 10, 2012 at 3:57 am
I can't work out what your question is here. The way to use multiple CTEs is like this:
WITH CTE1 AS (
SELECT...
FROM...
WHERE...
), CTE2 AS (
SELECT...
FROM...
WHERE...
)
<Now use your CTEs here the...
February 10, 2012 at 2:37 am
Documented here
http://msdn.microsoft.com/en-US/library/ms177523(v=sql.90).aspx
In the section "Using UPDATE with the FROM Clause"
Thanks Mark - I knew it must be in there somewhere.
John might also like to read the BOL entry below which...
February 8, 2012 at 9:25 am
surely its down to the developer / administrator to realise that there is no guarantee what value will be used in the update.
Precisely. Would you use that syntax if...
February 8, 2012 at 8:40 am
Viewing 15 posts - 4,711 through 4,725 (of 7,187 total)