Are there SQL functions to convert back and forth between these two? TIA for the help. -- Posted with NewsLeecher v3.0 Beta 6 -- http://www.newsleecher.com/?usenet...more >>

Hi, If there are two tables with 1 to many relationship. In order to speed up the join, what would be the major different if I put the Clustered or Non-Clustered index on ForeignKey (Many Side) and MajorKey(One Side)??? If I put Clustered on both, would it be faster or it doesn't matter...more >>

I've been working on a fairly complex query and testing it in the QueryDesigner in Visual Studio. I was going under the premise that, "Gee, if it works in the QueryDesigner, it should work when I run it on my asp.net page." Stupid me. When I run the query below, I get: Incorrect syntax near t...more >>

Hi, This is what I want to do: User enters parameters StoreNo. Month(11), Year(2005), Open Months(8). Store Table : Store No. INT (IDENTITY) OpenDate (DATETIME) When the user calls a S Proc with the above parameters, I want to check whether the Store was opened for 8 Months fro...more >>

Below I'm trying to return the larger column. If the SUM of UnitsInStock is greater than the SUM of UnitsOnOrder, then return SUM(UnitsInStock) AS largerUnits and vice versa. This is in northwind, can someone help me correct my syntax? I wasn't sure how to do it with CASE. CODE SELEC...more >>

thanks ~ ...more >>

I have a table that associates name/value search items with documents: create table search_values ( id integer unsigned not null, document varchar(40) not null, name varchar(40) not null, value varchar(40) not null ); insert into search_values (id,document,name,value) values (1,"doc1...more >>

Hi, is there a way to find the last day of the month ? the input parameter is just the month. year will be the current year, start date will always be 1st of the month. I need to find the last day of the month Thanks ...more >>

Hi all, Is there a way to export the results of a query to an Excel file? I need to create a report in a Stored procedure and I want it to email an excel file to a group. I know how to create the email and attach the file, but I dont know how to Automatically create the file thru my Sproc. ...more >>

Hi, Our company policy for UPDATE / SELECT operation is as follows. For both of these operations we have to put NOLOCK hint. Nut i know that the 'SELECT' operation with 'NOLOCK' hint will return the uncommitted value. So my question is, can we avoid this by using 'NOLOCK' hint for insert oper...more >>

Hi, I have a trigger which contains a cursor such as the example below. DECLARE cCur CURSOR FOR select aFld from aTable where bFld = @aVar and cFld = bVar and dFld = @cVar this declare intermittently fails, on one occasion the declare succesfully executes but then it can fail. I have ...more >>

I have SQL Server 2000 run on 2 processors with 2gig of RAM on Windows Server 2003. I run select and insert statement for about 1 million records thru a client php scripts and it runs very slow. I check the memory usage, sqlservr.exe consumes about 1 gig of Memory. "Dynamically configur...more >>

Is anyone familiar with Versant and how it stacks up against MS SQL as a development technology. I have a client that currently has an application developed on Versant and they want to investigate moving to MS SQL. Any help or direction is appreciated. Thanks -- George Adrian...more >>

I am implementing user-defined aggregates. One of which is the string concatenation (which I think everyone is doing). The problem I have with this is that you have to hard-code what your delimter is inside the aggregate code. I would like my aggregate to allow the delimiter to be set thr...more >>

I have two tables, t1 and t2 for lack of a more imaginative mood. t1 -> field1, field2, field3, field4 t2 -> fieldA, fieldB, fieldC, fieldD I want to set t1.field2=t2.fieldB where t1.field3=t2.fieldC I have tried and tried, but no luck. This has GOT to be a whole lot simpler than I am ma...more >>

Hello everybody, I have a float type field in my sql server table and I want to select the data in the format $XX,XXX.XX. Any ideas ?? Thanks....more >>

It seems MS have not fixed the parameters.refresh bug yet.If I use this code, it would throw out an exception of 'AV in module SQLOLEDB.dll'. By the way, my SQL is 2000 + SP4 under Win2000 +SP4. Jack Zhong ...more >>

Hi everybody, happy Holidays to you all. I developed a windows application that connects to Sql server 2000, using windows authentication and it works, able to retrive and other data process. But when I used it on Sql Server 2005 Express, it was unable to retrive data. What is wrong with ...more >>

Hi, I am trying to return a resultset using the WHERE IN with a list of selection criteria, and would like to return a NULL where the value does not exist. Is this possible ? Grateful for any advice. Alex ...more >>

Hi, In our application we are getting a deadlock error “transaction (process id) was deadlocked on (lock) resources with another process and has been chosen as the deadlock victim” When we traced the queries in sql profiler we were able to find out two queries trying to acces...more >>

Hi, I am trying to implement master detail kind of functionality. table1 has primary key t1 and table2 has primary key t2. I have not placed any relationship on these tables. these tables are free tables. what will happen if I place foreign key will search sort become faster ? assume data i...more >>

Hi all Please any body tell how to duplicate an database within the same server from vb program? ...more >>

Been fun posting on some of these SQL newsgroups and receiving timely responses that made my day. Thanks to all who responded and also thanks to all the ones that ask questions. I only wish i could read the newsgroup postings every day Anyways Happy Holidays everyone.. ...more >>

Hi, I have a stored procedure which works fine under normal load. But under heavy load on SQL Server, my procedure is taking very long = time to execute. Is there any way to increase the priority of my procedure so that it get = proper time slot. My scenario is something is like this: My ...more >>