hello, (SQL Server 2000, DTS) I have a parent package that includes a number of child packages. Each child package is an Execute Task package. I declare the global variables (e.g. SOURCE, DESTINATION) of the parent package in the package properties. Then, I set them using a Dynamic Prope...more >>

I have a database table that should allow punctuation in one column, but not all punctuation. I added a check constraint like so: ([MyColName] like '%[a-zA-Z0-9!@~#$^&*()_+-{};:",.]%') However, it isn't working like I think it should. If I take the last % out, the existing data in the database...more >>

Hi, I am having problems with this query (sample) SELECT product_number, delivery_date, ... from dbo.archive where year(year,traxdate) = '2006' AND datename(month,traxdate) between 'January' AND 'February' AND product_number = 1234 ...more >>

I need to bring the following data in an xml format (many more years included) into the table listed at the bottom of this request. This data is in a large text file, say in c:\calendar.xml <Calendar> <ActualDate>2005-01-01T00:00:00</ActualDate> <MonthName>January </MonthName>...more >>

Is there a way to use isnull in a where clause and joining multiple tables?...more >>

Can a sql server 2005 express stored procedure call a soap service? In my case the soap service with the data I'd want to tap would be installed on the same server as the sql server. If there is more than one way to call a soap service from a sproc, what are they? Any good beginner level tut...more >>

Hi all, using SQL 2000 sp4 I'm trying to create cross tab query and all seems to work fine except I want the order of type to be in the same order of each row. In the top table I just have the order of the type for the later query below. But not sure how to use it to create the correct ...more >>

I am trying to query the job schedules and link them back to the job name. Does anyone know how to link the sysschedules table back to the sysJobs table? Is there some intermediate file?...more >>

Hi Folks, I know I'm cross posting (humbly bowing head) but I think I might be more inclined to find an answer in here and I'm running out of time... I'm trying to create a query that might require a join of somekind but after reading a number of web articles on joins I'm now more confused...more >>

I think I want to write a stored procedure that has 7 input parameters, any of which will be null. Is there a kind of "parameter list" functionality in TSQL I can use to interrogate them to know which ones are null and which ones are not without doing a lot of IF logic? Thanks....more >>

Full error message from VB Express: Could not find database ID 44. Database may not be activated yet or may be in transition. I have a little VBExpress app that populates a Treeview and a Listview control, based on views in my database that pulled data from a vendor's SQL 2000 database. ...more >>

I need to delete one named instance of SQL SERVER 2005. All information that I found out is to make a complete reinstall of SQL SERVER 2005, but it isn´t a solution for mi because I have two named instance and I must keep one of them. Any help will be appreciate. ...more >>

Hi, I have very large sql server 2000 database here (~1TB), and we have purge process setup in place which purges old customer transactions from the database. I know that sql server 2005 and data partitioning would be perfect solution for this problem, but that is not realistic now. Anyway, w...more >>

Hi All, In the SP below, do you see anywhere that I can optimize to avoid deadlock and make it more efficient from the DBA perspective. Thanks in advance! CREATE PROCEDURE dbo.PODTL_AutoDisp_U_SP (@PO_ID INT , @CUST_ACCT_NBR CHAR(9) ...more >>

Hello All: I have an ON INSERT trigger structured something like this: BEGIN TRY BEGIN TRAN <do some logic here> <execute a couple of procs in another database, same server> COMMIT TRAN END TRY BEGIN CATCH ROLLBACK TRAN RETURN END CATCH Now, the who...more >>

Hello all, I have a problem with Connection Timeout, but kind of different from almost everybody else problem. My connection timeout is not to short for my query, in the opposite, it's too long. In my application I try to connect to a database, but in case the user entered a wrong IP ad...more >>

I need to perform some group by operations on the resultset from a store procedure. Select columnX, count(*) cnt from (exec my_sp 'test') t1 Group By columnX is there a way to do something like this without altering the stored procedure? How to do it? Thanks, Rich...more >>

Hello, friends, I created a stored procedure (sp), in which I need only to return top n records, not all (say 10,000) records. Since this n value may vary, I pass it as an sp parameter. However, as you know, an SQL statement like SELECT TOP @n employeeID, employeeLastName, employe...more >>

Hi! I expected that "castVersion" and "convertVersion" should return string "0.0001" (SS2005), but they didn't. I found a workaround/solution, but can't understand reading the documentation why it doesn't work as I expected... Can anyone explain? select cast(0.0001 as smallmoney) or...more >>

I am getting the following error message when attempting to save a database diagram, which I am creating on an existing database. ------------------------------------------------------------------------------------------------------------------------------------------------------------------ - ...more >>

I'm working on a simple stored procedure that will help us reduce trips to the database in nested loops in our code. The purpose is to grab a given "client" record from a table and loop until it also has any related "client" records for billing purposes (such as a parent client who pays the bil...more >>

just a very simple question, I have to design a e/r diagram for a BOM. it is a hierarchy structure, so i need to some ideas to make it! thank you ...more >>

Hello, ... I have something similar to this piece of code: ------------------------------------------------------------------------ declare @i int set @i=1 while @i<=4 begin UPDATE Table1 SET field1=RESULTS.MYSUM FROM (SELECT max(FIELDn) as FIELDn,SUM(FIELDn) AS MYSUM FROM TABLE...more >>

Hi, I'm building a CMS for a website that I envision getting to be quite large. The CMS will have a development environment where entire sections will be sandboxed for editors to edit and create pages. My concern is that to keep the pages consistent and links working properly, I need to use...more >>

Rather than reinvent the wheel, I was hoping that there was someone who has already created a script allowing for the auditing of DDL statements, schema changes within the database for SQL Server 2000. I can easily capture the aforementioned in SQL 2005 by making use of a trigger on DDL_DA...more >>

Hello, In a stored procedures there is an input parameter in which all ',' on the end must be replaced. How can this best be done. What function ould i use. The number of ',' is not known. It coulb be 0,3,5 ,, example1: @p1=a,dd,f,,,,,, should be transformed in a,dd,f @p1=aq,ddw,f n...more >>

Using SQL2000. Table is Errors Site AssociateID ErrorType ErrorDate I want to be able to produce results in this format Site | # Errors 1| # Errors 2| # Errors 3| # Errors 4| A 10 3 10 1 B 3 4 5 ...more >>

I am trying to use the in clause in the following query Declare @var varchar(50) Select @var=mylist From table1 Where myid=1 Select id From table2 Where id in (@var) My problem is that the @var is set to 5,7,13,30, which is without the single quotes around the values. If I hard cod...more >>

Hello all We have a problem in my project, that I would like some advice on how to slove it using SQLServer. We have a cluster server setup with two loadbalanced servers (A and B). Requests are comming in through web services. In part of our application, we need to read some data from t...more >>

Hi All, Greetings! Do any one have idea about how to compare the Database Programatically, like comparing the whole schema, tables, structures, procedures, controlling the version, updations and etc. There are having many tools to do this. But i have to do this requirement as programatical...more >>

Hello, I have 2 items discount tables Discount which is having this schema (in short) DisID , INT , PKey FromDate , datetime ToDate , datetime and DiscountItem , which is having this schema DItemID , INT , PKey ItemID , INT I need to prevent users from defining one item in more ...more >>

Hello there On sql server 2000 if i needed to see all the available servers can be use i was do it with client configuration tools and server configuration tools which tool on sql server 2005 do the same thing? ...more >>

Hi, This is hard to explain so I will try my best for my own sake! I have a website that will compare two or more items. Lets say MP3 players. I need to comapre them side by side. Lets say the phone has the following attributes to compare; Model Size Memory OS Now it would be eas...more >>

is there a function where I can delete duplicate records? I can use the casenumber field to check for duplicates. BUT...How? Thanks, Raul Rego NJPIES ...more >>