SQL 2000 and MSAccess 2000. How do I pass a parameter to a stored procedure using MS Access? Thanks. ...more >>

I am trying to update a field in one table when a matching code exists in another table AND that row has a value of 1 in a specific field. Can't seem to work it out, though. Here is my code: UPDATE dealers SET dealers.PP1 = 1 WHERE EXISTS ( SELECT PromoListTotals.Promo, PromoList...more >>

Hi All, Can someone point me to the download location of the Storefront sample for the Adventure Works Cycles sample database in SQL Server 2005. The online documentation refers me to http://go.microsoft.com/fwlink/?linkid=42219, but I was not able to find the sample anywhere. Thanks Vik...more >>

Hi , Thanks for every one trying helping me . I need to ask a questiom about installaion the SQL Server Managment studio in SQL 2005 which is enterprise Manager in SQL SEVER 2000 . Really I have installed a tested phase of all the SQLSERVER 2005 collection from Server management...more >>

Hello, I'm an Access/SQL novice and I have an sql problem: I have the following table Price: FuelID PriceDate Price LPG 1/05/2007 0,2 LPG 13/05/2007 0,21 SPS 2/05/2007 1,1 SPS 15/05/2007 1,08 And I have to make the following query: FuelID PriceDate_from PriceDa...more >>

I am trying to figure out how to export a table of images stored on a SQL 2005 database to a directory on the local drive. In SQL 2000 one would use DTS, but this does not seem to be the way to do it in 2005. Does anyone happen to have a T-SQL script or maybe an explanation on how to do this...more >>

I have Vista Business with SQLserver2005 and SP2. I am having these two error messages and would like any help. This is related to SQL Browser: The configuration of the AdminConnection\TCP protocol in the SQL instance MSSMLBIZ is not valid. This is related to MSSQLServerADHelper: '0' is an i...more >>

Greetings, How do I import data from CSV file (source.csv) to my MSSQL table (dbo.target)? Kindly advise. Thanks ascll ...more >>

Hello out there, hope anyone could help with a small problem when querying two tables. Here is a shaved and simplified description to focus on where I am banging my head into the wall. Two tables like this (example data), Person and Activity: Pid Name 01 Joe 02 Tim 03 Alan Aid ...more >>

Dear Sirs, I have a traditional SQL 2005 Express table with fields, e.g. SubsurfaceID - (PKey) int, Not NULL (autoincremental from 1 by step 1), Name - varchar, Field1 stc. After INSERT by TableAdapter VS 2005 I got exception "NoNullAllowedException": DataRow newSubsurface =...more >>

Hello, I would like to ask you such question. I created database but after reinstalling Windows XP and SQL Server 2005 it attaches as read-only. What should I do to have full access? Thanks for help /RAM/ ...more >>

I have a results table with details in it, each detail has a detail ID. There is a detail table with all the detail IDs. The detail IDs belong to root IDs. More than one detail ID can belong to a root ID. For example. rootID1 detailID1 result rootID1 detailID2 ...more >>

I'm using 2000 Can I execute a stored procedure within another stored procedure. I tried exec sp_name buy got an error. The sp I'm attempting to run uses bcp. Any ideas? Thanks. ...more >>

SQL 2000. I was trying to move the system files, I managed to move the master, msdb, tempdb but then it died on the model. and I need to recover database... the sql service keeps failing. thank you!!! ...more >>

I have a stored procedure which uses an input variable. I'm using ms access as the frontend. I've attempted to use a pass thru query and used a reference to a control on a form to pass the variable but I haven't been able to get it to work. What should I do? Thank! ...more >>

I'm using 2000. I'd like to know how to write the code to use in a stored procedure to import a spreadsheet in a table. I've used dts to do it, but now I need to write the code to do it. Can you point me in the right direction or give me some generic code? Thanks. ...more >>

Hi, I have a query where I group results using three conditions: date, exam = and solicitant. Solicitants are selected in WHERE condition using '... = where solicitant in (string variable) and...'. My problem is that I have, in string variable, a sequence like = '70214,70214,58256,58256,0,0...more >>

I'm trying to update a field in a table the sp seems to go on forever until I manuall stop it. Maybe I have the BEGIN/END in the wrong place. Here's the sp: CREATE PROCEDURE [sp_UpdateCargoDeliveryDate] AS DECLARE @TWDLIN_Cursor CURSOR DECLARE @LSHQTY [float] DECLARE @LTWPO [float...more >>

I'm using sql 2000 and Access 2003. In Access there is a make table wizard that will create a table from a query. How would I go about doing making a table from a view in sql 2000?...more >>

Hi, guys, well i have downloaded and installed SQL Server 2005 Enterprise edition evaluation from Microsoft. due to time constraints i am not in a position to buy the full version. can i activate or register the evaluation version to a full version. ...more >>

Recently we upgraded our Windows 2000 with SQL Server 2000 to Windows Server SBE 2003 with SQL Server 2005 (sp2). The upgrade was successful, and we have been using our shared application which uses the SQL 2005 Server ever since. Tonight I removed the old SQL Server 2000 using Add/Remove ...more >>

Hi, We sometimes get data from customers where the phone numbers will have plethora of invalid characters in them. They could have _,*,&,#, ect... I know that the replace function can be used to search for one character and replace it with whatever you need. I was wondering if it's pos...more >>

Below is a select statement that will be a stored procedure at some point. I will only be passing @startdate and @enddate as user defined. For the purpose of testing I set them to dates Note: I am trying to get the data for @totalatstart"total opened at start" and @totalatend "total opened...more >>

Hello, i want to connect to another SQLEXPRESS server that is located inside our local network. I am using "SQL Server Management Studio Express". I have activated TCP/IP protocol for both servers and the SQL browser service is running on both computers. To login i am using Windows authe...more >>

I am trying to advance my query writing abilities and would like to ask if there is anyone out there who will not write the query for me, but guide me through writing this query. I can use aggregate functions such as COUNT() and AVG() in simple queries, but in something like this I am getting...more >>

How can I convert the results of this query SELECT num1, COUNT(num1) Total FROM tbl GROUP BY num1 Which displays like this Adult 2 Minor 2 BUT I WANT IT TO DISPLAY LIKE Adult Minor 2 2 Can this be done and how?? I've looked at the new PIVOT, and I am using 2005, ...more >>

I would like to direct this to someone who helped me on a previous query, but I am not sure if that violates some kind of etiquette, Anyway, I Hope you know who you are, You were a big help, thanks again!! I would REALLY appreciate any help. I hope that with just a little more help I should ...more >>

I am working on a server/client application where the client scans a computer for all available mac addresses and stores the information in a database, associating mac addresses to assets. I see problems occuring in terms of NICs being removed, changes to different machines on the network, ne...more >>

I've created a query that pulls one field from each or 3 related tables, but I need to limit the rows displayed to only the newest entry for each user. How do I limit the display like that ??? ...more >>

I have used a dts package to export date to a spreadsheet. I would like to write a stored procedure to copy that spreadsheet to a subfolder. How do I do this? File system Object? Thanks. ...more >>

I'm trying to save a couple files to a subfolder. So far this saves them to the root directory: I'd like the subfolder to be named yyyymmdd. This attempts to add the date on the end of the file name but I'd rather try to figure out how to name the subfolder. and then put the files in it. ...more >>

We use SQL 2005 and I need to know how to determine if it is case sensitive or case insensitive. Our programmer is out on vacation and I have an application I need to install that requires this information. I have done multiple searches on this site along with google andhave yet to find out ...more >>

Still struggling with a conversion from a string to datetime. Would actually like smalldatetime, but I'm not sure what to do. Syntax error converting datetime from character string in a sp: --********************************************************** @OrderDate is in the format of mmddyy...more >>

I've imported a "report" from Excel that looks something like this: CODE PC DM B WEB 1 x 5 x y 2 x 3 x y I want to be able to count, for each record, how many of the columns have...more >>

Hi All I am Using SQL Server 2005 http://www.sqlteam.com/article/sql-sever-2005-using-over-with-aggregate-functions This link explain about The Function In SQL Server 2005 But when I use the Same Query I give the Syntax Error Any Idea about How do i use this function? Thanks in ad...more >>

I just upgraded from SQL 7 to Sql 2005 on Server 2003 sp2 r2. I had to upgrade because one of the programs we own required the change for their new version. Now my old no longer supported programs don't work. I suspect that it is because they have weak passwords. When I try to disable the ...more >>

I hope this is the right ng, could not find msde or sql server 2005 In sseutil.exe, how does one connect to an mdf file, say, c:\mydb.mdf I tried c:\Microsoft\sqlExpressUtil\SSEUtil.exe -consolewnd -s \SQLEXPRESS -a c:\mydb.mdf It complained about more than one exec tried c:\Microsoft\...more >>

Hi, A SQL Server 2005 is already running fine in one computer (WinXP) and now I need to install client in another one(Win XP). What I need is very simple: the client can connect to the server and execute some sql command. Is SQL Native Client supposed to do this or not? Where can I find suc...more >>

In SQL Enterprise Manager (2000) I can right-click a table and then select Open Table > Query. In this mode I can specify a query, execute it and then edit the results right there in the grid. This gives me quick-and-dirty way to modify data w/o much hassle. Is there a way to do the above in S...more >>

In an insert statement I am attempting to add a number to a converted date. The statement works fine if I leave out the +14. Here's the statement: CONVERT(varchar(10),CONVERT(smalldatetime,[LESTDP]),101) +14 AS TTDT, How should I do this? Thanks. ...more >>

I just reloaded our SQL server from the OS up. We were on SQL 7 but had to load SQL 2005 as a requirement for one of the porgrams we own. After the reload I restored all of the databases however as expected the SID's of the users that were in the old database don't match the SIDs in the new...more >>

Hello All, I'm very, very new to this and I seem to be stuck right away. I've installed SQL Server 2005, and I'm trying to install the "Adventure Works" sample. However, I have no localhost server running - so everything fails when trying to connect. If I go to SSMS and try "New Server R...more >>

I think this should be easy but I can not figure it out. I have two tables: Orders - OrderNumber SourceLocationID DestinationLocationID Locations - LocationID Name Address I want to run a query to retrieve the location data for the Orders SourceLocationID and DestinationID, someth...more >>

Hi, i've imported into SQL Server 20045 a db built in Access 2003 -- using the import data command on the SQL Server menu. My question is -- is it possible to use the Access Forms I built to point at the SQL Server and interface with the data in its new location? If so, can you point me ...more >>

I get an arimetic overflow with this statement: CONVERT(varchar(10),CONVERT(smalldatetime,[LESTDP]),101) AS BOLD LESTDP is in the format 20070601 Any help would be appreciated. Thanks. ...more >>

hi out there On our Windows 2003 Servers w. sp1 running MS SQL Server2000 w. sp4 we see from time to time that we get this error "cannot allocate 64k continous memory" or "SQL Server could not spawn process_loginread thread" which could be caused by nothing left in the "Memtoleave" pool - I ...more >>

Is there any way to run an optimization and integrity check against the master and msdb databases? Below are the log files. Thanks! - Gabe Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server 'SRVDB1' as 'RRG\rrg-sqlserver' (trusted) Starting maintenance plan 'System ...more >>

In other words do I need to set a trigger or will setting Identity do the trick. I got an error that the value was not there.. but according to MS Server Management Studio the field is set to true and inital value is 1 and to incrment by 1. Not sure why it didn't increment. Using Visual Studi...more >>

Is there an odbc driver for peoplesoft so I can extract data from it? If so, is it the Oracle one? Thanks. ...more >>

I'm using sql 2000. I've set up sql mail to alert me when a dts package fails, but it hasn't been sending anything. Then the other day I opened Outlook and it sent all these messages. I'm using Outlook 2003 and from what I've read I need to have it opened all the time. Is there a way t...more >>