Hi, i have a model column and has all sort of names. E.g. Model names CRUZERCROSSFIRE00512 EXTREME512MBCF EXTREMECF00256 EXTREMEIIISECUREDIGITAL

Tiffany

11-12-2006 02:35 PM
Hugo Kornelis

Is there an easy way to set a default value for values in unmatched rows that return null I wouldlike to return 0 for fields that return null in a...

Nathan

11-08-2006 12:34 AM
Arnie Rowland

Is it possible to create a query that returns a count of each application_request_detail_status_type_id as columns? Any help on this would be...

No Donut For Me

11-05-2006 11:42 PM
No Donut For Me via SQLMonster.com

hi, Have a problem and hope someone can help. I have a column which consists of numbers such as 123 235 456 888 etc

Tiffany

10-28-2006 05:19 PM
Hugo Kornelis

I have a table of doctors, each doctor is assigned a unique identifier, but may have mulitple offices in diff cities with differnent id numbers. ...

Brian L

10-25-2006 05:30 PM
Arnie Rowland

Problem: I only get one record of before and after data when performing multirow updates from a single update statement. I want to get before...

Ymerejtrebor

10-20-2006 06:43 PM
Arnie Rowland

Hello All I have two Table Employee and Dept Employee Columns EmpID EmpName MgrID DeptID

Sekhar

10-10-2006 01:15 PM
Kent Tegels

Hello All I have two Table Employee and Dept Employee Columns EmpID EmpName MgrID DeptID

Sekhar

10-10-2006 01:02 PM
Sekhar

I am trying to run a report. The requestor has specifics on the way it should be formatted on output. I'm going to try and explain what...

madgame

10-08-2006 09:14 PM
madgame

Hi, I haven't figure out why the store procedure execute withour error, but the data doesn't on the table. I have a store procedure which is call...

BMW

10-06-2006 06:11 PM
Arnie Rowland

What does SQL 2005 do that makes Microsoft feel that we don't need English Query anymore? (PS: I'm already aware that if you upgrade an existing...

jp

09-29-2006 04:32 PM
Hugo Kornelis

Hi. I am trying to clean up some data and I need to seperate out some values, I have a table that looks something like this. EmploymentID ...

Phil

09-26-2006 02:17 PM
Arnie Rowland

hi all, i want a sql stmt for displaying the total records in a table having the multiple copies of a particular field say email . so i want to...

gopi srinivas

09-19-2006 10:09 PM
Steve Kass

I have those Tables: CREATE TABLE GameYellows( id INT NOT NULL AUTO_INCREMENT, AddedDate DATETIME NOT NULL, Player_ID INT NOT NULL,

Yaniv Danan

09-04-2006 05:45 PM
Hugo Kornelis

Hi How can i execute a piece of sqlstmt which is stored in a string variable from query analyser. for ex:@var1="select name,code from" +...

shif

08-27-2006 03:14 PM
Hugo Kornelis

Hello All, I have a table called invoicedetail with the following fields: companyname address booth number booth space In this table a company name...

Bkana

08-24-2006 03:45 PM
Hugo Kornelis

Hi all, I am developing an English Query module as part of a web-based system. I am using ASP code from the MSEQ sample that comes with SQL Server...

Waqq

08-24-2006 07:18 AM
Waqq

Dear all, i've one table (A) which has one field with uniqure phone number recrods, and there is another table (B) which includes misc. numbers plus...

murtaza

08-23-2006 11:51 AM
murtaza

Hello, I'm looking at trying to schedule jobs in SQL that will run a query on a database, dump the results to a file (preferably CSV) and email that...

Jeff

08-22-2006 09:06 AM
Jeff

I'm having trouble deleting duplicates from enterprise manager. I get "Key column information is insufficient or incorrect. Too many rows were...

carl

08-21-2006 07:39 PM
lvhaiyan lvhaiyan

I'm working on a mailing list and want to select records where the both the SSN number and Address fields are unique, since I may want to send a...

archuleta37

08-17-2006 01:46 PM
Arnie Rowland

Any suggestions and/or supporting documentation for best practices on where to locate the full text catalog files. Especially as related to other...

tduffy77 via SQLMonster.com

08-16-2006 01:09 AM
Arnie Rowland

Hi, Hope someone can help with something so silly and that I feel quite ashamed about asking, I am just doing some simple percentage calcualtions...

Phil

07-26-2006 10:40 AM
Arnie Rowland

Hi, Wonder if someone can help me I have written a very very basic sql (NOT IN) Statment which was returning results fine but is not longer. The...

Phil

07-24-2006 04:38 PM
Phil

Hi, After installing SQL SERVER 2005 on Windows 2003 SP1 the DHCP server fails to start. I ve searched the google and other sites in the net but...

Thomas Dais

07-24-2006 01:30 PM
Thomas Dais

I added a field to the middle of an existing query. Another query that referenced the changed query had data in the wrong columns. For example, the...

JerryWendell

07-24-2006 10:20 AM
Arnie Rowland

I need to query between todays date +14. Any suggestions on code. Thanks.

Samson

07-23-2006 09:29 AM
Hugo Kornelis

Hi, How do you write a sql statement to update a column to be of <null>? What is the syntax? If have tried "null" and \0 thanks

panda

07-06-2006 07:25 PM
Arnie Rowland

I found a bug about SQL Query Analysis, if u write a sql statement like this: SELECT Tmptable.col1 table.col2 FROM TEMPDB.. AS Tmptable LEFT JOIN...

Lorry Astra

07-04-2006 01:43 AM
David Portas

I'm getting this error when I'm running dbcc shrinkfile. I have done it before and the file I'm using is DEFINITELY the name of the transaction...

ER

07-03-2006 01:24 PM
ER

Is it possible to execute two stored procedures and create one table based on the data in both of the SPs? If so, can someone explain how? Thanks

lucotc

07-03-2006 07:33 AM
lucotc

Hi, I've got something, but I can't get all of my columns shown. I've got a table with a few columns and in one columns there are records with...

Philippe

07-03-2006 03:23 AM
Philippe

I installed a new MSSQL2K SP4 over Win2K3 Svr SP1, and when I exec an English Query without 'Begin Distributed Transaction' and ' Commit...

Fernando

06-30-2006 09:41 PM
Fernando

Hi i am using sql 2000 . i am searching all the records into the database, for this i have used the 'Like %' in my query ..For Example Select * from...

Nishant Giri

06-26-2006 09:49 AM
Arnie Rowland

Hi, I keep getting this error whenever I try to describe any of the entities in my database using their given name: Missing name type for name...

AT

06-26-2006 08:09 AM
AT

Hi, I received a csv file which has a date column. The date format in this column is 6-Mar (6 stands for 2006 which means Mar 2006). I will import...

Tiffany

06-25-2006 06:05 AM
Hugo Kornelis

I have two tables each with concatenated key - ContractNo, SerialNo, JobNo, PNo I would like to find out missing records in the other table,...

Me

06-19-2006 06:32 PM
Arnie Rowland

Hi Without using export data method in enterprice manager how can i pump data from one database to another database.can anybody help with any...

shif

06-19-2006 09:37 AM
shif

Is there anyway to query out the special character ' i.e. foot. We have a table in a database that has data in it containing the foot and...

dtatham

06-16-2006 07:58 PM
Arnie Rowland

I need some assistance, i have this Stored Procedure that will take my table and create a cross tab. Unfor, I am getting duplicate value from the...

Justin

06-12-2006 12:04 PM
Justin

I'm using sql 2000 and Access 2003. I trying to query on a date field. I need to display any records from the current date and greater then. What...

pjscott

06-06-2006 04:28 PM
Hugo Kornelis

I have created a user role in my SQL 7 database. I would like to copy this role to 8 other servers. I created the role using Enterprise Manager. ...

dtatham

05-24-2006 04:31 PM
dtatham

When I submit a sql : select * from view from column='' the view is pointing to oracle table with ole db provider for oracle In mssql2000, the...

stephanie

05-22-2006 05:35 PM
Hugo Kornelis

Table2 has multiple records joined to single record in Table1. I want to UPDATE column in Table1 only if all joined records in Table2 are True. Help...

EdwardH

05-14-2006 10:52 AM
David Portas

Hello everyone, I'm on MS SQL SERVER 2000. When runing this simple delete statement: delete from sd50.cdm_locations where loc_oid...

dondiego

05-08-2006 03:48 PM
dondiego

I would like to write a select statement in query analyzer which would return the last order number per customer given a specific order type. (Which...

chas2006

05-08-2006 03:13 PM
Hugo Kornelis

Hello! I have this transaction: BEGIN TRANSACTION INSERT INTO logs (message) VALUES ('SQL will inserts a new register')

Santiago Sanz

05-08-2006 03:06 PM
Hugo Kornelis

How does one update an Microsoft Access table from within Sql server. For example: If the sql table has three fields, field1, field2 and field3 and...

bhorwitz

04-29-2006 01:23 PM
bhorwitz

Hi there, In an effort to give you a clear idea of what I'm doing, I'm going to give you as much info as possible. Hopefully, this isn't...

dataGirl

04-26-2006 03:59 PM
dataGirl

How can a user use SQL Query while connected to one server and execute a query that pulls data from a database on another server. When we...

Steve Lowrance

04-21-2006 12:47 PM
Steve Lowrance