BCP on client machine My understanding is that BCP is in the class of 'Client Tools' that are available to install on any client computer that is licensed with a CAL, or to access a SQL Server that is licensed with a Processor license.
For definitive answers about licensing, contact the licensing forks at:
Licensing ¨CMicrosoft, Contact (800) 426-9400
From: http://www.microsoft.com/sql/howtobuy/faq.mspx
Do I need a separate license to run the SQL Server tools and analysis services
A.
No, a separate license is not required. However, any device that has SQL Server tools or technologies installed must have a valid SQL Server license.
Note: Most of the 'Client Tools' are NOT included with SQL Server 2005 Express Edition. There is, however, a special version of SQL Server Management Studio Express available. Tag: How Extract the data of TFINF when doing text mining? Thanks
foodmart database? Hello
I am learning to use Analysis Services 2005. I have downloaded and restored the backup of the Foodmart 2000 (for 2005).
Can I get the database as mdf file (like AdventureWorksDW)
Thanks,
jsmith Tag: How Extract the data of TFINF when doing text mining? Thanks
SQL Server 2005 JDBC Driver v1.1 and SSL Hi folks, I'm trying to figure out if the SQL Server 2005 JDBC driver supports SSL at all. I've downloaded the driver documentation, looked at more web pages than I care to count, and even went as far as to take a stab at guessing at different driver property names in the hopes I might discover some undocumented feature. Each time I try, I come up dry. The following exception shows up in my JBoss log: 2007-01-03 12:13:36,812 WARN [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Throwable while attempting to get a new connection: null org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (com.microsoft.sqlserver.jdbc.SQLServerException: The SQL Server login requires an SSL connection.) I know I have things working properly on the SQL Server side, as both osql and Query Analyzer work fine, and packet sniffing yields no plain text information. I've also tried swapping in the open source JTDS driver, and once again, sniffing shows that the data between the two machines in encrypted. Does anyone know if I'm just missing something completely obvious, or can someone state with absolute certainty that the driver does not support SSL Any ideas on how to find out if there are plans to support this feature and what the timeline might be Thanks in advance. Trev. Tag: How Extract the data of TFINF when doing text mining? Thanks
Loading excel file(.xls) into sqlserver (ASP.net web application)(ASP.net framework 1.0) Are you trying to upload contents of the Excel spreadsheet into a database table
This is a pretty common scenario and there are lots of good examples on how to do this on MSDN. A good overview is available here: http://msdn2.microsoft.com/en-us/library/aa159896(office.11).aspx
One option that I haven't tried but that looks totally cool is to use Integration Services. Check out the "How To" article at http://msdn2.microsoft.com/en-us/library/ms345182.aspx . Another article is also available at: http://msdn2.microsoft.com/en-us/library/ms403358.aspx
These do, however, seem to be about aggregating data that permanently resides in an Excel file...your scenario seems to be using Excel as the data-entry "front end" for a SQL Server repository. For that, you could consider using Visual Studio Tools for Office (either the 2003 http://msdn2.microsoft.com/en-us/library/aa167896(office.11).aspx or 2005 version http://msdn2.microsoft.com/en-us/library/aa167897(office.11).aspx ). You would probably be specifically interested in: http://msdn2.microsoft.com/en-us/library/aa192473(office.11).aspx
It is also possible to do this using Visual Basic for Applications macros in Excel that use ADO. Note, however, that default settings will typically disable macros unless they are digitally signed. If you're interested in this approach, there is lots of good documentation in the Excel programming help (I think...it's been a while since I tried this) and there is a good article on MSDN at http://msdn2.microsoft.com/en-gb/library/ms524771.aspx . Although the article is focused on a web application, you could either upload the file to your server as you were initially planning and then use this code as-is or you could quite easily port the code into a VBA macro and communicate directly from Excel to your SQL Server database. Tag: How Extract the data of TFINF when doing text mining? Thanks
compact sqlce database Yes, you can download all engines withing SDK from here:
http://www.microsoft.com/sql/editions/compact/default.mspx
resp.
http://www.microsoft.com/downloads/details.aspx FamilyId=E9AA3F8D-363D-49F3-AE89-64E1D149E09B&displaylang=en
may be other tools from this web may help you too.
Without VS2005, you can manage database through
free SQLServer Management Studio Express
http://www.microsoft.com/downloads/details.aspx FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&DisplayLang=en
I dont know if is possible to verify/repair from this gui app, but at least you can
build small C# or VB.NET desktop project against new engine, using your corrupted database
and try verify/repair methods.
Petr Tag: How Extract the data of TFINF when doing text mining? Thanks
Database design - best practices Does anyone know the location of an offical (Microsoft if possible) document that shows the best practices for databse design
For instance what to call tables now schema's exist
Should it be
Countries
LookCountry
Geography.Country
Geography.Countries
What about Views and Stored procedures prefix with VW_ sp_ or some alternative
Thanks Tag: How Extract the data of TFINF when doing text mining? Thanks
How do can I do this? Maybe something like this:
declare @mock table (colA int, colB int) insert into @mock values (1, 2) insert into @mock values (2, 1) insert into @mock values (2, 6) insert into @mock values (3, 6) insert into @Mock values (6, 3) insert into @mock values (6, 7) insert into @mock values (7, 6)
select * from @mock x where not exists ( select 0 from @mock y where x.cola = y.colb and x.colb = y.cola )
-- ------- Output: -------
-- colA colB -- ----------- ----------- -- 2 6 Tag: How Extract the data of TFINF when doing text mining? Thanks
OLE DB Source to Flat File Destintation using Fixed Width Columns - determining source column width Thanks for the info, from that I found another way to do it with the help of a co-worker.
select c . id , t . name , t . xtype , c . name , c . length , c . xprec , c . prec from syscolumns c ,
sysobjects t
where t . id = c . id
and t . xtype = 'U'
Is what we used, and the c.prec value seems to be the value I want, so with this query, I can get the prec value for any column by doing another select statement where I match up the column names. Thanks! Tag: How Extract the data of TFINF when doing text mining? Thanks
date picker format thanks for your reply adolf...
my pc regional setting:
Regional Options tab :
Standard and formats:
English (United Kingdom)
Short date: 14/06/2007
Long date: 14 June 2007
Location : United Kingdom
Advanced tab:
Language for non-Unicode programs:
English (United Kingdom)
anywhere else to check thanks! Tag: How Extract the data of TFINF when doing text mining? Thanks
Data disappearing during Run time This is what Mike is refering to: http://blogs.msdn.com/sqlexpress/archive/2006/07/17/668971.aspx HTH, Jens K. Suessmeyer.
--- http://www.sqlserver2005.de --- Tag: How Extract the data of TFINF when doing text mining? Thanks
Old problem, but... Cannot open user default database. Login failed. Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. I didn't use SQL Express before, now I am trying to use it. I thinkk it is convinient if you just want to copy db files to user's machine. like this
<add name="schsecurity" connectionString="Data Source=.\SQLExpress;Integrated Security=true;User Instance=True;AttachDBFilename=|DataDirectory|aspnetdb.mdf" />
as long as user has sql express installed, he should be able to use the db once he copy the file aspnetdb.mdf over.
but when I tried it, I got
Cannot open user default database. Login failed. Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
it looks simple, SQL express can not verify user 'NT AUTHORITY\NETWORK SERVICE'
so I connect SQL express with SQL server management studio, and add the user into login of the SQL express and set the user as sysadmin. But I still get the error.
Any idea
thanks! Tag: How Extract the data of TFINF when doing text mining? Thanks
Data Conversion Hi,
Lots of different data types the destination table fields are mailny int, bigint varchar, date and decimal
Thanks,
Dave. Tag: How Extract the data of TFINF when doing text mining? Thanks
Results from Aggregate() are wrong As explained in Mosha's blog , Aggregate() used as a slicer in a WHERE clause will effectively be replaced by a set of the same members (in AS2005). So the classic multi-select problem that could arise is when HIERARCHIZE ( AddCalculatedMembers ({ DrillDownLevel ({[Product].[Product Indexing].[All]})})) includes a calculated member which uses (in your case) [Product].[Product Species].CurrentMember directly. Tag: How Extract the data of TFINF when doing text mining? Thanks
Inconsistent Linked Server Query Results Hello,
I have a linked server named 'Charlie_File' to an Excel Workbook that I set up in SQLServer 2005 Management Studio. The workbook is on my local C drive. Sometimes, I get the results back that I expect when I run the following query;
SELECT * FROM OPENQUERY ( Charlie_file , 'SELECT * FROM [Feb$]' )
Sometimes, on subsequent runs of the above query, I get the following message;
Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "MSDASQL" for linked server "Charlie_file" reported an error. The provider did not give any information about the error. Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "Charlie_file".
There seems to be about a minute or so of a delay before the query will run correctly on subsequent attempts. Is there a connection issue here where a connection blocks subsequent attempts to select the data within a specific time span
Thank you for your help!
cdun2 Tag: How Extract the data of TFINF when doing text mining? Thanks
Can't get Dynamic Security working ... The expression that you provided above should only be set on DDO attribute. Please remove it from all other attributes. Tag: How Extract the data of TFINF when doing text mining? Thanks
Sql Query to create nested XML Sitemap OK. Could you look at this previous post and comment on whether this is the sort of thing you are trying to do; I am not completely sure what I am aiming at.
http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1703535&SiteID=1 Tag: How Extract the data of TFINF when doing text mining? Thanks
Passing SELECT ALL from URL Oops sorry, the example where I craft the select all was for a single select or a pre-SP2 install.
For a multi-select with built-in Select all you would actually just use the standard list of values. here the trick to avoid a huge Where Item is IN ('a', 'b', 'c',......) would be to do it like this
Procedure parameter
, @Item varchar (Max ) = '##'
Procedure handling of ALL option.
declare @NKeyCount as int
declare @NKeyMax as int
set @NKeyCount = onglobals. dbo .fn_CountChar( @Item , ',' )
set @NKeyMax = (
Select Count ( Distinct b.Item_Cd) as Value
from meta_NewProductBaseline b
)
if @NKeyCount + 1 = @NKeyMax begin set @Item = '##' end
If @Item is null begin set @Item = '##' end
Procedure limit
And ( @Item = '##' or b.Item_Cd in ( select ltrim (SQLstr) from ONGlobals. dbo .clrfn_SplitCommaDelimitedString( @Item ) ) )
Unfortunately, you need a bunch of functions to get it to work. I hope you already have those functions. If not, you can try to find it from this forum or I can give you the code.
Philippe Tag: How Extract the data of TFINF when doing text mining? Thanks
configure sql xml support IIS Hope someone can help me...anything would be appreciated. I am using sql server 2000...When I open the Configure sql xml support IIS tool to create a Virtual Directory the only thing that shows up is a computer icon and a IIS Virtual Directory Management for SQL Server. I can't expand ... there isn't a default web site.
The other tool called Enterprise Manager works fine with XP. Matter of fact all of the other tools work except for the Virtual Directory Manager. Tag: How Extract the data of TFINF when doing text mining? Thanks
Clone new database from existing Do you get an error message or what are you experiencing If you can¡¯t get attach / detach to run for you, you can also use the backup / restore functionality for this. HTH, jens K. Suessmeyer.
--- http://www.sqlserver2005.de --- Tag: How Extract the data of TFINF when doing text mining? Thanks
catch me if you can / bug in the "bug"? That is not a bug, that is how it works. There are "catchable" errors and non-catchable errors. The "table does not exist" is a non-catchable error. Non-catchable errors simply terminate the batch, or stored proc, and you can do NOTHING about it. This is a HUGE failing of the error processing in MS SQL. There are 10,000 possible errors in TSQL code and you can actually only "catch" 500 of them. Tag: How Extract the data of TFINF when doing text mining? Thanks
Parameters in an OLE DB Command Thank you both for your replies. I think I have a flaw with my flow. I am querying multiple databaes so I'll try reworking the flow.
Thanks again! Tag: How Extract the data of TFINF when doing text mining? Thanks
How to set the current connectionString user as a defualt value? I think the resone is the user I which I used in myConnectionString, is Admin user, I tried with "dataread, datawrite" user and its worked..
Thank you myself Tag: How Extract the data of TFINF when doing text mining? Thanks
Generating letters in SSRS Hi. I'm looking for tutorials on how to use SSRS 2005 to generate letters in Word or PDF format from a database. We need to send letters with our company logo and some boilerplate text to a set of companies based on a SQL Server query. So the letter will look something like this, with the red areas repeating from the dataset,
[logo goes here] 123 Any St. AnyCity, CA 90210 [today's date] Dear [name from database] , Some boilerplate text goes here. Your Account [account number from database] is past due.
Sincerely, [scanned signature goes here] Somebody Tag: How Extract the data of TFINF when doing text mining? Thanks
Can I retrieve a result set from a sp into a variable within a Execute SQL Task? I have tried this with just about every combination available with no luck. Do you need to add anything to the exec command I am passing it one variable and it now looks like this "exec sp_name '20071201'" Do I need to change it to look like this "exec sp_name '20071201', " or this "exec sp_name '20071201', OUTPUT". I also have a variable set up under result set and included it in executevariablevalue. Just to be clear the SP is not putting anything in a variable but builds a report in a fiels and at the end does a select @report to display what was built in @report. I hope this is clear. Thanks. Tag: How Extract the data of TFINF when doing text mining? Thanks
Creating Stored Procedure in SQLServer2005 Can you provide me with more details
As how to reach the Stored Procedure and how to Execute it
Thank you Tag: How Extract the data of TFINF when doing text mining? Thanks
Help with modifying a data source's query at runtime Please help figure out what is wrong with my code. The script is supposed to load a package (from file). The loaded package already has everything set up to run a query against a local server and output the results to an Excel file. The reason for the outer script is because I need to change the query based on a global variable. When the query changes, though, I think the existing dataflow Path is no longer valid, so I should remove it and re-create another one with the new input mappings. Here is my code, which runs and throws an exception at the AcquireConnections call.
The error is
Error: 0x2 at Script Task: The script threw an exception: Exception from HRESULT: 0xC020801B
I pieced together this code from the examples in the online books, but I am not sure what to do.
' Microsoft SQL Server Integration Services Script Task
' Write scripts using Microsoft Visual Basic
' The ScriptMain class is the entry point of the Script Task.
Imports System
Imports System.Data
Imports System.Math
Imports Microsoft.SqlServer.Dts.Runtime
Imports Microsoft.SqlServer.Dts.Pipeline
Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper
Public Class ScriptMain
Public Sub Main()
'
Dim app As Microsoft.SqlServer.Dts.Runtime.Application = New Application()
Dim package As Microsoft.SqlServer.Dts.Runtime.Package = _
app.LoadPackage( "c:\systime\ExcelOut\ExcelOut\ExcelOutDo.dtsx" , Nothing )
Dim pkgVars As Variables = package.Variables
Dim gsVar As Variable = pkgVars( "User::gsExcelFile" )
Dim currVars As Variables = Dts.Variables
Console.WriteLine(Dts.Variables( "User::gsExcelFile" ).Value)
gsVar.Value = Dts.Variables( "User::gsExcelFile" ).Value
pkgVars( "User::gsQuery" ).Value = Dts.Variables( "User::gsQuery" ).Value
pkgVars( "User::gsCreateTable" ).Value = Dts.Variables( "User::gsCreateTable" ).Value
Dim e As Executable = package.Executables( "ExcelOutTask" )
Dim thMainPipe As Microsoft.SqlServer.Dts.Runtime.TaskHost = _
CType (e, Microsoft.SqlServer.Dts.Runtime.TaskHost)
Dim dataFlowTask As MainPipe = CType (thMainPipe.InnerObject, MainPipe)
' Get the source component.
Dim SourceComponent As IDTSComponentMetaData90 = _
dataFlowTask.ComponentMetaDataCollection( "Local Source" )
Dim srcDesignTime As CManagedComponentWrapper = SourceComponent.Instantiate()
srcDesignTime.ProvideComponentProperties()
' Reinitialize the metadata.
srcDesignTime.AcquireConnections(vbNull)
srcDesignTime.ReinitializeMetaData()
srcDesignTime.ReleaseConnections()
' Get the destination component.
Dim destination As IDTSComponentMetaData90 = _
dataFlowTask.ComponentMetaDataCollection( "Excel Destination" )
Dim destDesignTime As CManagedComponentWrapper = destination.Instantiate()
destDesignTime.ProvideComponentProperties()
' Create the path.
dataFlowTask.PathCollection.RemoveAll()
Dim path As IDTSPath90 = dataFlowTask.PathCollection.New()
path.AttachPathAndPropagateNotifications(SourceComponent.OutputCollection(0), _
destination.InputCollection(0))
'Console.WriteLine(dataFlowTask.PathCollection.Count)
Dim ret As DTSExecResult
ret = package.Execute()
Console.WriteLine(ret.ToString)
Dts.TaskResult = Dts.Results.Success
End Sub
End Class Tag: How Extract the data of TFINF when doing text mining? Thanks
Two Dimensions Sharing same Parent Table Richard,
Thanks a lot for your answer.
The Company Dimension is like the "Master Dimension".
Dimensions: Company(***) Brand(***, CompanyFK) - Company attribute on Top Level and Brand attribute on Bottom Level Department(***, CompanyFK) - Company attribute on Top Level and Department attribute on Bottom Level Your example is great so.. :)
I drag Brand Group attribute to the rows and some measure to the data area. Now I drag Company Dimension into filter. What happens
I get the list of all Brand Group companies, not only the ones related to Company that I filtered.
An example:
Company Dimension values : Coca-Cola, Pepsi
Brand Dimension values (Company, Brand Group, Brand) :
Coca-Cola , Chocolates, Cocoa ; Coca-Cola , Chocolates, Mix Cocoa
Pepsi, Drinks, Coke Drink ; Pepsi, Drinks, Water Drink
Filter by Company Dimension : Coca-Cola
Drag Brand Group to the rows.
Result : Chocolates ( from Coca-Cola) and Drinks ( from Pepsi). Chocolates with values and Drinks not of course.
Result: expected : Chocolates ( from Coca-Cola) with values
The result that I expect appears when I drag the Company attribute from Brand Dimension into filter otherwise ....
If the Company attribute is the same on all Dimensions why doesn¡¯t work like a common attribute
For excel users is confusing work like this...
Thanks a lot..
Joao
and when you click down the hierarchy Company (Top Level) -> Brand Group -> Brand (Brand Dimension) you get a list of all companies, not only the ones related to Brand Tag: How Extract the data of TFINF when doing text mining? Thanks
Can't shrink DB BTW...... what the command u give to shrinkfil and what the error u gets ..... if any
Madhu Tag: How Extract the data of TFINF when doing text mining? Thanks
Reporting services in SharePoint integration mode problems Hi,
I'm having problems setting up Reporting Services in SharePoint Integration mode. The development environment works fine, but I can't get it to work in production.
Problem seems to be in the authentication between SharePoint and Reporting Services. When I go to "Set Server Defaults" in the SharePoint central administration I get the following message:
Code Snippet
An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. --> System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Net.WebException: The request failed with HTTP status 401: Unauthorized. at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at Microsoft.SqlServer.ReportingServices2006.ReportingService2006.ListSecureMethods() at Microsoft.ReportingServices.SharePoint.Soap.ReportService2006.ListSecureMethods() --- End of inner exception stack trace ---
I get the same message when trying to deploy a report from Visual Studio to a SharePoint lib.
Some info:
- SP apppool is running under domain account a
- SSRS apppool is running under domain account b
- SP uses NTLM authentication
- SP and SSRS are running on different servers
- SSRS Configuration shows all green checkmarks
Things I tried:
- Basic authentication instead of Windows Integrated on SSRS
- NTLM only instead of Negotiate on SSRS
- Settings SPN's for SSRS, didn't help
- Checked NTFS rights on ReportingServer dir, were fine (Domain users have read/list)
Does anyone have an idea about how to solve this Any help is appreciated. Tag: How Extract the data of TFINF when doing text mining? Thanks
Recursive Query Without Self-Referencing Structure I need a statement that can return a hierarchy of folders. There are a number of good articles out there describing how to do this in SQL 2005 with a Common Table Expression (CTE) that references itself under a UNION ALL. Yet every example I come across involves a self-referencing table. Unfortunately the architect of my project did not use that simple structure. Instead, we have a Folder table and Folder Properties table. Creating a child Folder involves adding a row in the Properties table that links to a parent. Here's the statement I came up with: WITH Folders (ID, ParentID, FolderName, FolderDepth) AS ( SELECT FOLDER_ID, NULL, FOLDER_NAME, 0 FROM ZZ_FOLDER WHERE FOLDER_ID = 1 UNION ALL SELECT F.FOLDER_ID, Folders.ID, F.FOLDER_NAME, Folders.FolderDepth + 1 FROM ZZ_FOLDER F INNER JOIN ZZ_FOLDER_PROP FP ON FP.FPROP_FOLDER_ID = F.FOLDER_ID WHERE FP.FPROP_LINK_ID = Folders.ID ) SELECT * FROM Folders The initial statement brings back the top of the folder structure. The recursive statement brings back Folder rows that have an entry in their Property rows for the parent. Yet when I try to execute this, I get: Msg 4104, Level 16, State 1, Line 1 The multi-part identifier "Folders.ID" could not be bound. Msg 4104, Level 16, State 1, Line 1 The multi-part identifier "Folders.ID" could not be bound. Msg 4104, Level 16, State 1, Line 1 The multi-part identifier "Folders.FolderDepth" could not be bound. It sounds like all the recursive references to the CTE are unavailable. What am I doing wrong Would welcome any suggestions, too. I realize this isn't a T-SQL specific question, more SQL in general, but I didn't see a more relevant forum. What follows are some tables/data to run the above statement against. -- Create Folder Tables CREATE TABLE ZZ_FOLDER ( FOLDER_ID INTEGER NOT NULL PRIMARY KEY, FOLDER_NAME VARCHAR(50)) CREATE TABLE ZZ_FOLDER_PROP ( FPROP_ID INTEGER NOT NULL PRIMARY KEY, FPROP_FOLDER_ID INTEGER NOT NULL, FPROP_LINK_TYPE VARCHAR(50), FPROP_LINK_ID INTEGER NOT NULL) GO -- Populate Folder Tables INSERT INTO ZZ_FOLDER VALUES (1, 'Top Level') INSERT INTO ZZ_FOLDER VALUES (2, 'Second Level A') INSERT INTO ZZ_FOLDER VALUES (3, 'Second Level B') INSERT INTO ZZ_FOLDER VALUES (4, 'Second Level C') INSERT INTO ZZ_FOLDER VALUES (5, 'Third Level A1') INSERT INTO ZZ_FOLDER VALUES (6, 'Third Level A2') INSERT INTO ZZ_FOLDER VALUES (7, 'Third Level A3') INSERT INTO ZZ_FOLDER VALUES (8, 'Third Level B1') INSERT INTO ZZ_FOLDER VALUES (9, 'Third Level C1') INSERT INTO ZZ_FOLDER VALUES (10, 'Third Level C2') INSERT INTO ZZ_FOLDER VALUES (11, 'Fourth Level A3A') INSERT INTO ZZ_FOLDER_PROP VALUES (1, 2, 'Folder', 1) INSERT INTO ZZ_FOLDER_PROP VALUES (2, 3, 'Folder', 1) INSERT INTO ZZ_FOLDER_PROP VALUES (3, 4, 'Folder', 1) INSERT INTO ZZ_FOLDER_PROP VALUES (4, 5, 'Folder', 2) INSERT INTO ZZ_FOLDER_PROP VALUES (5, 6, 'Folder', 2) INSERT INTO ZZ_FOLDER_PROP VALUES (6, 7, 'Folder', 2) INSERT INTO ZZ_FOLDER_PROP VALUES (7, 8, 'Folder', 3) INSERT INTO ZZ_FOLDER_PROP VALUES (8, 9, 'Folder', 4) INSERT INTO ZZ_FOLDER_PROP VALUES (9, 10, 'Folder', 4) INSERT INTO ZZ_FOLDER_PROP VALUES (10, 11, 'Folder', 7) GO /* Top Level Second Level A Third Level A1 Third Level A2 Third Level A3 Fourth Level A3A Second Level B Third Level B1 Second Level C Third Level C1 Third Level C2 */ Tag: How Extract the data of TFINF when doing text mining? Thanks
c# reusing parameters I have a select statement which requires numerous parameters. here is a snippet. SqlCommand cmd = new SqlCommand("SELECT this from MyTable WHERE Answer1 = @Att 1AND Answer2 = @Att2 AND Answer3 = @Att3", connection) my parameters are added as follows. SqlParameter Att1 = new SqlParameter("@Att1", SqlDbType.VarChar, 50); Att1.Value = Attributes1; cmd.Parameters.Add(Att1); and so on... What I would like to do is be able to remove a parameter and re-run the SELECT statement if the number of entries retrieved is less than 5 (or any number) I tried just having a new Sql command like this. SqlCommand cmd2 = new SqlCommand("SELECT this from MyTable WHERE Answer1
= @Att 1AND Answer2 = @Att2, connection) and then did this.. cmd2.Parameters.Add(Att1); but it didn't work. Is there a way to do this so I don't have to keep copying the whole parameter command Thank you in advance for your help. And please be gentle, I'm very new to this. Tag: How Extract the data of TFINF when doing text mining? Thanks
jliu685
How Extract the data of TFINF when doing text mining Thanks
Re: How Extract the data of TFINF when doing text mining? Thanks
Jamie MacLennan
There is an option on the text mining transform's advanced page as to which statistics you want. Two scores are offered as output - I can't recall off the top of my head which they are though.