multi-pagereport.blogspot.com
Multi-page report: Multiple jobs on one schedule
http://multi-pagereport.blogspot.com/2012/03/multiple-jobs-on-one-schedule_3971.html
Friday, March 30, 2012. Multiple jobs on one schedule. I am wondering if its possible to run multiple backup jobs from one shedule. In SQL Server 2000, so all backups are triggered simultaneously at a given. Having looked at the sysjobs and sysjobsschedules tables in msdb it seems. They have a 1 to 1 relationship and this leads me to believe this is not. Possible. Has anyone else ever achieved this, and if so, how? The second backup will wait till the first one completed. What is the purpose? At the same...
multi-pagereport.blogspot.com
Multi-page report: Multiple joins in For XML Auto, Elements
http://multi-pagereport.blogspot.com/2012/03/multiple-joins-in-for-xml-auto-elements_30.html
Friday, March 30, 2012. Multiple joins in For XML Auto, Elements. I'm trying to join a number of tables to produce an xml from a stored. Procedure. The trouble is that the results from every new table I join get. Produced as a child node to the previous table's node. Select BG.*, CA.*, NA.*, ET.*. Left Outer Join CA (nolock) On BG.ID = CA.BGID. Left Outer Join ET (nolock) On ET.CAID = CA.ID. Left Outer Join NA (nolock) On NA.CAID = CA.ID FOR XML AUTO, ELEMENTS. Results in the follwing structure. The auto...
multi-pagereport.blogspot.com
Multi-page report: Multiple joins in a filter
http://multi-pagereport.blogspot.com/2012/03/multiple-joins-in-filter.html
Friday, March 30, 2012. Multiple joins in a filter. I'm using Sql 2005 and merge replication. I want to create a dynamic merge filter on a table but the data I filter on is only reachable by a few extra joins. For example:. I want to filter Table3. Table3 is joined to Table2 which in joined to Table1. Table1 contains the host name column that I use to filter i.e. host name = HOSTNAME(). I'm pretty sure I can't use AND in my dynamic filter clause but I just wanted to make sure. Thanks for your help. Multi...
multi-pagereport.blogspot.com
Multi-page report: Multiple Job Steps SQL 2000
http://multi-pagereport.blogspot.com/2012/03/multiple-job-steps-sql-2000_6216.html
Friday, March 30, 2012. Multiple Job Steps SQL 2000. I have 3 DTS packages I want to run after each other, in no particular. I have x3 jobs, each running one of the DTS using CmdExec. I don't want to run these jobs on individual schedules. I also don't want a. Single DTS package with x3 steps to achieve the same thing. I want visibility of Status etc available in the SQL EM Job view for each of. I created a single multi-step job, with each step invoking a DTS package. This allows me to maintain a single.
multi-pagereport.blogspot.com
Multi-page report: Multiple job steps
http://multi-pagereport.blogspot.com/2012/03/multiple-job-steps.html
Friday, March 30, 2012. I am creating jobs using SQL Server Agent, the job has multiple steps. Step2 creates group of reports to be executed only when step 1 is successful. Step3 creates group of reports to be executed only when step 1 is successful. I would like to execute step2 and step3 at the same time, step 3 is not depe. How I do that? I am thinking of creating another job to execute step3 after. Evaluating the status of step1,. Somebody has more efficient ideas? Conditionally or at the same time.
multi-pagereport.blogspot.com
Multi-page report: Multiple Join Query Problem
http://multi-pagereport.blogspot.com/2012/03/multiple-join-query-problem.html
Friday, March 30, 2012. Multiple Join Query Problem. I am trying to update a field in TblA based on the contents of a field in. TblB where 4 conditions match but I can't get it to work. ere is what I. Update TblA t Set [Show Name] =. Select Contest From TblB s. Where s.Date = t.Date,. SRegionalCode = t.Regional,. Sunit = t.unit,. SPF = t.[P or F]). How should that be coded? Update TblA Set [Show Name] =. Select Contest From TblB s. Where s.Date = TblA.Date and. SRegionalCode = TblA.Regional and. Multiple...
multi-pagereport.blogspot.com
Multi-page report: Multiple Job Steps SQL 2000
http://multi-pagereport.blogspot.com/2012/03/multiple-job-steps-sql-2000.html
Friday, March 30, 2012. Multiple Job Steps SQL 2000. I have 3 DTS packages I want to run after each other, in no particular. I have x3 jobs, each running one of the DTS using CmdExec. I don't want to run these jobs on individual schedules. I also don't want a. Single DTS package with x3 steps to achieve the same thing. I want visibility of Status etc available in the SQL EM Job view for each of. I created a single multi-step job, with each step invoking a DTS package. This allows me to maintain a single.
mssqlmistake.blogspot.com
MSSQL Mistake: Multi Value Parameters
http://mssqlmistake.blogspot.com/2012/03/multi-value-parameters_2752.html
Friday, March 30, 2012. I'm using a sql server Stored Procedure, that uses a defined parameter to pull the records. How can i make this stored procedure a multi value parameter. I select multi value in report parameters, and changed the where clause to IN but its still not working, when i select more then one parameter from the drop down list. Here is my stored procedure. Object: StoredProcedure [dbo].[PROC RPT EXPENSE DETAIL DRILLDOWN COPY] Script Date: 09/05/2007 13:49:09 * * * /. SET ANSI NULLS ON.
multi-pagereport.blogspot.com
Multi-page report: Multiple jobs on one schedule
http://multi-pagereport.blogspot.com/2012/03/multiple-jobs-on-one-schedule_30.html
Friday, March 30, 2012. Multiple jobs on one schedule. I am wondering if it's possible to run multiple backup jobs from one shedule. In SQL Server 2000, so all backups are triggered simultaneously at a given. Having looked at the sysjobs and sysjobsschedules tables in msdb it seems. They have a 1 to 1 relationship and this leads me to believe this is not. Possible. Has anyone else ever achieved this, and if so, how? The second backup will wait till the first one completed. What is the purpose? At the sam...
multi-pagereport.blogspot.com
Multi-page report: Multiple Job steps using same variable or one temp table
http://multi-pagereport.blogspot.com/2012/03/multiple-job-steps-using-same-variable_30.html
Friday, March 30, 2012. Multiple Job steps using same variable or one temp table. I need a constant to be available in multiple steps of a job (more. Specifically, getdate() from step one). I tried storing it in a variable or. Temp table but when I get to step two of the job and try to retrieve the. Value, I get "must declare variable." or "table does not exist" (depending. On which method I am testing). I did a little test and the SPID in each one of the steps is the same so. To drop it at the end and i...