Hi Friends, How to transpose the columns into rows i want to convert the table which looks like this ID Name HomePhone WorkPhone Email 1 test1 ...

Oonz

05-29-2007 08:37 AM
Plamen Ratchev

SQL Monitor version 2.0 has just been released. http://dbmonitor.tripod.com SQL Monitor is an application that displays performance statistics...

DBMonitor

05-29-2007 06:39 AM
DBMonitor

Hi all, I have recently changed IP addresses on my MS SQL cluster (the new IP addresses belongs to a different network). Both physical node's...

aleu@vp.pl

05-29-2007 02:57 AM
John Bell

I am trying to write an application for a MSSQL database, using SQL Express, and Visual Studio (Express edition) I tried to connect to an existing...

Shane

05-29-2007 12:51 AM
Mandy

Hi All, I wanted the expert opinion out there in the use of foreign keys as primary keys in a table. I am not very good at explaining this concept,...

KR

05-27-2007 09:17 AM
--CELKO--

I have a strange problem that I think deals with security on SQL 2005. I have a scheduled task that runs on a Windows 2000 machine. It calls a vb...

Myster Edd

05-27-2007 04:56 AM
John Bell

I have a question about the "readCommitted" transaction isolation level. I have a client that is updating a record on a table. I suspend the...

D.

05-26-2007 06:29 AM
Robert Klemme

I have a directory of files that I would like to upload with some data to a table so that I can store the files in the db. I'm not trying to parse...

M@

05-25-2007 06:00 PM
Erland Sommarskog

I have about 14 tables that I am trying to tie together in a view to see a user's status in our company. Joe User: Email - Active ADP -...

M@

05-25-2007 11:48 AM
M@

I'm trying to create a function that splits up a column by spaces, and I thought creating a function that finds the spaces with CHARINDEX and then...

jknaty

05-25-2007 09:42 AM
jknaty

Hi all! We are a little group of databases developers, we use SQL Server and we manage our source code with CVS. Actually, with enterprise manager...

pipponec@libero.it

05-24-2007 05:54 PM
Erland Sommarskog

Welcome, how can I alter following table in order to reduce neighbouring duplicates (symbol, position, quantity, price). Nr Symbol Position ...

mGracz

05-24-2007 05:50 PM
Erland Sommarskog

Hi all, I've a query running under MS SQLServer2000 (Stored Procedures). I'd like to send it's result via e-mail, formatting the output in txt...

Marco Garutti

05-24-2007 03:31 PM
Jennifer

Monte Tiernan wrote:

Ed Murphy

05-24-2007 12:06 PM
Ed Murphy

Hi all... I've got a group of tables and I wanted to first see which tables contained a fields containing the "Date/Time" data type. And I...

Mohd Al Junaibi

05-23-2007 06:10 PM
Erland Sommarskog

Hi, Please see the below procedure. create procedure a1 as begin

meendar

05-23-2007 03:29 PM
Ed Murphy

Excellent material is available on MCSD examination for SQL Server 2000 (070-229) and Developing Windows Based Applications with Visual Basic.Net...

Marven

05-23-2007 06:55 AM
Marven

Hello I have questions about how works transaction log et the database tempdb in SQL Server and I hop you could help me - Is it possible to reduce...

Kurt

05-23-2007 03:47 AM
Erland Sommarskog

Hi friends, please help me in selecting values from the table the record is as follows: Id HomePhone WorkPhone Mobile Email 20 2323223 ...

Oonz

05-23-2007 03:35 AM
Erland Sommarskog

Hello every body, I need some clarification of concept regarding self referential tables. consider we have a "Person" table that stores data about...

aakbar@gmail.com

05-23-2007 01:24 AM
Ed Murphy

Hi to all, I just need to get two fields from a table and manipulate the results in next query of a procedure.I planned to code like what you...

meendar

05-22-2007 10:21 PM
Dan Guzman

A UNION ALL query will combine multiple result sets: SELECT * FROM dbo.transaction_0701 UNION ALL SELECT * FROM dbo.transaction_0702 UNION...

Dan Guzman

05-22-2007 06:04 PM
Erland Sommarskog

Dear friends, I am looking for step by step Process involved in installing Sql server 6.5 Enterprise Edition on Windows NT4.0 Enterprise...

Navshad Ali

05-22-2007 04:19 PM
Navshad Ali

Hi I would like to introduce www.sqltree.com website to our group members. This is exclusively for SQL beginners, students & learners. It has huge...

sqltree@gmail.com

05-22-2007 03:28 PM
sqltree@gmail.com

I have a strange problem that I think deals with security on SQL 2005. I have a scheduled task that runs on a Windows 2000 machine. It calls a vb...

Myster Edd

05-22-2007 02:19 PM
Myster Edd

Dear friends, I am looking for step by step Process involved in installing Sql server 6.5 Enterprise Edition on Windows NT4.0 Enterprise...

Navshad Ali

05-22-2007 02:07 PM
Navshad Ali

Hello I have questions about how works transaction log et the database tempdb in SQL Server and I hop you could help me - Is it possible to reduce...

Kurt

05-22-2007 12:10 PM
Kurt

Hello, I have questions about SQL Server and I hope you could help me a lot. - Is it possible to reduce the size of my transaction log file...

Kurt

05-22-2007 12:05 PM
Kurt

Hello, I have questions about SQL Server and I hope you could help me a lot. - Is it possible to reduce the size of my transaction log file...

Kurt

05-22-2007 12:01 PM
Kurt

Hello, I have questions about SQL Server and I hope you could help me a lot. - Is it possible to reduce the size of my transaction log file...

Kurt

05-22-2007 11:58 AM
Kurt

Dear friends, I am looking for step by step Process involved in installing Sql server 6.5 Enterprise Edition on Windows NT4.0 Enterprise...

Navshad Ali

05-22-2007 10:57 AM
Erland Sommarskog

Dear friends, I am looking for step by step Process involved in installing Sql server 6.5 Enterprise Edition on Windows NT4.0 Enterprise...

Navshad Ali

05-22-2007 10:36 AM
Navshad Ali

Hello, I have questions about SQL Server and I hope you could help me a lot. - Is it possible to reduce the size of my transaction log file...

Kurt

05-22-2007 10:10 AM
Kurt

Hello I have questions about how works transaction log et the database tempdb in SQL Server and I hop you could help me - Is it possible to reduce...

Kurt

05-22-2007 09:42 AM
Kurt

I have a client with 150MB database, the transaction log file is nearly 23GB. It's a PITA for me to backup his data and restore it on my server as it...

Trevor Best

05-22-2007 08:32 AM
barlowedward@hotmail.com

i am using sql server 2005 and want to access the olap service which is installed on the server side but i want to access on client side. means to...

Mandy

05-22-2007 08:13 AM
Mandy

i am using sql server 2005 and want to access the olap service which is installed on the server side but i want to access on client side. means to...

Mandy

05-22-2007 07:46 AM
Mandy

i am using sql server 2005 and want to access the olap service which is installed on the server side but i want to access on client side. means to...

Mandy

05-22-2007 07:44 AM
Mandy

Does sql server have a way to handle errors in a sproc which would allow one to insert rows, ignoring rows which would create a duplicate...

nano

05-21-2007 11:25 PM
nano

Dear comp.databases.ms-sqlserver, Stylus Studio 2007 Release 2, is now available for free trial download or online purchase. Here are some of...

Stylus Studio

05-21-2007 03:25 PM
Stylus Studio

Hi all... Can anyone give clue in doing below? Let say i have a table A with the following 3 fields. 1)Date 2)Title 3)Status. i need to insert...

albertleng

05-21-2007 11:28 AM
Ed Murphy

NAJH (neilonusenet (AT) yahoo (DOT) co.uk) writes: If you are on SQL 2000, yes. SQL Server MVP Anith Sen covers the various methods on...

Erland Sommarskog

05-20-2007 10:27 PM
Ed Murphy

http://www.occ.treas.gov/jobs/DEU-HQ-07-073.htm

ezduffy@gmail.com

05-20-2007 09:21 PM
ezduffy@gmail.com

is there a way using sqlexpress to review the most recent set of sql commands submitted to a database? I remember something about setting up logging...

Jeff Kish

05-20-2007 06:50 PM
Jeff Kish

I have been instructed to write a trigger that effectively acts as a foreign key. The point (I think) is to get me used to writing triggers that...

Shane

05-20-2007 06:36 PM
Erland Sommarskog

What is the easiest way to move SQL Server 2005 databases from one old server to a new server?

bob66k88@gmail.com

05-19-2007 05:04 PM
Erland Sommarskog

Would you like to have access video tutorials totally free? Enter right now in www.mrbool.com and get to know our content on net totally for...

Jeff

05-18-2007 09:38 AM
Jeff

Hello everyone. I have got a simple question, but very important for me. I making a quite big report and I have a lot of conditions to compare. And I...

marianowic

05-18-2007 07:49 AM
Dan Guzman

Just wondering, which server hardware do you guys use for SQL Servers - we use Dell, curious to know what you are using - John Adams

John.Adams111@gmail.com

05-18-2007 06:28 AM
Dan Guzman

Our company in Toronto has been looking for hiring experienced Microsoft SQL server 2005 DBA's (Full time & contract) without any luck so for. Hoping...

jobs@bizarrays.com

05-18-2007 02:00 AM
jobs@bizarrays.com