Hi,

Replace the SELECT 'select table_name  with your own select alter table.

IF OBJECT_ID('TEMPDB..#COMMAND_LIST') IS NOT NULL

DROP TABLE #COMMAND_LIST

CREATE TABLE #COMMAND_LIST

(ID INT IDENTITY,

COMMAND VARCHAR(200))

INSERT INTO #COMMAND_LIST (COMMAND)

SELECT 'select table_name from information_schema.tables where...

select distinct *

from sys.fn_trace_geteventinfo(1) ei

inner join sys.trace_events e

on e.trace_event_id = ei.eventid

where name like '%grow%'

Hi,

Use a dataflow.

In your Source write a query to select all employees with > 15 year employment.

Map that to fields in your destination.

No muss no fuss.

I tend to save SPs...

Hi,

If you are receiving a multiple option parameter from SSRS it will be comma delimited. You can use this in dynamic SQL with an IN clause.

Cheers

Jamie

Hi

Use the ranged bar chart and set the start date to be your low range and the finish date to be your high range.

Cheers

Jamie

Hi

Put your query in a Stored Procedure so that it gets a saved execution plan.

Try the Attunity Drivers for Oracle.

Cheers

Jamie

Hi,

Try this.

Report Name

Purpose

Version

Date

Report Owner/ Target audience

Report Frequency:

Application Screen shots (for when the user doesn't understand the underlying databases)

Data sources eg HR database ->Table1

...

Hi,

1 Are you using one report to gather parameters which are passed to other reports?

or

2 Do you want to call specific reports programmatically with specific parameters?

You can call an...

Hi,

Pre format your data in a table.

Use the table as the data source for a tablix report.

Eg

--4 Col table

Group1 Col1

Group1 Col2

Group1 Col3

Group1 Col4

Group1 Col5

Group1 Col6

Group2 Col1

Group2 Col2

Group1 ...

Duly noted, Dennis.

Yes

Hi,

1. Are you hosting the database? If no, then customisable databases, but do it this way default schema for base application client schema for client based customisations. . If...

Hi,

Remember SEAT for testing.

Table A

(

Column1 varchar(4),

Column2 int

)

Setup

Select a row of data to be updated.

eg

Select Column1, Column2 from A where Column1 Is Null

Evaluate

Run the test/code

Insert into A_Changes

Select Column1, Column2...