Is there a hot newsgroup that talks about using Crystal Report? -- .~. Might, Courage, Vision. In Linux We Trust. / v \ http://www.linux-sxs.org /( _ )\ Linux 2.4.26 ^ ^ 10:16pm up 6 days 23:39 load average: 1.00 1.01 1.01...more >>

Can I create a store procedure that I could fire up from a Visual Basic program? If so, how do I create the procedure, which could update tableA.col1 and tableA.col2 from tableA based on the join key colkey in tableB with tableB.col1 and tableB.col2. ...more >>

Currently I maintain artificial keys on tables by reading the max, incrementing it, and storing the next entry with associated data. Unfortunately, someone else may read this same value a try to store it also creating a constraint violation. Instead of using exclusive locks on the table for re...more >>

I have two tables, COMPANIES and COUNTRIES. In COUNTRIES, I have these data: CountryID | Description 1 | USA 2 | Canada 3 | Mexico .... In COMPANIES, I have these data: CompanyID | CountryID 1 | 1 1 | 2 1 | 3 2 | 2 3 | 1 3 | 10 Basically, a company can be located in multiple...more >>

Hi, I have a table whose DDL is given below: CREATE TABLE [Orders] ( [OrdID] [int] , [OrderDate] [datetime] , [1OrderDateONLY] [datetime], [1OrderDayName] [nvarchar] (15), [1OrderMonth] [nvarchar] (25), [1OrderDayOfMonth] [smallint] NULL , [1OrderWeekofYear] [smallint] NULL ) GO T...more >>

Hi, I have a table whose DDL is given below and which contains data for the last couple of years.... CREATE TABLE [DailySales] ( [InvoiceDate] [datetime] , [ProdCode] [varchar] (20) , [ProdQty] [numeric](20, 8) , [TotalSale] [money] ) GO What I want to do is populate the...more >>

Doing a query on tables and we want to order those by date desc.. So that the last date is first. Except, we'd like the values which have null dates to be at the very top. A union would work, but I figured there was a really elegant way to do an order by that would accomplish it. ...more >>

Is there any way of reading values in an external file with T-sql to be inserted into database. I would like to keep it to just sql codings instead of using other programming languages to do the process. Why i am doing this is because whenever an insert is done i have a trigger attached that ...more >>

Hi, i'm tring to use the FIRST function from standard SQL in a SQL server 2000 View... but this give me an error.. any suggest? Regards, Gianmaria ...more >>

Hi all, Newbie here, so please take it easy on my. I am trying to pass results from a select query to a stored procedure as an argument, and am having trouble firguring this out. Need to imbed in a sql script. Any help would be greately appreciated. Basically: SELECT ID FROM TABL...more >>

Hi NG's... I have a problem with an SQL query I'm trying to write, though this is not really an SQL problem - which is why this message is strangely cross-posted. I have a set of data in a table which, among other columns, has a "StartTime" and an "EndTime" column. The data relates to proces...more >>

Hello, I am trying to determine why a classic ASP application is suffering from performance problems running on SQL 2000 and Win2k3 SBS. I developed the app on Win2k where it performs flawlessly. After duplicating the database on the new server (Win2k3 SBS) as well as ODBC DSN connections ...more >>

Hello, I've written an extended stored procedure for some custom processing we need to do. The xp takes 2 arguments: strId varchar(23), numId bigint output. I noticed that the bigint argument shows up in my dll as a SRVNUMERICN data type when I call srv_paraminfo(). It is not identified as ...more >>

Hi, I have 3 databases located on 3 different servers: Database #1: NewArchitecture Location: Server1 File location: D:\sqldb\NewArchitecture_Data.MDF D:\sqldb\NewArchitecture_Log.LDF Database #2: goodofficesnew Location: Server2 File location: E:\goodofficesnew\goodofficesnew_Dat...more >>

I'm sending email from my database: DECLARE @object int DECLARE @hr int DECLARE @besedilo nvarchar(4000) set @body=(SELECT body from tableBody where id=1) EXEC @hr = sp_OACreate 'CDO.Message', @object OUT EXEC @hr = sp_OASetProperty @object, 'From','simon.zupan@stud-moderna.si' EXEC @hr =...more >>

Any tips on converting JDE (JD Edwards) Date to SQL Date. Thanks ...more >>

Hi all, I have the table with datetime column (data_alertu). I want to make select to get data about alert count for week numbers. SELECT DATENAME(week, data_alertu) AS Tydzieñ, COUNT(DATENAME(week, data_alertu)) AS 'Ilo¶æ alertów' FROM _Alerty GROUP BY DATENAME(week, data_aler...more >>

Hello, I have a table like this CREATE TABLE [dbo].[Addresses] ( [AddressID] [int] IDENTITY (1, 1) NOT NULL PRIMARY , [ZipCode5] [char] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Type] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Address1] [char] (50) COLLATE ...more >>

I have a user defined funcation to get the every day in a date range. Is this possible to create an index on @myTable, since the table scan hurts the performance a lot Thanks CREATE FUNCTION [dbo].[udf_return_daterange @date1 smalldatetim , @date2 smalldatetim RETURNS @myTable ta...more >>

Hi All, what I want to know is how can I get the table names and field names from a database without knowing what databases there are. Thanks Henk ...more >>

Hi All, Can you please tell me how to make an existing column as identity column. I tried the following but I get the error: Server: Msg 156, Level 15, State 1, Line 1 Incorrect syntax near the keyword 'identity'. create table test1 ( emp_id smallint not null, emp_name varchar(15) not...more >>

I have an employee with a strong background in VB and Java, as well as two decades of RPG, DB2, etc. database programming in System36 to OS/400 environments that I need to get up to speed on SQL programming. This wouldn't be the typical Admin training courses, and even the Microsoft 2073 (Progra...more >>

I need help with coping a file from one server to anoter server. I am trying to use xp_cmdshell with no success. Here is a sample of what I am trying to do. xp_cmdshell 'copy f:\mssql7\warehouse\joblogs\hazen02_kill_processes_5-5-04 l:\temp' The L: drive is on another server, do I need to u...more >>

How can I print the sql script of a proc or function to the console via OSQL? -- Semper Fi, Red Please post to newsgroup only ...more >>

Please don't tell me it is not possible to enumerate local instances of SQL Server 2000 when disconnected from the network using Win2000 or WinXP. How does Enterprise Manager do it? I tried the following, neither of them worked: osql -L SQLDMO.ListAvailableSQLServer Thanks...more >>

I have a stored procedure that will use a derived table. That derived table will be JOINed against another table, and a WHERE clause applied to the whole thing, so only a small fraction of the rows of the derived table will be used. It is quite possible for me to add a WHERE to the derived...more >>

Hi I have a query which returns 9000 rows in 6 minutes, the problem is with the select top 1 statement which hits the atstransacts table having 14 million rows, if the order by is removed from the select top 1 query the overall query returns rows in 5 sec. any suggestion to change the query or to i...more >>

Hi all I have a field in a table that contains names The data contains for example.. 'Mrs. jane doe 'Mr. John doe What I want to do is update the database to remove 'Mr. ' or 'Mrs. ' from the name field Can someone tell me what the sql would be Thanks Hammer...more >>

Sorry for reporting this but I can see from the dates on postings that if a question goes un-answered for more than a few days, it never gets re-visited. so... I have a reflexive table Employee i.e. I can have a CEO with many VP's, each VP can have many Managers etc... So basically I have an n...more >>

Hello.. is there a way to do a Select first_name, last_name where last_name between 'a' and 'g' and include all the g's? While it's logical to me that you would get everything between a and g, it seems counter-intuitive, not to mention not so easy to explain to Sally Secretary. Thanks! ...more >>

Hi, I'm wondering if anyone knows why diacrcitic characters might be "stripped" or normalized. I'm using an nvarchar field (i.e. Unicode), and if I insert this character: C with an upside down ^ over it - via a normal insert statement in QueryAnalyzer, and then select it back out via Quer...more >>

Hi Everyone, I have this table: Create Table PerformanceIssue ( PRID UniqueIdentifier NOT NULL, PRCode Int NOT NULL, PRDesc Varchar (100) NOT NULL ) I like to query for a certain PRID: SELECT PRID, PRCode, PRDesc FROM PerformanceIssue WHERE PRID = '6A4E7F8-05C3-42D1-A5B7-...more >>

Hi I am working as a project manager for a team of 6 developer I am looking for a tool/software to help me track task assigned to developers and their statuses Any help is highly appreciated Thanks Tom Brad ...more >>

What is the row terminator in bcp for line feed {LF}. It works fine with DTS when I used Row terminator as {LF}, but it is giving error when I used row terminator \n. Can you help me....more >>

Hi, How can I add hours in sql? I need to summarize a column with datetime values. Some Idea?...more >>

Hi I am trying to drop a table but its giving error message Cannot DROP TABLE 'dbo.Tablename' because it is being referenced by object '_hypmv_0' I cant even find the object name _hypmv_0 in the database. Please help to solve this problem Thank you...more >>

I have created a user sql function that does aggrigate queries on a table (against a clustered primary key). When the function is called with the parameters 'hard coded' the function it runs in under 3ms. When the function is called with the parameters passed as variables the function it runs...more >>

Hi all, Let me first explain what I am trying to do. I have a web app, where from my asp page, i call a stored procedure. Now this page is used by N users concurrently. This SP updates a table, updates a second table with first as ref, and clear first table. in between there is a delay of...more >>

Auto Increment columns are cool, but is using them a good design ? One major problem we run into with auto increment columns acting as keys is when we export data and try to import them. Other than this are they any other disadvantages? Also, do you think DTS can solve the problem of Autoincremen...more >>

How can I find the length of a varchar including spaces? The len function does not count spaces!!!! Thanks, -- Jeff Langston Director of Product Development Cashless Systems, Inc. MCP, MCAD ...more >>

Hi all, I am working on some data conversion, and I have been given a table that looks something like this: ----------------------------------------------- -- DROP TABLE dCommentTest CREATE TABLE dCommentTest ( [KeyName] [nvarchar] (10) NOT NULL , [LineNum] [int] N...more >>

Hi group , Please let me know which formule is usefull for calculate the day of week based in a date. my date is datetime. day = convert(int,MyDate) % 7 is't working ...more >>

Hi Everyone, I've been putting this off for awhile but I finally am switching my compatibility level from 65 to 80 and I'm having this issue. I'm using the following query to get all my employees but some of the "employees" are Inventory, Server Room, etc and these are located in the EmpLast f...more >>

First question; Can you raise an error in a user defined function? If so, will it need to be handled from the calling stored proc or will it terminate the stored proc and notify the client without any intervention? Secondly, what is the best practice for raising the same error via multiple sto...more >>

Hi, I'm trying to use the stored procedure below to insert into a table and return the new identity after the insert. The problem is the SP runs without error but I get no result returned when I run it from an ASP page with "EXEC insert_photo 'test', 1,1,11". The row is being inserted in...more >>

Hey... does anyone know if MSSQL has the equivelant of the VB NOW function, to return the current date and time? ...more >>

Regarding an older posting that was never really resolved: http://groups.google.ca/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=endp1IqoAHA.2236%40tkmsftngp05&rnum=1&prev=/groups%3Fq%3Dsql%2Berror%2B%253E%2B0%2B%2522never%2Bgoes%2Bto%2Berrorhandler%2522%26hl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26s...more >>

I have got into an argument with one of my colleague about having business rules in stored procedures. He is saying that no business rules should be described by TSQL. The rules belong in the middle tier. Can someone provide some serious thoughts about the subject? Thanks, Mark ...more >>

I would like to create some web services using T-SQL can any of you please clarify some resources or web sites to point me in this direction. Thanks Belinda...more >>

SQL200 Im looking at setting up a SP to handle checking of data for a client. I thought the best way would be to create a tempory table containing the data for the client and then depending on the task, retrieve the data required and update as needed im tring a very simple version first to se i...more >>

Hi I had a query earlier that was answered now I need to be able to select all orders that were placed in the current week no matter which day it is run on I tried the following which did not work select * from orders where orddate =DATEDIFF(ww, orddate, getdate()) does anyone know of...more >>

Please kindly help me with this select statemen I have a table where the data types for S03_01 and S02_03 are integers I want to select S02_03 and S03_01 and output them depending on thei value see code below I might be doing something wrong here,as I am getting a conversion error Any be...more >>

Hi i have a problem at hand can anyone help me out? i have a table which contains rows . i want to create another table at runtime that has as its columns the row of the prev table. the number of rows are determined at runtime as such the columns are determined only at runtime. fo...more >>

I am looking for a way to write a procedure to drop all indexes from a table, however many it may have, by creating a procedure that takes the table's name as a parameter, I have tried enumerating the sysindexes table but to no avail, as some of the rows in there don't relate to actual indexes. The ...more >>

Hi I doing an update of an MS access project to SQL Server 2000. No problem with the data, but I can't update all the queries because of a different sql syntax. I tried to use DTS but Access queries could only be converted in static tables Does anybody know a tool or a way to make the conversion...more >>

Dear all, I am at my wits end. I have written an insert trigger In SQL server 2K that is supposed to fire when a record is inserted in a table in a third party application. The trigger includes a simple select query that looks for any record in a remote server, like the following: CREAT...more >>

Hi I have a dates problem I have to select data from 1 -2 weeks old so thelast week will be week 1 and the week before week 2 I had originally tried this select * form orders where orddate < getdate () -7 and orddate > getdate () -21 But this doesn't give me the weeks I need as if I ran ...more >>

Hi I've to schedule a procedure run via SQL server's Management SQL serverAgent Job. The procedure have some PRINT statements. When I run the package, I want these PRINT statements output plus other outputs like how many rows affected, to be stored in a text file, so that I can go thru them when r...more >>

Hi I've to schedule a procedure run via SQL server's Management SQL serverAgent Job. The procedure have some PRINT statements. When I run the package, I want these PRINT statements output plus other outputs like how many rows affected, to be stored in a text file, so that I can go thru them when r...more >>