Answer Questions

• EdwinLam Combine Data and Split into separate txt files for each header/detail row groupings

  I’ve created with the help of some great people an SSIS 2005 package which does the follow so far:   1)        Takes an incoming txt file.   Example txt file: http://www.webfound.net/split.txt       The txt file going from top to bottom is sort of grouped like this      Header Row (designated by ‘HD’)       & ...Show All

• JD81 Need a list of Error Code

  Hi, When we configure a transformation to redirect the error record, SSIS gives 2 columns: 'error code' and 'error column'. In one article, I have seen how to get the error description using the 'error code'. My questions are, Where I can get list of all possible error codes 'error column' gives the id of the column. How to get the name of the 'error column' Thanks. Basically you need to know the metadata of the normal ...Show All

• MMuffett Making SQL Keywords All Caps

  Is there a way to make keywords such as SELECT, FROM, WHERE, HAVING, AND, ON etc. always appear in all caps when typing queries n the SQL Query Editor I have looked in the Options under Fonts and Colors but I dont see a way to make these keywords all caps. Any advice is appreciated. Regards, Randy J Hi Randy, just as a followup, PromptSQL does contain automatic uppercasing and other cool featur ...Show All

• Ricardo_AG Temporary table vs. Table Valued function

  I need to return a table of values calculated from other tables. I have about 10 reports which will use approx. 6 different table structures. Would it be better performance wise to create a physical table in the database to update while calculating using an identity field to id the stored procedure call, return the data and delete the records. For Example: StrVal1,Strval2,StrVal4,IntVal1,IntVal2,FloatVal1... Or using a table-valued func ...Show All

• Valerie Prieur Creating table where column_names are results from query from other table

  How I can create table where column name is result of query of second table Next cod doesnt work: Use Pubs declare @naz varchar(40) declare naziv cursor for select top 1 au_lname from authors open naziv FETCH NEXT FROM naziv INTO @naz close naziv deallocate naziv GO CREATE TABLE #t1 (@naz varchar(20), quote int ) GO DROP TABLE #t1 use dynamic sql, although it won't work for temp tables. EX ...Show All

• commerce hacker Data Source Column Changes

  I have some Dynamic SQL that builds a table with the top 20 item numbers as columns, Stores as rows and an X marking the intersection of Store/Item. This produces a table which is a matrix showing which stores are low on which items. This table is generated once a week and each week will have different column names because the item numbers which the stores are low on changes from week to week. How can I write a report that will handle the column ...Show All

• WimB Real Time ROLAP different then ROLAP

  What is the benefit of setting the proactive cache to Real Time ROLAP. Wouldn't this be the same as ROLAP. Confused on why there is such an option. Books online doesn't seem to answer it clearly. Hi Deepak Could you please send me some code sample and "how to " for send client notification to Analysis Server Thanks alot. Regards; Rakesh Proacti ...Show All

• ComputerJin SSMSE: "Unable to view requested dialog"

  Before all, excuse me for my poor english, also for error messages translated from italian. I use SSMSE version 9.00.2047.0 (in italian language) to admin a SQL Express version 9.00.2153.00 (in italian language). If I right-click on a db name in the object browser, choose "Properties", "Authorizations", and then click on "View server authorizations", SSMSE shows me an error dialog with the following ex ...Show All

• sharc Droppinga a default value

  Hi, I'm trying to drop a default value on a column by: ALTER TABLE [Table_A] ALTER COLUMN [Col_A] DROP DEFAULT But I just get an error: Msg 156, Level 15, State 1, Line 1 Incorrect syntax near the keyword 'DEFAULT' Doesn't Sql Server 2005 support this syntax What is the correct syntax Tomsi Thanks a lot Tomsi Take a look at this MSDN page. ...Show All

• MacKenzie How to get a row committed

  I have a package loading up rows of employees from an excel file. An employee may be in the file multiple times. The package does a lookup and if not found it inserts the employee. When the employee is found it does an update. So in my file employee A gets added on the first occurrence in the file. On the second occurrence, the lookup does not find the employee and tries to insert a second time and I get a unique constraint. How do I make the ...Show All

• ShimiIL DateTime Parameter in URL

  Hi Group, How can I amend the following to pass the current date as the hidden parameter I tried Now() and Date() but this does not work <form id="frmRender" action=" http://Server1/ReportServer /Reports/Charts/Pie " method="post" target="_self"> <input type="hidden" name="rs:Command" value="Render&CreationDate"> <input type=" ...Show All

• SammyD Problem with arithmetical calculations

  Hello, everyone. I have some experience working with T-SQL, but now I am faced with problem which I never seen before. I have query: SELECT 2/(9+1)*1000 This query returns 0, but it must return 200. I have tried this in SQL 2000 and SQL 2005, but result is the same. What is wrong B.R. Girts Well, this is kind of wierd loo ...Show All

• Bryce Covert multiple-step ole db error

  When trying to connect to sqlexpress, I get the rather uninformative error message: Error No. -2147217887 Multiple-step OLE DB operation generated errors. Check each OLD DB status value, if available. No work was done. Here's the connection string I'm using: strDbConn = "Data Source=.\SQLEXPRESS;AttachDbFilename=" & _ DbPath & ";Database=rawtf_1;Integrated Security=True;User Instance=True; " & _ " ...Show All

• Miguel Coutinho SET RECOVERY SIMPLE generates error

  I've come across several references indicating that the recovery model can be set to simple by using the following sql statement: ALTER DATABASE dbname SET RECOVERY SIMPLE However, all I get is the error message below. What is the correct syntax Msg 102, Level 15, State 1, Line 1 Incorrect syntax near '.'. Msg 195, Level 15, State 7, Line 1 'recovery' is not a recognized SET option. It looks ...Show All

• Paul Irwin dbf in network location

  I tried to connect my *.mdf (using path like this: \\Server\infotec.mdf) file to MSSQL EXpress 2005 engine using MSS Management Studio Express but I get message that attaching databases from network paths is impossible. Is there any possibility to do this thx, Tom Attaching database files in a network location is not recommended. The reason being that SQL Server needs exclusive access to the files, and ...Show All