I want to update TableA with values from TableB on a nightly basis. Right now, I'm trying to do this with SSIS 2005 using a Script Task with the SQL in it. Each time I try to do the update in this manner, I get a time-out error. Is there a better way to do this in SSIS? Current information below: Public Sub Main() Const Compone...
I am writing an install script that installs all tables, stored procedures, views, full text indexs, users ect. It all works fine if the user has all the correct permissions and the script runs from start to finish. However if the script dies somewhere midway through then it cannot just be run again. To accomplish this I want to basica...
I am trying to modify an exisiting SPROC in SQL 2000. The original SPROC used a FuncView as part of a a cursor. The new report does not require the cursor, but I am unsure how to execute the FuncView outside of the cursor statement. The first example below is the cursor part of the original code. The second is my modification....with...
I read an article about using CLR integration in sqlserver and was wondering what some of the potential problems might be, if any. My thought was using it for validating potentiality bad data in a legacy Database. an example is a persons name in the phone number column. Edit: I don't think there are any problems, but it's not somethi...
I see the date picker (calendar) control on my report giving out an option to pick dates as parameters for a report. However if the user want to select an older date (01/01/2000) through calendar, he/she has to scroll back month at a time all the way to Jan 2000 month to select 1st date. Is there a way to incorporate year and month pi...
I have a question about SQL Server indexes. I'm not a DBA and assume the answer is clear for those of you that are. I am using SQL Server 2008. I have a table that is similar to the following (but has more columns): CREATE TABLE [dbo].[Results]( [ResultID] [int] IDENTITY(1,1) NOT NULL, [TypeID] [int] NOT NULL, [ItemID] [in...
I am trying to generate an xml file of a recipe database that has recipes with ingredients as sub elements. My query is this: select 1 as 'Tag' ,null as 'parent' ,replace(r.recipe_name, '/', '') as 'item!1!title!element' ,isnull(replace(r.description, '/', ''), '') as 'item!1!description!cdata' ,r.recipe_id as 'item!1!recipe_id!el...
I have a table with 5 string columns, all can be NULLs. After I read the data from this table, I want to convert any null values into empty strings. The reason is that I need to compare these columns with columns in another table of the same schema (using conditional split), and null values would cause the comparison to evaluate to NULL....
If you're just going to vote this down and not tell me how to do better, what's the point? How can I learn to make the question better if you vote -1 and not leave me a comment. select u.name, o.name, case (o.type) when 'S' then 'SYSTEM TABLE' else 'TABLE' end, (select convert(varchar(8000), value) from ::fn_listextendedpr...
We are encountering problem in using Access 2000 (.ADP) as our front-end and SQL 2005 as our back-end and we have more then 50 users: [DBNETLIB][ConnectionWrite (send()).]General network error. Check your network documentation. It was working fine for the last years, but now the system keeps kicking out the user. They always receive an...
I have a fairly simple query: SELECT col1, col2… FROM dbo.My_Table WHERE col1 = @col1 AND col2 = @col2 AND col3 <= @col3 It was performing horribly, so I added an index on col1, col2, col3 (int, bit, and datetime). When I checked the query plan it was ignoring my index. I tried reordering the columns in t...
looking for a tool with which I can move data from sql server to mysql database ...
I'm trying to implement your basic UPSERT functionality, but with a twist: sometimes I don't want to actually update an existing row. Essentially I'm trying to synchronize some data between different repositories, and an Upsert function seemed like the way to go. So based largely on Sam Saffron's answer to this question, as well as som...
I have setup multiple SQL Service Broker Queues in a database but have not seen this problem before. A message containing XML is being converted to what appears to be mostly Chinese Characters. When I check the variable that is storing the XML prior to putting it in the message queue I can see that is in English and is well XML formed. W...
This is something I know can be done somehow, because I've done it before, but I can't for the life of me remember how. I want to export the structure of an SQL Server database to an XML file. The one that I have from last time we did this has this kind of structure: <Data> <Details> <Server>Server Name</Server> <D...
I have a winform program that uses Merge Replication to keep a local SQL Express sync'd with a Central SQL Server on our network. Due to the nature of this app the sync process runs automatically on App open and close. The way I am doing it (below) seems quite time consuming. What would be a faster way? Thinking outside the box it...
For multitenant databases, to you name tables differently based on: Whether the table will host multiple tenants or just rely on the exist of a tenant column If you support multiple "applications" such as salesforce.com, do you prefix the application name to the table? Do you try to keep the names the same across tables where it may no...
I know a view is composed of tables. Can I replicate a view anyway? ...
I've managed to connect from SBCL running on debian to an SQL Server 2000 instance over the network using FreeTDS/unixODBC. I can actually get data back from the server, so all is working. However, many of the columns trigger what seem to be unsupported data types a-la: The value 2147483647 is not of type FIXNUM. and -11 fell throu...
I'm very beginner for developping. environment is .. Windows XP Professional SP3 Microsoft Visual Web Developer 2008 Express Edition Microsoft SQL Server 2008 [table_name:LOGIN] login_id -> char(5） login_name ->nchar(20) password -> char(10) My Question is following. How to develop login program ? with the table I want to ...