I have finally got two stored procedures sp1 and sp2 which return results. 1- sp1 returns a dataset like: period Gross Net return...
The stored procedure returns fields i.e. field1, field2, etc... field1 has figures in percentages such as: 3.65, -1.22, 1.3, etc... field2 has the...
I have created a chart in ssrs 2008 report. The x-axis shows dates i.e. 30 jun 2010, etc... The dataset returns 18 records and each record has a...
Hello, I have put my web project (which uses reporting services) into the web server for testing. All works fine on th elocal machine but on the...
Hello, I am running a stored procedure (sp) in the Data tab so that I can create a dataSet. of the reporting services 2005. This dataset returns too...
Hello, There are thousand of records in tblMain and I am showing a few of those below... There are many records which are identical except for their...
sorry, incorrect post
Hi, I am running this query from my database. @PackageName varchar(100) set @Packagename = 'JobName' EXEC msdb..sp_start_job @job_name =...
Hello, I am trying to change the User name under which my created job is run under. i.e. in the General properties of the Step of the Job it shows...
Hi, My package uses the UNC i.e. the full path in the foreach loop container which works fine. When scheduling this package as a job, it seems that...
Hi, USing the script task I can get the name of the file being processed and pass it on to a variable. Question: How is it possible to start a...
Hi, How is it possible to write a sql query to replace the values with & to & This is a test data which has & in a number of...
Hi, I have a string as follows: "not" OR "hello you" AND NOT "office" OR "outside home" AND NOT "inside house" OR "maybe inside" How is it possible...
It seems Contains does not allow for placing the word "NOT" at the beginning as follows: ' NOT "Hello you" AND NOT "office"' Is there a way so that...
Hi, I tried: select * from Table1 where contains(field1, ' "redemption of notes" ') This returns anything that has the word "redemption" or "Notes"...
Sorry, incorrect post.
Hello, Using SQL, how is it possible to read the contents of an xml file please? Thanks
Incorrect post
How is it possible to alter this query so that for each value inside the xml field, I get one row. i.e declare @myTable table(ProfileID int,...
I have to use an existing store procedure (sp). The sp requires several parameters. ALTER PROCEDURE [dbo].[usp_INS_MyData] @System xml(CONTENT...
Separate names with a comma.
