Is this valid ANSI SQL?: SELECT 1 AS X ,2 * X AS Y ,3 * Y AS Z Because Teradata (12) can do this, as well as this (yes, crazy isn't it): SELECT 3 * Y AS Z ,2 * X AS Y ,1 AS X But SQL Server 2005 requires something like this: SELECT X ,Y ,3 * Y AS ...

I just created a materialized view in Oracle but realized I used the wrong script, so I wanted to drop the MVIEW again. The MVIEW was created with a statement like this: create materialized view foobar refresh start with trunc(sysdate) + 1/8 next sysdate + interval '8' hour as select ... fr...

Is this valid ANSI SQL?: SELECT 1 AS X ,2 * X AS Y ,3 * Y AS Z Because Teradata (12) can do this, as well as this (yes, crazy isn't it): SELECT 3 * Y AS Z ,2 * X AS Y ,1 AS X But SQL Server 2005 requires something like this: SELECT X ,Y ,3 * Y AS ...

You were so close. You can use a little SQL trick for this. Just join questions to users with a 1 = 1 binding. SELECT * FROM tbl_category c , tbl_questions q JOIN tbl_users u ON ( 1 = 1 ) LEFT JOIN tbl_answers a ON (u.userID = a.userID AND a.questionID = q.questionID) W...

As documented in the article Statistics Used by the Query Optimizer in Microsoft SQL Server 2005 If you use a local variable in a query predicate instead of a parameter or literal, the optimizer resorts to a reduced-quality estimate, or a guess for selectivity of the predicate. Use parame...

I have one oracle database in which i have to invoke a stored procedure which fetch records from sql database.

Can I take it to a read only, non-restoring state, temporarily, to check the data, and then put it back to restoring, without breaking the whole restore chain? The key to that question is "breaking the restore chain." If you want to query and verify numbers, then standby mode in logshipping...

Brief Architecture: I am creating a SSIS package to generate Excel reports. There are different types of reports, So I have created a table to track each user request for report generation and tracking the status of request. A Sql job picks each request and generates the excel file on FTP server...

You can create 3-4 different data flow tasks within your control flow (inside the Foreach loop container). Place a sql script before the DF containers. You can have the script actually do something or not. The idea is to create a conditional from this task that leads to the 3-4 data flow tasks...