Viewing 15 posts - 1 through 15 (of 43 total)
Add an Alias under Native Client.
February 18, 2025 at 7:56 am
What about a server alias in SQL Config?
This is found under Native Client Config.
February 18, 2025 at 7:55 am
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...
December 24, 2021 at 2:23 am
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%'
December 5, 2019 at 6:07 am
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...
January 3, 2017 at 7:32 pm
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
December 7, 2016 at 12:15 am
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
December 7, 2016 at 12:03 am
Hi
Put your query in a Stored Procedure so that it gets a saved execution plan.
Try the Attunity Drivers for Oracle.
Cheers
Jamie
December 6, 2016 at 11:53 pm
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
...
December 6, 2016 at 11:33 pm
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...
December 6, 2016 at 11:23 pm
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 ...
December 6, 2016 at 11:05 pm
Viewing 15 posts - 1 through 15 (of 43 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy