I have duplicate records in a table based on say OrderNum, I would like to copy 1st record for each OrderNum from this table into a new table and...

Kim

08-12-2004 03:31 PM
Hugo Kornelis

Is it possible to do updates to a grid result from the query analyzer? i.e. select * from ABCD gives a grid result (w/ PK cols), can I edit one or...

Bruce H

08-10-2004 09:34 PM
Vishal Parkar

Hi all, I am trying to sort a really large file of information and I need some help as I cant work out how to get some of it. the fields I have...

Chris Scott

08-10-2004 11:24 AM
Hugo Kornelis

I have created a Job that uses "cmcexec" to execute a SQL script. This Job brings SQL to single_user mode then restores from a directory that is...

cbriscoejr

08-08-2004 10:50 AM
Hari Prasad

Hello, I am looking into storing images into SQL and want to use BLOB which I understand to be the best method. Can someone supply me with a...

John A. Curry

08-06-2004 01:56 PM
HelloWebWorld

Hi, There are 3 options:- 1. You can generate the script for all jobs ( Enterprise manager -- Right click on the jobs node in SQl Agent -- Jobs|...

Hari Prasad

08-05-2004 10:07 PM
Hari Prasad

Im relatively new with sql and im having a problem creating a criteria based on todays date less 150 days. I tried to use the following... < GetDate...

Bob

08-03-2004 02:59 PM
Hugo Kornelis

I have a table called cr. Within that table I have the colums c_id, c_type, first_name, last_name. I need help creating a query that will pull from...

Eric

08-03-2004 10:33 AM
Eric

I tried to renaming database using query analyser of sql server 2000 but I got this error msg. Server: Msg 5030, Level 16, State 2, Line 1 The...

dave

08-03-2004 04:42 AM
Lance Harston

Hello, I wanted to bring to your attention a new helpful SQL tool that's coming out. It enables you to run a search & replace throughout your entire...

News.microsoft.com

08-02-2004 08:58 PM
News.microsoft.com

Does sqlserver 2000 supports multi threading? If so how can we implement it? As per my knowledge it supports Symmetric multi processing. Can you...

Sriram

08-02-2004 04:39 AM
Sriram

I currently have information stored on two different SQL servers. I need to run a query that qeurys both at the same time making comparisions. I...

Devin

07-29-2004 02:54 PM
Vishal Parkar

Hi all, Is there any function that truncates a decimal numeric without rounding, if i use cast it rounds the figure but can i don't want that i.e i...

s.isa

07-29-2004 07:52 AM
alokelogic

I've Emp table with empno, name, dept. The data for the dept are A,B,C I want to update that table Edu for A, Sport for B,.... using self join in...

mottu

07-29-2004 07:05 AM
Hugo Kornelis

Hi, Appreciated it if someone could help me with regards to the abovesaid problem. I don't know how to append data using SQL Query Analyzer from...

GW

07-29-2004 02:30 AM
Hari Prasad

I am trying to join two tables on a date field. My problem is the hour/minute section. I want to match 07/26/04 on both tables, regardless of...

Dion

07-26-2004 09:23 PM
Steve Kass

I have a SQL statement like the below listed inside a stored procedure. ------------------------------- declare @cnt int declare name...

kk

07-26-2004 07:19 AM
Hari Prasad

Hi i am new in mssql7.before i am using sybase and some of the tables having field type time.after convert to mssql7 i changed that field type as...

sara

07-26-2004 05:00 AM
Hari Prasad

hi don, create a function as shown in following example. and use this function in the query as shown below. ex: create function dbo.ret_num (@str...

Vishal Parkar

07-23-2004 03:51 AM
Vishal Parkar

HI, I am new to SQL but have experiene in access. I would like to convert the following from access SQL to proper SQL. Can anyone help. How should...

07-22-2004 01:44 AM
Steve Kass

Hi there, Can someone help me, I am using a piece of software called visual web task, it spiders web sites, I am pulling the contents of a script...

Phil

07-21-2004 01:38 AM
Phil

I have two columns I want to compare, both varchar, and would be in this format Subject | Instructor ---------------------- ACCT101-nnnnn |...

spacejunk

07-20-2004 03:18 PM
Steve Kass

Hi My EQ model dispalys a normal table when you ask a question such as; show me the amount of goods solds for last 5 years. it shows the amount...

KK

07-15-2004 10:40 PM
KK

Please start Log shipping Group in SQL Server newsgroup

Mayur Dhondekar

07-14-2004 12:32 PM
Mayur Dhondekar

I am receiving the error. If SQL Server Setup fails, Setup will roll back the installation but may not remove all .manifest files. The workaround is...

Brad

07-14-2004 09:12 AM
Brad

Hello, I could not use this in the criteria filed of my query. = System.Environment.GetEnvironmentVariable(MYID) It gives invalid object...

JIM.H.

07-13-2004 08:06 AM
JIM.H.

Hi I am facing a problem with SQL adapter. I have my solution running at production and it critically needs a solution. I am using SQL adapter to...

Imran Ramzan

07-13-2004 07:32 AM
Imran Ramzan

Hi My EQ model dispalys a normal table when you ask a question such as; show me the amount of goods solds for last 5 years. it shows the amount...

KK

07-12-2004 12:31 AM
KK

Is there a way to convert a field to Currency format with a comma as a seperator. ie 50000 would be $50,000 1234567 would be $1,234,567 etc. I am...

Dan

07-05-2004 10:57 PM
theplantman222

G'Day folks, My question is related to deleting an existing db in sql. The reason why I need to delete the existing db in sql is to update the db...

William

07-05-2004 09:58 PM
Hari Prasad

delphi3 , BDE , sqlserver2000, the problem is in some cases some i edit in adataset and then post in that dataset and then close the form of that...

Mohamad Adel

07-05-2004 04:04 PM
Mohamad Adel

This was the script for access: oRS.Open "Select * from AlertHistory Where Date =#"&DateValue(LogTimeStamp)&"#;",oConn does anyone know the...

07-02-2004 04:11 PM
Anith Sen

Hi folks, I have a project underway and am having a couple technical difficulties. My duty is to run my access database with sql server. My fist...

eNerGiZer1010

07-02-2004 04:01 PM
Hugo Kornelis

Select statement is running 3 time slower than before after I installed sp3 in SQL 2000.(before is sp1). Do anyone know why and how to fix it? Thanks...

new

07-02-2004 08:06 AM
Hari

Hi Folks, I'm having a bit of trouble updating my script. I have a script used for MS Access and I need to transfer it to be compatible with MS SQL...

Will

07-02-2004 02:23 AM
Crazy Pete

Stefaan, 1. What result do you get from select @@version ? 2. The following produces no error for me:

Stefaan Dewulf

07-01-2004 03:43 PM
Anith Sen

I am adding a linked server to another SQL server within a stored procedure. I need to verify the link was made before I start running any more code....

Matt Tapia

07-01-2004 01:46 PM
Steve Kass

I need some serious help. I know nothing of SQL or anything but our business has a program called Shoplink and we use it to do our order processing. ...

ylona schneider

07-01-2004 10:31 AM
Vishal Parkar

Hi NG, in your opinion (sorry for my bad english) why I can run my query (standard ANSI) in the database A (SQL Server 2000 sp3) and can't run it in...

Giorgio (Italy)

07-01-2004 02:32 AM
Giorgio (Italy)

PLZ help me!!! i got to make a access frontend for a MSSQL server. i need to select some stuff per week how can i make thet?? PLZZ HELP I GOT TO...

Crazy Pete

06-30-2004 11:31 PM
Steve Kass

I am using the following query: DELETE FROM ORDER_HEADER WHERE (INVOICE_NUMBER IS NULL) OR (INVOICE_NUMBER = '0') This works fine but doesn't...

Bill

06-30-2004 10:23 PM
Hari

hi rhonda, modify your trigger body as follows. CREATE TRIGGER trgCalculateLostDays ON incident FOR INSERT, UPDATE AS UPDATE a SET a.DaysLost =...

Vishal Parkar

06-28-2004 09:34 AM
Vishal Parkar

Is there any way I can change the object owner for over 100 tables in a single data base at once in SQL 7 without using the sp on each table?

Smith

06-26-2004 05:42 PM
Nigel Rivett

I am using the following to send mail, but instead of @TO = N'yyy (AT) abc (DOT) ab.ca' I want to specify a variable from my procedure: @TO =...

schmidtk

06-26-2004 05:38 PM
Nigel Rivett

Hello Everyone, Does anyone have any ideas on how to hardcode headers and footers in a text file that is a DTS export from SQL? Thanks!

j

06-24-2004 01:03 PM
j

That will always execute the drop table if object_id('##Table') is null print 'True' else begin print 'False' Drop Table ##tmpTable end And think...

Nigel Rivett

06-24-2004 01:21 AM
Nigel Rivett

Hi all, I've got a huge Reprot in Crystal 8.5. I've discovered that I can't work with the report if I change the Stored Proc the report is based...

baz

06-23-2004 09:12 AM
Vishal Parkar

Do u know of a function that will return a field from the previous record if the current record's field is null? I know this is available in Monarch,...

Kole

06-22-2004 03:28 PM
Hugo Kornelis

Hi all, I've got a Join All stored proc which returns about 120,000 records. It simpley returns Account number field and Balance field for each...

BGS

06-22-2004 03:22 PM
Hugo Kornelis

Hello all I'm new to all the technologies above and so really need some help as I am solely in charge of building a Warehouse solution that uses all...

maria

06-21-2004 09:43 AM
maria