We are using SQL Server 2000. I have already learned that there is no MEDIAN, or MODE function to go along with the AVE... I've also found several...

HumanJHawkins

04-28-2008 11:55 AM
HumanJHawkins

Env: MS SQL Server 2005 developer edition on Windows XP Pro I have a fairly complex query that create a 'variable TABLE' and then, run a set of...

DL

04-26-2008 06:11 PM
DL

I have the following CASE statement in a view: (SELECT CASE WHEN ISNULL(.., NULL) = NULL THEN .(..) ELSE .(..) + ', ' + .. END) AS...

sbowman@comcast.net

04-26-2008 12:44 PM
Plamen Ratchev

I have a UDF that cleans a field of control characters and I use it like this select dbo.udf_CleanAlphaNum(Address1) as Address1 from Leads It...

rcamarda

04-25-2008 10:04 PM
rcamarda

SQL Server 2005 Simple scenario - We want to store answers to survey questions. Some questions require very short responses (one or two words) while...

Bill E.

04-25-2008 09:57 AM
Bill E.

Actually you can save the output from DBCC INPUTBUFFER to a table. Of course, since a trigger is invoked only on INSERT/UPDATE/DELETE you...

Plamen Ratchev

04-25-2008 07:59 AM
Plamen Ratchev

To be found at http://shark.armchair.mb.ca/~erwin

sira_prise

04-24-2008 09:29 PM
Ed Murphy

We have a db that is accessed by users on the web 24/7. Problem is when our maintenace job runs users are getting killed with this error: Database...

esource

04-24-2008 06:16 PM
Hugo Kornelis

Hi there, i need some help I got a software to backend is MSSQL 2005, but a provider software requires an UPDATE on his table with MySQL 5.0.56a...

Gosth in the shell

04-24-2008 05:10 PM
Gosth in the shell

Hello I accidentaly ran a DELETE command against a table with a wrong WHERE clause. My database had no backup, but the recovery model was Full. I am...

nano2k

04-24-2008 09:33 AM
Hugo Kornelis

Hi all, I need to export a table from Ms Sql to Access. However, dts import/ export gives me an error because the field names are too long. Is there...

myemail.an@googlemail.com

04-23-2008 09:48 PM
sam@invalidpage.com

Hello guys, i have this query: select c8.cerveh, sum(c8.monto1) monto1, (select prima from arysauto a where...

Seguros Catatumbo

04-23-2008 09:14 PM
Plamen Ratchev

Is there a convient way to do a supertype/subtype heirarchy in mysql and do queries on the supertype to return sets of subtypes? For example,...

nflacco

04-23-2008 07:38 PM
nflacco

I have just started learning SQL. I would like to write a program that crawls the hard drive and collects file names (with full path), size of files...

Ali

04-23-2008 07:03 PM
Ali

A lot of sql users have a hard time reconciling the idea that a table is by definition an unordered set and the ordering involved in the sql server...

steve

04-23-2008 05:55 PM
steve

how do i write sql statment to find records with name greater than 17 characters.

ciojr@yahoo.com

04-23-2008 11:46 AM
Gert-Jan Strik

I've searched the forum for uses of CHECKSUM and havent found a satisfactory answer. I need to know when a row changes and I dont care what it was or...

rcamarda

04-23-2008 11:42 AM
Gert-Jan Strik

how do i write a sql (ORACLE) statement for where the first word in the name field is greater than 17 chars? if i do this SELECT businessname FROM...

ciojr@yahoo.com

04-23-2008 08:22 AM
Plamen Ratchev

Hi, we've got this problem with some particular jobs: they look as they ran correctly, but actually they didn't made it all through their duties. The...

Daniele Tiles

04-23-2008 02:39 AM
Daniele Tiles

When inserting a record into a table, I want SQL Server to generate a number automatically for the Primary Key. (e.g. OrderID is 1, 2, 3 and so on)...

DanielLauJJ@gmail.com

04-23-2008 02:29 AM
Ivan Delic

I have the following statement that is intended to provide the most records with the most recent status from the SAF2 table, based...

t8ntboy

04-22-2008 09:22 PM
Plamen Ratchev

I cannot figure out why this is not working. For some reason the following statement is yielding multiple records with the same CESAFID eventhough...

t8ntboy

04-22-2008 10:26 AM
Iain Sharp

We have set up a couple of SQL Server 2005 systems and I have found that the format of the ERRORLOG files and the SQL Agent's log files are Unicode...

Teresa Masino

04-21-2008 05:31 PM
rcamarda

Hi , i want to select the first minimum date in the column d for each distinct column a value. how i can do that in a sql query. xyztable Column a...

rajesh

04-21-2008 01:46 PM
Plamen Ratchev

Hello there, I was wondering if anyone knew how to run a query that supplies the sql statement behind a view? or is there a way to do that with...

John Sheppard

04-20-2008 09:24 PM
John Sheppard

This should be simple, but I can't work it out without cursors. I have a table with quantity field. I want to get all first rows whose sum of...

Mario Blataric

04-20-2008 04:37 AM
Mario Blataric

Hi, I've got a many-many relationship between people and locations: Persons {personid, namefirst, accountid} Locations {locationid, locationname,...

d-42

04-18-2008 05:52 PM
d-42

Hi, I'm a newbie in sql server. I want to create a primary key that should be auto incremented. for example: C0001, C0002, C0003, C0004 etc here...

aliakhthar@gmail.com

04-18-2008 12:48 PM
Jimbo

Hello Group I having problems creating a result set. The challenge is I have 3 tables: A customer table, A charge table and a payment table........

markgordon_007@yahoo.com

04-18-2008 09:08 AM
Ed Murphy

Hi I'm sure lots of people have asked this before, but I can't find any threads so: Assuming you haven't had your profiler open for long enough is...

codefragment@googlemail.com

04-18-2008 05:56 AM
codefragment@googlemail.com

Hi, I'm having serious issues with our user defined functions. They get very slow after a while. The functions I use have several IF-branches which...

René

04-17-2008 09:08 PM
Tom van Stiphout

SQL Server 2005 SP2 I know that, for OLTP, the rule of thumb for LOGS is around 25% of database size. What is the rule of thumb for TEMP size? I...

aj

04-17-2008 04:44 PM
VIPS

Hi, Any pointers much appreciated- I just don't know how to progress from here. Using MS SQL server on a shared host (www.joglab.com shows...

DanWeaver

04-16-2008 05:42 PM
DanWeaver

Hello all, I have SQL Server Mgmt Studio and would like to know how to shut off the auto updates that occur when you leave a modified row in the...

maloney1

04-16-2008 05:06 PM
maloney1

Is there an easy way to create a SQL script to re-create and re- populate a table? Both Enterprise Manager 8.0 and Management Studio Express 2005...

D.Stone@ed.ac.uk

04-16-2008 03:05 PM
Pasi Oja-Nisula

Is there a way to grant permissions on an object in one database to a user from another database in SQL Server 2000?

Jimbo

04-16-2008 01:32 PM
Jimbo

Is there any difference between explicit inner join and implicit inner join Example of an explicit inner join: SELECT * FROM employee INNER JOIN...

YZXIA

04-16-2008 12:11 PM
Shuurai

hi i have a table with an XML column this XML data looks like this <details><attribute id="1" value="x"/><attribute id="2" value="y"/ could...

zzzxtreme@gmail.com

04-16-2008 09:28 AM
Plamen Ratchev

I apologize if this has been covered ad nauseum, but I didn't see it in my search. Basically, in an nvarchar(150) column (called "Phrase" in the...

rowe_newsgroups

04-16-2008 06:12 AM
rowe_newsgroups

Hello, I have a DB table with data filled from a weather sensor probe, I have one row every 10 minutes and the data fields is not in DateTime format...

maury

04-16-2008 06:06 AM
maury

Hello SQL-experts, I have a table with a datetime field, 'accesstime'. The table also holds a varchar column, 'IPaddress". I now need to select all...

Morten

04-16-2008 04:14 AM
Morten

Hi List, I am searching franticly for a solution (or the procedure) to setting the coding of a new DB to UTF-8. I can find no setting in the...

Shawn Beasley

04-15-2008 09:47 AM
raymond.mancy@gmail.com

hello i am learning how to write stored procedures in sql server, i would like to know what's wrong with the following statement? please help the...

philip

04-15-2008 08:50 AM
Plamen Ratchev

I have an application that needs to import a DLL file for some database call like - #import "c:\Program Files\Common Files\System\ADO\msado15.dll"...

Jim Johnson

04-15-2008 08:08 AM
Morten

I found this quite interesting. However, it seems to assume I have a schema defined in an xsd or xdr file. I get a data feed that appears to be...

Ted

04-14-2008 10:31 PM
Tom van Stiphout

SQL Server 2005 SP2 2005.090.3054.00 I'm trying to move master/model/msdb to a new spot. I restart SQL Server in single user mode with the...

aj

04-14-2008 04:51 PM
aj

I have beginner knowledge of SQL (I use MS SQL Server). I recently finished "SQL for dummies" book and now need something more advanced with a lot...

vmnvmcxbv

04-14-2008 09:24 AM
--CELKO--

Hi folks, Go and get a copy of Secure Auditor which is a unified digital risk management solution and provides 30 tools in 1 package. It...

ALEAALDOUS@googlemail.com

04-14-2008 02:09 AM
ALEAALDOUS@googlemail.com

Hi folks, Go and get a copy of Secure Auditor which is a unified digital risk management solution and provides 30 tools in 1 package. It...

ALEAALDOUS@googlemail.com

04-14-2008 02:08 AM
ALEAALDOUS@googlemail.com

I am trying to obtain some data and I have a way to do it however it appears really longwinded and I'm sure there must be a better way to get this...

shannonwhitty@hotmail.com

04-13-2008 08:56 PM
shannonwhitty@hotmail.com