Hi all, I have an application which logs a considerable amount of data. Each day, we log about 50,000 to 100,000 rows of data. We like to report on this data... currently I'm using a stored procedure to calculate the statistics, however since this is an ad hoc, reports take a while to...more >>

Hi Does anyone know how to use sql server desktop engine with the enterprise Manager vs using osql? Thanks, Cindy ...more >>

Okay. I have this function in vb.net. It's purpose is to query the sql server, and return me a count. Here is the function: Private Function _countCallsCameIn(ByVal ApplicNum As String, ByVal date1 As String, ByVal date2 As String) As Integer '...the query were going to use... ...more >>

Gentlemen and Ladies Below is the complete query that I have convert over from HQL to SQL and I am getting one last error which is Server: Msg 170, Level 15, State 1 Line116 Line 52: Incorrect Syntax Near ')' I am running lines 65 thru 115 when I get this...more >>

Please check my sintax for MS SQL 2000 query: Update Geo_Location Set Driver_Route# = '12101', Pedestrian_Route# = '15201' Where MAIN_LOCATION = 'Q28-41' OR MAIN_LOCATION = 'Q29-41' OR MAIN_LOCATION = 'Q30-41' OR MAIN_LOCATION = 'Q30-42' OR MAIN_LOCATION = 'Q29-42' OR MAIN_LOCATI...more >>

How can I join to a derived table??? My derived table would look like... (SELECT file_id, MAX(DATETIME) AS MAXDATE FROM DataTrac.dbo.NOTES WHERE group_id = 'SRV' GROUP BY file_id) MAXDTTM and I would need to LEFT OUTER JOIN from a table called GEN matching by file_id. A LEFT OUTER...more >>

Hello Group, Sorry my english is very littel. In my company I have two servers: first developer server (DevSvr)- for developers and second server (MainSvr)to use for other emplooy - for user of application. One of databases was changed on DevSvr (add new tables, sp, indexes etc.). How compar...more >>

I'm trying to run a data-validation query in SQL Server, but am not sure how to do it. create table testTable (ValidatedID INTEGER, EnteredValue NVARCHAR(30)) UPDATE testTable SET ValidatedID=CAST(EnteredValue AS INTEGER) WHERE ISNUMERIC(EnteredValue)=1 AND CAST(EnteredValue AS INTEGER) IN...more >>

I have a requirement to be able to upload a file (let's say xls spreadsheet) to a table, and then have someone else be able to download that same file, modify it and re-upload it again. This is common place for SharePoint using SQL, but my requirement doen't involve SharePoint. Any ideas, exam...more >>

"Listening to the victims, I can't begin to understand the pain I inflicted on these innocent people," Rudolph said in his statement, which he read afte r 14 victims or their relatives read statements. Two other statements were r ead into the record. Gwedif sprouted a tentacle and placed it on ...more >>

Hi, I publish a table on a website. At the end of each row I want to show an up- and downbutton. The buttons haves an id as parameter. Inside my table I have a vieworder column, this is the way I sort the table. What I want is that when you press on the up- or downbutton that record move...more >>

I tried posting this on microsoft.public.dotnet.languages.vb.data, but got no responses. Maybe I'll have better luck here. I'm using Visual Studio 2003 and inline VB.NET, not code-behind. ---------------------------------------------------------------------- I am confused by the behavior...more >>

Hi! I've been working on a stock management software for a couple of months. The user creates/changes stock documents which have a header and several hundreds (usually) lines. Now, when we change a stock document (deleting, adding, changing lines) the current software deletes all rows before...more >>

I have COM object working with database via connection with administrative rights. I need method for checking user name: can this user has db access or no. I want to check: 1. SQL Server users 2. Windows users which added as a SQL Server logins/db users 3. Windows users which can connect ...more >>

Hi Folks! I'm working with a small group and I'm writing a VB app that gets data from a SQL Server. One or more of my collegues has found a way to make my queries timeout. The database has about 15% usage and all the usage statistics are low. Most of the time the queries work fine but I...more >>

Hi. When I create an Index, the following message appears me Server: Msg 8662, Level 16, State 1, Line 1 An index cannot be created on the view 'VW_CAM' because the view definition includes an unknown value (the sum of a nullable expression). The view doesn't contain any value in Null, att...more >>

I got a stored procedure with 1 parameter and I want to call this stored procedure inside an Excel Query , I tried ..dbo.MySP ? It return with error message "Parameters are not allowed in queries that can't be displayed graphically" The purpose for this approach - This would allow m...more >>

I have a table (sql Server2k) which users connect to through ODBC - read only. I have to input/write a lot of data to this table everyday. I observed that it takes a lot longer to populate this table than one which is not public. I am guessing that people have this table open through ODBC. ...more >>

I am trying to create a unique constraint on a computed column. I've tried unique index, too, but they both fail w/this error: Server: Msg 1933, Level 16, State 1, Line 2 Cannot create index because the key column 'msgID' is non-deterministic or imprecise. ideally, i just want endpoint+M...more >>

I have two tables that line up correctly. But when I add textboxes into the cells of my table, and it is close to the right edge of the table, it increases the size of the cells making all the rest of the cells get out of position. I have cellspacing and cellpadding set to 0, and borders=1...more >>

I had about 30 schedule jobs that either import data or run sql queries. They have worked wonderfully for months. All of a sudden they are failing. I get the error message 203 ENVVAR_NOT_FOUND which translates to The system could not find the environment option that was entered. I don't...more >>

Hi, I have a table of tests, and I want to be able to get the pass and fail totals on the tests. Here's what I have so far select month(lastmodified),datename(mm,(lastmodified))as month, count(id_status) as Total, id_status from tests where id_status = 2 or id_status = 3 group by month(la...more >>

Hi, I have a stored procedure that produces a table: SELECT DISTINCT tblPatient.pntCode, tblPDT.pdtDate, Survival..... FROM tblPatient, tblPDT WHERE.... ORDER BY..... I now need to do some calculations on the genearated table. things like count all rows, count the number of different pn...more >>

I need some confirmation. Is there any document from Microsoft that states no changes need to be made to 32Bit Windows based Client/Server apps to access data on a 64Bit SQL Server? We code with VB6 an use MDAC to access our SQL Server DB, if a client wants to move his SQL Server to a 64Bit...more >>

Goodmorning everybody. I have a maint job that runs once weekly - this is one of the agent job steps: EXEC db1..sp_MSforeachtable @command1='DBCC DBREINDEX (''*'')', @replacechar='*' EXEC db2..sp_MSforeachtable @command1='DBCC DBREINDEX (''*'')', @replacechar='*' EXEC db3..sp_MSforeachta...more >>

Hi, I have a select query that can generate apparent duplicates; this occurs because the Histology value is determined from a table tblSample, this may contain a number of samples for the same location as there are different methods of obtaining samples sometimes 2 or more method are used to ...more >>

Dear all, We've got one db allocated in a SQL SERVER 7.0 and another one with compatibility with 6.5 and now we want to move it to SQL SERVER 2000. Change collation at server/db is easy, but problem is for all the columns. Does anyone have any script for do that automatically? Thanks a...more >>

Hallo! I'm having a problem with bad query executionplans. The optimizer won't get the right plan to execute the query fast. The optimizer perform cluster index scan instead of using a index seek an also using a hash join instead of a loop join. Now, when I set a join hint to use the loop...more >>

Hi, I am trying to create an inline user-defined function. The code below works fine, however I want to be able to put an "If else" statement in it, so that depending on the @variable entered, a different Select clause will execute. How can I put an If Else clause within the code below? ...more >>

I am trying to calculate the time difference between two cells, However I have tried the datediff but it does not display the answer that i require, I am looking for the time diffence to be displayed in months, days, hours, mins and seconds, Can anyone give any help? Also, Is there any w...more >>

I need to get a set of int values from some query and use this set later in the same SP. The query is looking like this: (SELECT SomeID FROM tblTable WHERE SOMECONDITION ORDER BY SomeID) How can I store the set of these integer values into a temporary variable and what type should I u...more >>

I want to resotre a databse from a backup file like: restore database Health from disk='c:\Health.bak' WITH REPLACE The Health database did not exist in my SQLServer before restore. After restore, it will add a .mdf in some folder. How can I assign a folder to store the .mdf when restore? ...more >>

Hi all, I am trying to execute a query that shortens selected string values beyond a certrain point (40 characters), thus provide a summary. If the string is less than 40 characters the whole string is returned. My attempt so far is: SELECT id, Case task WHEN Len(task) > 40 Th...more >>

Hi I have a cursor that I need to pass a dynamic sql statement to that is in a variable, is this possible? e.g. DECLARE curOneRecord CURSOR FOR @SQL Thanks B ...more >>

I use backup database pubs to disk='c:\pubbackup.bak' to backup pubs database. Then I detach pubs, and delete pubs.mdf and pubs.lof After delete the files, I use restore database pubs from disk='c:\pubbackup.bak' to restore database form backup file, but it fail with message: "Can...more >>

Hi all, I know this is a SQL group and I now apologise for posting in the "wrong' group, but I had difficulty tracking down the "suitable" group. I thought that a lot of people here would be able to help me. To my question. I'm learning VB.net from scratch myself with no "official" help....more >>

I use the statement below to backup my database backup database Health to disk='c:\Health.bak' The size backup file Health.bak will increment every time when I perform the statement even I did not modify the database. For example, the first time after I execute the backup statement...more >>

We can use the codes below to get the recovery mode of a database: select DatabasePropertyEx('test', 'Recovery') Now I want to change a database's Recovery to SIMPLE. How can I do that? ...more >>