My coworker has SQL Server 2000 client and SQL Server 2000 server installed and I only have MSDE installed. While he was able to use his GUI client to connect to my MSDE, we could not figure how how to transfer his database to to my instance of MSDE. We tried deleting my database and dragging ...more >>

Hello. I'm new to Query Builder in VS 2005. I'm an IT pro that flirts with progamming so I'm no expert. I've used Access in the past to perform the task I'm having trouble with. I have one field [ship_yw] which represents the ship year and week. all data is in the following format: 200701, 20...more >>

Does anyone know how to read the result set of a system stored procedure? I am trying to read the available space info of a database and then use that information to shrink the database during a really data intensive script. ...more >>

Hi guys, I have a query that's running slow and I need some help with it. Here's the query: ------------------------------------- SELECT * FROM ( SELECT A.TransId, ( SELECT SUM(W.LineBalance) FROM ( SELECT ( SELECT SUM(X.TransDetailQuantity*X.TransDetailR...more >>

Hi All, I have exported my result set from a MySQL database to a CSV file using MySQL Query Browser. I need to import the data into a SQL Server table. Unfortunately I've not been able to configure a data source for CSV. After some research looking for another way to import the data, I foun...more >>

Hi. We have little app. that extranct data from SQL server DB using select stmt and put it into flat file. this flat files are used later on to load data into another DB using another app .. the problem is. the output of the first app. use to bring datatime with ms on SQL2000. the same f...more >>

I'm looking at a SS 2000 SP4 Execution Plan - and it's ugly by the way - and one of the costliest parts has six or so tables (that are part of a larger view) that say the following: “OBJECT:Database.dbo.tblpartofview.indexusedforjoin SEEK tblpartofview.joincolumn=Union1283 ORDERED FORWAR...more >>

I have SQL query that will return Date, OrderId, Sales, AR. AR is calculated as sum of Sales and Calcelled. The criteria for selecting records is the dates specified by the User. This query works just fine. I am in a situation now where I want Date,Orderid, Sales for the date specified by the Us...more >>

Hello everyone I would like to get nvarchar date values in mm/dd/yyyy format. The reason why is that I am creating a dynamic query. Is it possible? I run the following code and I keep getting: Conversion failed when converting datetime from character string. Anyone know why? So here i...more >>

Our company have many different kinds of shoes, clothing, jeans and so on.For example:Nike, the air jordan(1-21), the air max(90-97,2003-2005,180- 360, TN, OZ),the air force one, Dunk,bape,puma,Timberland,Prada,Jeans,clothes,bags,etc. They are all high quality,best prices and fine workmanship. ...more >>

I am new to sql server 2000. I have a database that I want to update daily. I have the following situation Linked Server Name: FM (read only) Database Name: fmspace Table Name: em Server Name: Dev1 Database Name: MoveTracking Table Name: tblkpEmployees Server Name: Dev1 Database Nam...more >>

I'm trying out the example B under http://msdn2.microsoft.com/en-us/library/ms171806.aspx and it is giving me a validation error: Reason: Element 'Order' is unexpected according to content model of parent element 'Customers'. Can anyone identify what's wrong with this sampleXMLData.xml...more >>

Hi All, In one column I have string mixed with 5 character returns. I would like to separate each paragraph (before retunr) in diferent column. How can I do that? SAmple (return shows like two litte squares) 121 Tree ave (return)Apt 23(return)Alexandria(return)VA, 22306 Tks JFB ...more >>

Hi, Is there a trick to insert a range of dates with one insert select statement? For example, I'd like to insert every date grouped by hour from '2007-08-10' to '2007-08-12'. Insert into tbl_logs select date from... group by DATEADD(hh, DATEDIFF(hh, 0, SomeDate), 0)? Thanks for any ...more >>

Hi, Does anyone know an online source for standardised schemas? For example if I build a database that contains address information, is there somewhere I can download a schema for the address table rather than creating it from scratch and re-inventing the wheel? Thanks -- Rich h...more >>

I have a stored procedure that runs a report, however I want the report to only pull the results for the user that is running the report at that time (i.e.j computer login name). How do I do this?...more >>

I tried to adopt the BOl example for sp_send_dbmail to send the result set of a Stored Proc but I got an error. How will you send the result set of EXEC TEST1 ? DECLARE @tableHTML NVARCHAR(MAX) ; SET @tableHTML = N'<H1>Revenue Report</H1>' + N'<table border="1">' + CAST(( Ex...more >>

2005 SQL Express with no SQLSERVERAGENT need help creating a batch file to run weekly osql -E 1> use BESMgmt 2> exec RemoveDeletedUsers 30 3> exec RemoveOldHistoryRows 60 4> exec RemoveOldWorkQueue 15 5> go ...more >>

www.gobizchina.com supply brand shoes such as nike SHOES,nike air max nike air jordan nike max 95 nike shoes max 97 nike shoes max 2003 nike shoes airmax 2004 nike shoes air max 360 nike shoes tl nike shoes r3 nike shoes r4 nike shoes r5 nike shoes r6 nike shoes nz nike shoes oz nike jordan jo...more >>

I'm trying to set up an excel destination object. I've run into this before where a field was varchar in the sql source, and it could not convert it to the excel side. I fixed that by defining the sql source as nvarchar. Now, I'm trying to do this again for another data flow, and even tho...more >>

Hi folks, Is there a way to get occurrences of a specific text pattern with a string. The example as below: peter, aaaR-DaaaaaD-RaaaaaaR-Daaaa john, aaaaaaaR-Daaaaaaaaa The pattern is either R-D or D-R. The expected result form a select statement is as below: ...more >>

Dear all, I have created a job for SQL Server Agent, that consists of 3 job steps. I have scripted these, and scheduled these to run every two minutes. But sometimes step 1 fails. Is there any way of seeing what the error code was, except from viewing the history ? The problem is that th...more >>

I have a table [user] belongs to [dbo], create another user named user01 this user01 has no db_owner,sysadmin and db_ddladmin rights, the table [dbo].[user] has a identity field, have grant select ,insert,update on [dbo].[user] to user01 Problem is: my application login with user01,i nee...more >>

In our app, we count the number of users of our program that are logged into the user's DB with the following query that someone in our company wrote many years ago. This doesn't work on SQL 2005, as many of the system names/data are different. I am having a very hard time rewriting this to ...more >>

HI, PROBLEM: If an error is generated in Main Procedure, it is captured in VB but if it is generated in a sub-procedure (as under) it is not captured in VB. This is what I am using (in SQL 2000): CREATE PROC dbo.MainProc AS DECLARE @RC smallint DECLARE @MyMsg varchar(255) EXEC ...more >>