Hi All, We are using a DTS in SQL Server 2000 (will turn to 2005 soon, if anything ad hoc may help) to import data periodically from a folder. Now the problem is, if the filename is fixed. It makes it a little bit troublesome to detect the date for data source -- we have to put the date in ...more >>

Hi, Say, you have two inter-dependent packages of pA and pB. With the successful execution of pA you would proceed to execute pB. And since they would perform some repeatitive tasks on regular basis they are scheduled as a job. But you don't want to the job to make attempt to run pB if you...more >>

Hi, I have table which has the following values : ID SEQ Text 1 1 A 2 1 B 3 2 C 4 2 D 5 2 E 6 2 F 7 3 G The result should be : 1 AB 2 CDEF 3 G Could somebody help me with this? I could use an cursor but t...more >>

My problem is trying to calcuate whether a room is booked during a date period. I have a table with two columns (Start and End date). I need some SQL code to calculate whether a room is booked during a date range. e.g. The booking entry is: Start 21/11/2005 End 25/11/2005 An...more >>

Hi all, While debugging some old code from someone, I came across this stored procedure: SELECT dbo.TBL_COORD.COORD_ID AS ID, dbo.TBL_COORD.LATITUDE AS Latitude, dbo.TBL_COORD.LONGITUDE AS Longitude, dbo.TBL_COORD.NORTHING AS Northing, dbo.TBL_COORD.EASTING AS Ea...more >>

let's work together ...more >>

just installed SQL server 2000 and using my client , i can't locate the server. I used SQL query analyzer to search but no servers were found. Error message is as below Server : Msg17,level 16, state1 [Microsoft][ODBC SQL server driver][DBnetlib] SQL server does not exist or denied acces...more >>

I need to compute factorials, but I hit a limit around 170!. Is ther anyway to handle numbers larger than the float data type can handle? Thanks ...more >>

Does sql server has the data type similar to BLOB (Binary larger object)which is available to DB2. BLOB in DB2 can support up to 2 G (variable-length data ) if it does have, which one offers better functionalities any advice will be greatly appreciated! ...more >>

When running the following SQL statements, I get the same results. Though I need to count only -30 days. Both statements below also consider the time of the day as well, which is not desired DELETE FROM MNT_R WHERE MNT_R.TIMESTAMP < GETDATE()- 30 DELETE FROM MNT_R WHERE MNT_R.TIMESTAMP <...more >>

My project is to automate testing of Stored Procedures of type SELECT (at least for now). I want to create a table where each stored procedure's input parameter values are entered and in another table the expected result value(s) are entered when executed against a sample database containing ...more >>

Greetings, When i log onto sql server using tsql i get the following line of information: locale is "/en_US.ISO8859-1/en_US.ISO8859-15/en_US.ISO8859-15/en_US.ISO8859-15/en_US.ISO8859-15/en_US.ISO8859-1" locale charset is "ISO8859-1" Is there any way that i can omit this message appearing...more >>

I have a stored procedure that creates an xml file. It executes a SELECT statement with the FOR XML clause and then writes the xml file using bcp and xp_cmdshell. I am calling this procedure by passing it a parameter via ADO. I have configured the SQL Server Agent with a proxy account so non-SysA...more >>

Hi, Can someone tell me what the best way is to migrate from a SQL Server 2000 Standard Edition to a SQL Server 2000 Enterprise Edition? Is this a migration possible from the setup program of the Enterprise Edition? What are the pitfalls? Thanks in advance Theo Linnenbank ...more >>

Little puzzle this. I need to link from SQL2000 to Access to get to a table held within an Access DB. Now you can link within Access to a SQL table, but can this be done the other way round ? It's the first time I've needed to do something like this. What I have is an application which was ...more >>

Hi . MSSQL Service Manager has a few servers available, how do I force a default server to launch at startup? Thank you ...more >>

Hi all the SQL wizards there!!! I have a Data base consisting of 675 tables. There isn't any data base diagram created and not even any data is present in the system tables to identify the realtionship betweeen the tables.i am planning to have the realtionship created betweeen all the tables f...more >>

DECLARE @UserName nvarchar(100) SELECT @UserName = SYSTEM_USER value returned is "Domain\NTSignonName" What I want is only "NTSignonName" Is there a function to do this or an easy parse for this in SQL2000? lq ...more >>

we are trying to delete data from a huge 75 million records table it takes 4hr to prune data delete from Company where recordid in (select top 10000 recordid from recordid_Fed3 where flag = 0) we have a loop that prunes 10000 records at a time in a while loop let me know if there is a bett...more >>

Hi, I have a table like the following fields: TradeDate Item Price Now, suppose I want to do an update like this: every price corresponding to a date higher than '30 Sep 2005' will be reset to the latest price in that item. Can I do something like the following UPDATE Table t SET Pric...more >>

Hello, I want to be able to view data from 3 tables using the JOIN statement, but I'm not sure of how to do it. I think i don't know the syntax of the joins.I imagine this is easy for the experienced - but Im not. Allow me to explain: I have 2 Tables: PERSON and SIGN PERSON ------ Pe...more >>

Hi All, I have a problem with my Server since I've install Terminal Services. Sometimes my users get error 'Timeout expired' when trying to query or open program. Whatshould I do to increase the performance? Thanks ...more >>

Hi, all. I'm setting up a SQL 2000 install on a Windows 2K3 server box. When I launch setup, I get a warning screen that the software is not supported. But the install works, I can create databases, and all seems okay. What's up with this? Would I not get MS Support with this configura...more >>

Hallo I need a help in optymalization database. My database is much slower than bigger databeses(the same structure, only data is different). The porblem is that i can't interfer in the structure - can't change procedures, view, select ect.. I dont have any ideas how to speed it up or where c...more >>

Using SQL Server 2000 SP3 I'm developing a data warehouse where data will be archived off to a filegroup, this filegroup backed up and the tables in this filegroup truncated to free up space on the server. So using Enterprise Manager I've copied data to the filegroup tables, backed up the fil...more >>

Hi, I need help on this one. For the past two days, whenever I make a modification to a stored procedure using enterprise manager (Apply), the stored procedure stops working. If I copy it under a new name, it works but as soon as I make a modification, it stops working. I am going crazy on ...more >>

Hi, I have data stored as in below sample : -------------------------------+---------------------------------+-------------- DateBegin | DateEnd | Rate -------------------------------+---------------------------------+-------------- 2005-11-13 00:00:00 200...more >>

Greetings, I just wanna know if anyone can tell me how to get all user defined tables in parent-then-child manner. I mean all the parents should be listed first and then childs. I dont think there is any direct way to do this, but i am not able to form any sort of query to achieve this. An...more >>