Hi,
i am new to DTS and need to work with DTS.
Would you happen to have a Web link that contains a DTS for dummies online tutorial.
Is there a web site for step-by-step on how to use DTS ?
i will be thankful for your reply.
Regards,
Babbu
I have a stored procedure using dynamic SQL and I've been told I can no longer use 'exec (@strsql)' and have to use sp_executesql instead.
Fiiiiiiine...except I don't know how to use it and make it work with the parameter I'm passing in.
The original sproc that I have to change reads as:
CREATE PROCEDURE dbo.sp_LetsGetSomeData(@Filter nvarchar(200) = NULL)
AS
DECLARE @strSQL nvarchar(200)
IF @Filter IS NOT NULL
BEGIN
SET @strSQL = N'SELECT * FROM vwRandomViewName ' + @Filter
END
IF @Filter IS NULL
BEGIN
SET @strSQL = N'SELECT * FROM vwRandomViewName'
END
EXEC(@strSQL)
GO
And is called thusly:
EXEC sp_LetsGetSomeData @Filter = ' WHERE Team = ''RandomTeam'''
When I do this it never adds the filter. I tried to write a sproc like this:
CREATE PROC dbo.LetsGetSomeData2(@Filter nvarchar(200) = NULL)
AS
DECLARE @strSQL nvarchar(200)
SET @strSQL = N'SELECT * FROM vwRandomView'
EXECUTE sp_executesql @strSQL, @Filter
GO
and call it the same way as the original flavor sproc, it's as if I'm asking it to just select all from vwRandomView.
I know I'm doing something massively wrong but I'm just having a brain-dead day and can't make sense of the books online.
Ok, I'm an idiot. Does anyone out there have some step by step instructions for creating a report that will do mailing labels. I've got multiple columns on my report but I end up with the contents of each column being the same across each grouping/row. In other words for each record read, since I have three columns, I get three occurances of each customer and address until all the data selected for that row is presented, then I go to the next customer which again is repeated across all three columns.
I'm sorry I'm so stupid, but I've looked at other entries on the forum, and I just can't figure it out. We are trying to get out from underneith Business objects thumb and any help would be greatly appreciated. Thanks! - Eric -
Hi,
We have currently done one data ware house project with MS SQL server, reporting server, analysis server and integration server and the users are very happy with it (especially the speed).
The reports have been developed by a developer. I have years of experience in Visual studio, SQL, reports so I could do it very quickly. The users want to make their own reports so they need training. If I look at the requirements for most books and courses they are pretty hard. You must have some experience in SQL server. Or books are focussed on RS2000. Or the books could elapse the whole spectrum of SQL, ETL, cubes and reports or they go in to securing reports.
I think that is not the information that the users want to know. It should start with what is a cube, what are dimensions and what are facts. Then explain something in how do I get the information in excel. And then make reports in the visual studio environment (not the builder on the report server, but the report designer that comes with the client tools in visual studio). Keep in mind that they are not developers nor database administrators.
Any suggestions,
Constantijn Enders