Hi Ricky,

Please remove special characters and then check, it should work, When I put my code, it was tab for me, but it seems that Script editor has changed it...

Hi wildh

As I included URLs of several Time Dimension discussions, I think all are good enough to produce Time Dim, and infect I picked my base query one of them...

Hi,

These are the points based on that you may getting error meesage:

1. DATEFORMAT is set to MDY and you are storing as date in DMY format.

2. You may use...

Hi,

You can achieve this by implementing Security Module via Assemblies…

Thanks

Bhudev

Hi

You can find SSIS Documentation Generator for SQL Server 2005 free of cost. Please see following link.....

http://www.ssisdocumenter.com/download/SSISDocumenterSetup.msi

Thanks

Bhudev

Hi,

CASE 1: Start SQL Server Agent and see all Jobs for Packages

CASE 2: Run following command to view all Jobs

...

Hi,

Check it out Ad hoc Remote Queries is enabled or not. If not go to Surface Area Configuration and do activate it. And when fire the query close the Excel...

Everything is possible in SQL. Only need some work.

Approach 1: Already U know how U can use Dynamic SQL for the purpose.

Approach 2: If U have to use another db...

Good Work my friends.........But there is also..........

Another Approch!

Finally I would like to say U can do it with...

And U can fit in your Sp also.

And for calling another sp into sp use EXEC SpName Perameters

Hi Guys Good Efforts...

But why U are trying to split 2 temp tables. When we can do with simple one query. And doing this it will be faster because we'll...

Hi

It is simply possible with Triggers as well as OUTOUT with using INSERT Statement.

There is smaple programe of using OUTPUT Clause.

INSERT INTO dbo.EmployeeSales 
    OUTPUT INSERTED.EmployeeID, 
          ...

Hi Ninja's

Joe Celko The SQL Apprentice

Rows are not records; fields are not columns; tables are not files!!

Move over Donald Trump and Martha Stewart, this is geek apprentice...

Hi Ninja's RGR'us

Trully I know none of it. But it [Magic or Psudo Table] is asked a lot of times in my Interviews. That's why I'm using it.

And may...

Another Approch:

First do Ur Ad hoc query on. Then why not U create a View for Oracle data query using OPENDATASOURCE. Then U can use that view anywhere...