How can I force a Next Iteration in a ForEach Loop container?
I am looping through a folder(ForEach Loop Container) looking for a specific File Name ( Child 'Script Task') to evaluate name).
If the current file is not the File Name I need, get the next file, other wise drop down to a Exec Proc task.
Is it possible to force "Next Interation' on the parent container?
Thanks - Covi
Not quite sure what you mean. In what circumstances do you want to 'force teh next iteration'?
-Jamie
sqlIs it possible to force a query plan on a Stored procedue. I have attempted the following and i receive a Incorrect syntax near the keyword 'OPTION'. Any ideas?
EXEC testdatabases..testprocedure
OPTION (USE PLAN N'
<ShowPlanXML xmlns=
"http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="0.5"
Build="9.00.1187.07">
<BatchSequence>
<Batch>
<Statements>
...
</Statements>
</Batch>
</BatchSequence>
</ShowPlanXML>
')
GO
You could use OPTION and USE PLAN only with SELECT/INSERT/DELETE/STATEMENTS. So move your plan in body of stored procedures.
If you couldn't change your stored procedure use Plan Guide by sp_create_plan_guide http://msdn2.microsoft.com/en-us/library/ms179880.aspx
I'm trying to select 5 rows of data from a query. Sometimes there is less than 5 rows of data in the result set.
Is there a way to FORCE a return of 5 rows - even if they don't exist? For example, returning some text such as "No Data" or NULL in the result set?
What I'm doing to return 5 rows of data:
Select top 5 *
From MyTable
I need help modifying this query to make sure I always get 5 rows of data.
Thanks!
There is no pre-defined settings available but you do something below,
Code Snippet
Create table #Data(
Id int,
Name varchar(100)
)
Insert Into #Data Values(1,100)
Insert Into #Data Values(2,100)
Insert Into #Data Values(3,100)
Select Top 5 * From
(
Select Id, Name from #Data
Union ALL
Select NULL, NULL
Union ALL
Select NULL, NULL
Union ALL
Select NULL, NULL
Union ALL
Select NULL, NULL
Union ALL
Select NULL, NULL
)
as Data
Order By Case When Id is NULL Then 1 Else 0 End , ID
|||
Code Snippet
CREATE TABLE #temp (test int)
INSERT INTO #temp SELECT 1
INSERT INTO #temp SELECT 2
INSERT INTO #temp SELECT 3
DECLARE @.counter as int
set @.counter = (SELECT COUNT(*) from #temp)
SELECT * FROM #temp
WHILE @.counter < 5
BEGIN
INSERT INTO #temp SELECT NULL
SET @.counter = @.counter + 1
END
SELECT * FROM #temp
DROP TABLE #temp
Adamus
|||Thanks for the prompt replies - both of these replies were helpful and answered my question!Hi.
Here is another suggestion: run distributed queries through SqlExpress/32. Here is a sample for MS Access:
http://gorm-braarvig.blogspot.com/2005/11/access-database-from-sql-200564.html
Hope this helps
|||In Agent, use an Operating System (CmdExec) step and use the copy of dtexec.exe in C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn
hth
Donald Farmer
|||Thanks, Donald. That worked like a charm.sqlHello All,
Is it possible to force a delete of a table even when another program is using that DB, and still has some view data on that specific table.
I know that I can delete tables if another program is just have connection to the DB, but not using the specific table I'd like to delete. Can it be done also on a viewed table?
You cannot delete (or alter) a table if there is an open cursor on it: the engine refuses to do so.
|||Thanks for your answer,
If so, is there a way to force a complete disconnect of a specific DB, then to delete the table?
|||Not that I know of...In a decision tree algorithm, is there a known way to force a branch at a top level? For exmaple, I have 30 known decision patterns that are going to be completely different and I don't want them to intermingle. I wanted to force a branch at the top node on one of the 30 patterns so I wouldn't have to create 30 mining models per client.
Brian
Interactive training of models (including partial tree definition) is not supported in SQL Server 2005 Data Mining.
In many cases, instead of 30 models per client it is possible to create a single model containing 30 trees, by using a nested table (which, effectively, has the same effect as forcing a branch at the top). This works easily, for instance, if your target variable has 30 states.
Could you please provide a few details on your known decision patterns?
|||Bogdan, thanks for the answer!
The project essentially has two nested tables of terms (from SSIS' term extraction) that a specific item uses. Each item is in the parent case table 30 times (once per group,state or view based on your vocabulary you'd like to choose). The state (or group) is an input into the model and it does seem to work great for some of the states but not others and that's why I was trying to force it to break at the state level.
Essentially, we're trying to determine that if a record mentions term X, Y and Z that it's a great item to client. The problem is that it's a great item to show one group of clients but not others (based on their state).
Brian
|||I was able to get the model to branch by changing the scoring mechanism and by making the value that I was trying to force the break on discrete. Thanks again for your help. Is there any plans in future releases to enable users to force a break?sqlIn a decision tree algorithm, is there a known way to force a branch at a top level? For exmaple, I have 30 known decision patterns that are going to be completely different and I don't want them to intermingle. I wanted to force a branch at the top node on one of the 30 patterns so I wouldn't have to create 30 mining models per client.
Brian
Interactive training of models (including partial tree definition) is not supported in SQL Server 2005 Data Mining.
In many cases, instead of 30 models per client it is possible to create a single model containing 30 trees, by using a nested table (which, effectively, has the same effect as forcing a branch at the top). This works easily, for instance, if your target variable has 30 states.
Could you please provide a few details on your known decision patterns?
|||Bogdan, thanks for the answer!
The project essentially has two nested tables of terms (from SSIS' term extraction) that a specific item uses. Each item is in the parent case table 30 times (once per group,state or view based on your vocabulary you'd like to choose). The state (or group) is an input into the model and it does seem to work great for some of the states but not others and that's why I was trying to force it to break at the state level.
Essentially, we're trying to determine that if a record mentions term X, Y and Z that it's a great item to client. The problem is that it's a great item to show one group of clients but not others (based on their state).
Brian
|||I was able to get the model to branch by changing the scoring mechanism and by making the value that I was trying to force the break on discrete. Thanks again for your help. Is there any plans in future releases to enable users to force a break?Hello All.
Does Sql 2005 support forced-later-compliation? Which is to say, can I create a view that access another view which has not been created yet? e.g. "Create Force View Foo" in Oracle.
Thanks,
Steve
You can only do that for stored procedures. This is known and filed in the BOL under "Deferred Name Resolution".HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
sql
