I'm quering about 5 tables using inner join. On one of the tables i just want to count or sum up the results. Here is the example I'm trying to...

LU

05-18-2005 04:54 PM
Hugo Kornelis

Which is the more efficient way to clear the contents of a table: DELETE FROM tableName TRUNCATE TABLE tableName Or DROP the table then create it...

Chris Lieb

05-18-2005 02:12 PM
Hari Prasad

I am looking at a table, using Enterprise Manager, that has several fields defined as Binary. All I seem to be able to see is the literal "<Binary>"...

Tom Glasser

05-18-2005 04:15 AM
Hugo Kornelis

Hello! I wish to use a variable i a query that can change under execute. Here are some of my rows, i wish to make the f3 colonne F1 F2 F3(my...

CJ

05-18-2005 04:06 AM
Hugo Kornelis

Hello, The @parameters that I am receiving into my SQL query in SQL Serer 2000 Reporting Services are based on user selection from a drop down combo...

Rhonda Fischer

05-12-2005 04:09 PM
Hugo Kornelis

If the destination SQL Server is started under a domain account that does not have local administrator privileges on the source computer then the...

Omkar Ambulkar

05-10-2005 06:48 AM
Omkar Ambulkar

I'm trying to create a JSP page which access's a database of about 3 million records. What i am trying to do is display this in a webpage table with...

Garfinkle

05-10-2005 03:41 AM
Garfinkle

Does anyone have logic to take an hl7 file format and create a flat file. I am having a bit of difficulty.............. Any help would be a...

Greg

05-09-2005 03:46 PM
Hugo Kornelis

Hi, FYI, all about SQL is new to me. I would appreciate it if someone could help me on the following :- 1) I have one text file containing 8 fields...

GW

05-09-2005 03:41 PM
Hugo Kornelis

Hi, I have a problem to run a query like this scenario: i have players in a table who have scored in many matches and i want to take the 5...

tw

05-09-2005 03:37 PM
Hugo Kornelis

Ladies and Gentlemen, I would like to offer you the following string functions Transact-SQL GETWORDCOUNT() Counts the words in a...

Igor2004

05-03-2005 10:01 AM
Igor2004

Hi All, I have a Stored Proc and would like to pass in a VARCHAR parameter. The problem is that the query will need to use it in a IN...

Kunkel

04-28-2005 06:06 PM
Hugo Kornelis

Hi, I would appreciate it if someone could help me on the following: I have several tables eg, tbl1, tbl2, tbl3.....tbl10. How to view all...

GW

04-27-2005 03:40 PM
Hugo Kornelis

I want to be able to check if column 27 has been updated either on an insert or an update. If this column has been updated with a value I want to...

Al Newbie

04-22-2005 05:37 PM
Hugo Kornelis

I can't seem to figure out how to create a cross tab or pivot query on data. If I was writing the SQL in Access I would write it like TRANSFORM...

MChrist

04-22-2005 04:55 PM
MChrist

I want to be able to check if column 27 has been updated either on an insert or an update. If this column has been updated with a value I want to...

Al Newbie

04-21-2005 04:22 PM
Hugo Kornelis

I have 2 tables, Make and Model where Make is the master table and Model has a reference of make table by Make_Id since there can be multiple models...

MoinJ

04-20-2005 04:12 PM
Hugo Kornelis

On Thu, 14 Apr 2005 04:52:00 -0700, Andy wrote: Hi Andy, My bad - since I adapted the script to work for more than one code at once, I thought...

Hugo Kornelis

04-20-2005 08:19 AM
Andy

hi i am facing one problem i am having two table location and routesegment location table having locationid as primary key. routesegment having ...

bhavik

04-19-2005 03:56 PM
Hugo Kornelis

I have SQL Server Developer edition on my laptop. Want to install MSDE on same laptop (so VB .NET 2003 will work. Any issues here with two...

rOBBY

04-18-2005 02:34 PM
Hugo Kornelis

I am wanting to create a sql query to get the Members of a Active Directory group. I am using the below code: SELECT * FROM OPENQUERY( ADSI, 'SELECT...

Jesse

04-18-2005 12:36 PM
Jesse

Hi folks, i have to translate SQL-Statements from Access 2000 to SQL Server 2000. There was a lot of Access-Functions used (mid, str, iif ...) and i...

nieurig

04-16-2005 03:52 PM
Hugo Kornelis

I have two of the exact same rows, but I want to change one field of one of the rows. How do I do this? i.e. table_a group name revenue A jim...

bamboo

04-15-2005 02:10 PM
Hugo Kornelis

What is the syntax for a query that will give me the Count of shipped each month. I think I need to do a Count on PK_ID and Group By the DateShipped...

J

04-15-2005 02:02 PM
Hugo Kornelis

Hi, Could you help me modify the SELECT statement below that would accomplish my final goal. SELECT col1, col2 FROM table1 WHERE col3 < @V In col1...

Vanessa Lee

04-14-2005 08:18 PM
Vanessa Lee

On Wed, 13 Apr 2005 23:14:01 -0700, Malathi wrote: Hi Malathi, As far as I know, deploying your database over Internet requires you to buy a...

Hugo Kornelis

04-14-2005 08:00 PM
Malathi

Hi I am using Mssql2000 and i am facing a problem while saving data from my application. This Procedure is working fine. CREATE PROCEDURE test(@edate...

shif

04-14-2005 04:19 PM
Hugo Kornelis

Hi every one I am having problem with search, I have data in sql server in arabic language , when I am searching via submitting a form using asp it...

FaYYaZ

04-14-2005 10:18 AM
FaYYaZ

My order dates of service load from a text file and contain "today minus 1, plus 3". For example, using today's file, this equates to yesterday's...

tag

04-12-2005 03:00 PM
Hugo Kornelis

hi I have problem with sql. I dont userstand what should I do. my problem is I have table UserLocationHistory I want those user who have latest...

bhavik

04-12-2005 05:53 AM
bhavik

TOM GUGGER ERP SOLUTIONS INC 560 BRONX DRIVE TOLEDO, OH 43609 (419) 380-8853 tgugger (AT) buckeye-express (DOT) com TSQL / CONTRACT TO HIRE / ATL

Tom Gugger

04-11-2005 10:25 AM
Tom Gugger

TOM GUGGER ERP SOLUTIONS INC 560 BRONX DRIVE TOLEDO, OH 43609 (419) 380-8853 tgugger (AT) buckeye-express (DOT) com

Tom Gugger

04-09-2005 01:30 PM
Tom Gugger

Querying a table that has the line items for a ticket sold at a retail store. So I am looking for the tickets that only have CIGARETTE items on it. ...

AshleyT

04-07-2005 04:00 PM
Hugo Kornelis

Hi All, Can someone please help me with below access query to convert to sql ? UPDATE tblEmp SET emprank = IIf('! Mod 3', '! Mod 3', 3). Thanks in...

Andy

04-02-2005 03:00 PM
Hugo Kornelis

Hi. I have to use a long, complicated "Where" clause in a SQL statement and thought it would be better to break it up into 2 Selects but am not sure...

RitaG

04-01-2005 03:57 PM
RitaG

Hi there. This is not my 1st post related with performance. I am experiencing serious performance problems with a VB6 application running over a SQL...

Marco Pais

03-31-2005 03:40 PM
Hugo Kornelis

Hi there, I was following an HOW TO article from Microsoft's KB (ID: 224587) related with SQL profiler. Once SQL Profiler is opened, they say to...

Marco Pais

03-31-2005 09:32 AM
Marco Pais

Hi there, I have a VB6 application working over a SQL Server 2000 database. since a long time ago, I am experiencing serious performance problems,...

Marco Pais

03-31-2005 08:29 AM
Marco Pais

I have a table that has two fields, pkg_num, which is a number, and del_date_time, which is a date-time. The table can contain duplicate...

Rich_A2B

03-30-2005 05:10 PM
resprog2

Hi EveryBody, Here is a very interesting SQL which I failed to solve. I have two tables called Main and Notes.Table notes has id field which...

Kaushik

03-24-2005 04:08 PM
Hugo Kornelis

I can not get this query to work right it returns the records for the dates 03/19/2005 and 03/20/2005 but not 03/21/2005. Could this have any thing...

JrSnyper

03-23-2005 05:37 PM
JrSnyper

I'm having problems with the performance of a 16-bit exe called via xp_commandshell .. basically it's taking 100% of the processor time, however when...

ChrisL

03-23-2005 08:51 AM
ChrisL

Hi, I have a query that returns a detailed resultset but I need to create a summary of it as follows: ResultSet of...

Jig Bhakta

03-22-2005 02:42 PM
Hugo Kornelis

I have the following syntax Sum(+++++++++++) AS YrSales This works fine if none of the fields are NULL How can I cater for the scenario where...

Ali

03-22-2005 10:29 AM
Ali

hi, How to get last (maximum) date of a month through sql query. ex: if 31st is the last date of a month then i should get 31(dd) or...

Hari

03-22-2005 01:26 AM
Dejan Sarka

Is it possible to do this all in one stored procedure? I have 3 separate queries which returns all the correct records with Stockcode being the...

Newbie

03-18-2005 07:21 AM
Newbie

Hi Gurus, Is there any automated way to compare the contents of TWO rows in the same table of SQL Server ? Thanks in advance. Regards, Yog

Yog

03-18-2005 04:18 AM
Hugo Kornelis

Hi, I want to return records based on a linetype and classtype Here is what I have so far Where (LineType = '1' OR LineType = '7') or (LineType =...

Newbie

03-17-2005 10:53 AM
Newbie

I have a question that I haven't been able to find an answer to in either the help files or Technet/MSDN searches. First a little background. I have...

Stingray

03-16-2005 04:58 PM
Hugo Kornelis

I know the sql is incorrect on this but was wondering if something like this was possible: select * from ( exec storedProc1 'value1' ) a -- will

we7313

03-16-2005 04:27 PM
Stingray