Answer Questions

• meighlough Emailing long messages from SQL2000

  Hello! The problem is this. I have many short messages in a table. I need to tigh them together in one long email message and email to the users. But xp_sendmail is limited to 7,790. How could I send longer messages Or how could I devide the long message and send it in parts (i.e. separate consequtive emails) This doesn't work, it still cuts the messages off at around 7,790: E. Send messages longer than 7,990 characters This example shows how to send a message longer than 7,990 characters. Because message is limited to the length of a varchar (less row overhead, as are all stored procedure parameters), this example writes the long message into a global temporary table consisting of a single text column. The contents of this tem ...Show All

• Wayne.C Dynamic RDLC generation layout problems. Overlapping.

  I am dynamically creating an rdlc file at runtime. I use multiple Matrixes (Matrices ) throughout the report. The problem is, upon viewing, the report isnt rendered the same way as if it was created as design time. The matrices overlap, where as if I create a similar scenerio at design time, they are moved to accomodate the size of the previous element. I have tried many different things as far as the Top and Left attributes go, as well as setting the ZIndex on all of the items to be 1 or 0. Nothing seems to work, they all just overlap. If anyone has any input on this, it would be greatly appreciated. nomer This is an rdlc file that I am having the issue with. Can you notice anything that may caus ...Show All

• Rhubarb Help with SQL Query - "The multi-part identifier "alias field Name" could not be bound."

  Hi Everyone This is the query and I am getting follwoing error message "The multi-part identifier "InvDate.Account Reference" could not be bound." SELECT MAX ( [DATE NOTE ADDED] ) AS LASTDATE , CC.[COMPANY] , CC.[ACCOUNT REFERENCE] , INVDATE.[LASTORDERDATE] FROM CUSTOMERCONTACTNOTES AS CCN , ( SELECT * FROM CUSTOMER ) AS CC , ( SELECT MAX ( [INVOICE DATE] ) AS LASTORDERDATE , [ACCOUNT REFERENCE] FROM INVOICEDATA GROUP BY [ACCOUNT REFERENCE] ) AS INVDATE WHERE CCN.[COMPANY] = CC.[COMPANY] AND CC.[ACCOUNT REFERENCE] COLLATE SQL_LATIN1_GENERAL_CP1_CI_AS IN ( SELECT DISTINCT ( [ACCOUNT REFERENCE] ) FROM INVOICEDATA ) AND CC.[ACCOUNT REFERENCE] COLLATE SQL_LATIN1 ...Show All

• Nick__A. Got the same problem

  Hello. I use VS2005 and I was trying to make a little program able to connect to a MySQL 5.0.18 database through MyODBC 3.51.12. I can connect to the database and I can load a table in the Datagridview control, but I can't update the table: the wizard didn't generate the Update method. Even if I configure again the tableAdapter, the wizard generates only: SELECT statement table mappings Fill method Get method The table is a very simple table: it has 3 columns and the first is a primary key. If I create an identical table using Access database and make a program that connects through ODBC, I don't have the problem: the wizard generates also the UPDATE, INSERT and DELETE statements. Where is the difference What is the problem Thankyou so ...Show All

• Michael Bolland SSIS Transactions 101

  I want to truncate a table (remove all of its data) using an "Execute SQL task" and then populate that table using a Data Flow task. In case of failure, I want to "rollback" the table to its state prior to its truncation. Can this be done using SSIS Transaction support or is that support aimed exclusively at sql-based flows TIA, barkingdog barkingdog wrote: "Here was me thinking you could only run transactions either within the same Execute SQL". If I understand this properly, then I really can't do what I want to ( Execute SQL task -> non-sql Data Import task) as these operaitons will not fit in a single Execute SQL task. Maybe, SSIS, SP ...Show All

• Xaid Versioning Stored Procedures with VSS and Sql Server 2005

  I am wanting to put my stored procs in vss. The configuration that I am looking at is Sql Server 2005 Sql Server Management Studio VSS I have not been able to find anything that gets me going, so if someone has a link or some links, please just redirect me and I will continue digging. What I don't know is what is the best approach for doing this. Do I need to create a new project in management studio for all of my stored procedures Is there a solution that I can add to VS.NET that would do this What I am ultimately looking to do if this is possible, is have my developers use Management studio to work on their procs and have it interact directly with VSS. Any help is greatly apprecated. Thanks in advance. Gail, I have not look ...Show All

• Alan Robbins Error while importing Text file using Import Export Wizard

  Hi all i have text file where i can import it to excel to access or sql2000 without problem but when i import it using (sql2005 pro) i get this error message during the import O peration stopped... - Initializing Data Flow Task (Success) - Initializing Connections (Success) - Setting SQL Command (Success) - Setting Source Connection (Success) - Setting Destination Connection (Success) - Validating (Success) - Prepare for Execute (Success) - Pre-execute (Success) Messages Information 0x402090dc: Data Flow Task: The processing of file "C:\Documents and Settings\Wail\Desktop\All_Alarm5.txt" has started. (SQL Server Import and Export Wizard) - Executing (Error) Messages Error 0xc02020a1: Data Flow Ta ...Show All

• hazz How to add filter based on query?

  Hi guys, I have the following problem: I have several tables in SQL 2005 ( table GeographicLocations and other related to it ). I created a cube in SSAS in which GeographicLocations is dimension. I was able to add parameters but I need something more complicated: Having columns longitude and latitude in GeographicLocations I need to be able to return all locations within X (parameter) miles from passed GeographicLocation (parameter - GeographicLocationID ) I found SQL function that calculates distance from passed longitude and latitude of two points and T-SQL would like this: declare @GeoId int ; set @GeoID = 200765 ; select * from GeographicLocations as t1 where dbo . geo_distance ( t1 . longitude , t1 . la ...Show All

• nsdsto Vendor Flat File contains multiple record layouts

  We have a flat file format generated from a vendor. It contains a "mainframe" view of the data with a header record, batch header record, detailed records, batch trailer record and trailer record. It arrives as a .dat file. What is the best approach to extract the necessary columns out of this file to populate the corresponding SQL server tables and rows You can write your own source adapter, using the Script component. If you will get re-use then a custom component may be better and more manegable than script, but it is slightly more work. Parsing Non-Standard Text File Formats with the Script Component ( http://msdn2.microsoft.com/en-us/library/1fda034d-09e4-4647-9a9f-e8d508c2cc8f.aspx ) ...Show All

• WHMoweryJr for deleting duplicate rows subquery or cueser is Better in performance????????????

  For deleting duplicate rows, i can use cursor and subquery. cursor code Declare dup_cursor cursor for select acctnumber from LinkUrnABSADMBAR group by acctnumber having count(*) > 1 Open dup_cursor Fetch Next from dup_cursor INTO @acctnumber While (@@Fetch_Status = 0) Begin Delete from LinkUrnABSADMBAR where acctnumber = @acctnumber Fetch Next from dup_cursor INTO @acctnumber End Close dup_cursor Deallocate dup_cursor Subquery code delete from galupload2000..test where id in (select id from galupload2000..test group by id having count(*) >1) My question is which one is Better in performance Thanks Sandipan Subqueries run faster than cursors as a general rule. ...Show All

• John Mathews Eternal 'Enable Pending' on SQL2005

  Hi! I have this problem... im kinda new to sql2005, and im responsible for creating some notification services. Ive done a lot of tutorials, books and samples and every time, when i reach the step of enabling the instance, i get this... Generator-Enable Pending Distributor-Enable Pending Even doing the Microsoft's Notification Services Tutorial. Ive tried everything I could figure, registering the instance with a user with every permission there could be... doing this local or on a client... and ive been 2 weeks stuck here... Any tip or clue will be thankfull. M.Eng.Leandro Melendez Generally speaking, you want to make the login account used by the NS$InstanceName service (either window or SQL Server) a memb ...Show All

• WidgetWorking AdventureWorks Database not showing up management studio express

  After installing the Adventure works database samples they do NOT show up in Management Studio Express I have done a clean install of SQL Server Express 2005 SP1 with Advanced services. The database samples only install as physical files, they are not attached to the SQL Server process. If you want to use them, go in the SSMS and right click on the Database node, choose All Tasks and click Attach database.. Locate the MDF File and the LDF File and click Apply (or OK). SQL Server will attach the databases to the SQL Server process and you can access the data. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- I found this not quite accurat. The Attach is in th ...Show All

• Senkwe Chanda Parameters in an OLE DB Command

  Hello! Is there a way to use an OLE DB Command transform to execute the following SQL query "Select sum(length(" + @[User::varDBName] + ":informix.cyh_t.u_obj)) from " + @[User::varDBName] + ":informix.cyh_t, " + @[User::varDBName] + ":informix.cch_t where " + @[User::varDBName] + ":informix.cch_t.d_obj = {D '" + @[User::strQueryDate] + "'} and " + @[User::varDBName] + ":informix.cch_t.n_objid = " + @[User::varDBName] + ":informix.cyh_t.n_objid" I get a DB number from an OLE DB Source, do a lookup to get the DB name and then I want to use the OLE DB command to get a result from the query but I can't seem to get this to work. Am I using the wrong transf ...Show All

• hege Predicate or key word all in uppercase?

  Hi, What is the dowside of not using all uppercase for predicates and key words I cannot find to see a problem beside adhering to a clean coding convention. After all I already have color coding so what would be the uppercase for Same question for the semicolon ; at the end of a sql block. Is that real necessary not to get in trouble sometime down the road or is it a non-issue. I find like I am now a C# guys if I use these ; Just curious, I find tedious to switch from all upper case to normal case all the time. And not forget to type the ; Thanks, Philippe Umachandar Jayachandran - MS wrote: In a future version of SQL Server, we may require the use of semi-colons as statement sepa ...Show All

• Devver Problems importing a datetime from a flat file

  I have a flat file with a datetime field as follows 12419,1,'T','P',229.72,2,'N',2004/may/05 19:47:42.546001 12419,1,'T','R',605.38,76,'N',2004/may/05 19:47:42.546000 12419,2,'T','P',110.49,2,'N',2004/may/05 19:47:42.546003 12419,2,'T','R',215.53,11,'N',2004/may/05 19:47:42.546002 12419,3,'T','F',9.29,1,'N',2004/may/05 19:47:42.546005 12419,3,'T','R',696,38,'N',2004/may/05 19:47:42.546004 I can NOT get last field i.e. the date time field to import into SQL werver 2005 using import wizard. I can manually enter the value in the table so I know it can handle data in the format it is in.. (table field is date time) but I cant get import wizard to read the file and bring in the data.. It bombs at coloumn 7... which is the date ...Show All