Hello all, I have a script which I'm hoping to use to accurately represent online schemas in XML. It works great for Oracle, and I'm trying to add...

amonotod@netscape.net

07-12-2007 02:16 PM
Roy Harvey

Okay - I've been reading through a ton of blogs, and every other one seems to have some neat, new-to-me tool that I've missed that I could really...

bourgon@gmail.com

07-12-2007 12:07 PM
Darrell61

I'm not sure if this is possible, and it's tough to search for via google, so... I have a user-defined function that checks whether a given column...

downwitch

07-12-2007 04:43 AM
Erland Sommarskog

Does Any one have a SQL server sample database atleast with 50 mb of data or can anyone give me a link with I could download it? Regards Sathish S N

sathish.sarod@gmail.com

07-11-2007 11:13 PM
Azhar

We are running SQL 7 with a front end that links to the tables through ODBC. In our main table, the user has no way to delete a record through...

Neil

07-11-2007 02:50 PM
Ajay Rengunthwar

Hi, all! The Criminal DB is going strong (as of today: 50 Tables, on 3077 Filegroups) Right now I stuffed in it about 2 million records (About 7%...

Piero 'Giops' Giorgi

07-11-2007 12:51 PM
Piero 'Giops' Giorgi

I have a table on sql server. It has three columns (1-Make) (2-Model) (3-Quantity Ordered). I'm simplifying this a bit. Sample data: Ford ...

eighthman11

07-11-2007 11:51 AM
Roy Harvey

Hello, I have a table called tbl_skill_scores user_id - primary skill - varchar score - int Each user has 6 entries in this table, one for each...

bonjella

07-11-2007 09:01 AM
bonjella

(ACP) Reporter Michael T Franks recently had the opportunity to talkwfin CEO Glen Rabie about Business Intelligence software, Web/BI 2, the BI...

YellowFin Announcements

07-11-2007 08:03 AM
YellowFin Announcements

Is there a way to define a key that puts the text 'SELECT * FROM ' into the Query Analyzer window? I must type this about 50 times a day but cannot...

Stagnight1

07-11-2007 07:03 AM
Andrew Morton

Under SQL 2000 I have a table that consists of a single column of text type, each record holds about 15-25,000 chars. This data happens to be an xml,...

Rod

07-10-2007 05:40 PM
Erland Sommarskog

First, I gotta tell you, I know almost nothing about SQL Server. I'm pretty good with Access, in my own way (not programming though) and that is...

JA

07-10-2007 04:59 PM
M Bourgon

This is a question to all of you running businesses out there - you can check out my ramblings about this on my blog...

xman

07-10-2007 04:38 PM
xman

I am setting up a SQL server to be the backend for a SharePoint Services 3.0 server. I"m allocating about 75 GB for the data files on one drive. How...

tlyczko

07-10-2007 10:20 AM
tlyczko

In the database i have a table with this information: key_id => 1 key_desc => 43+34+22+12 I want sum the values in key_desc. Something...

Apaxe

07-10-2007 08:45 AM
PDreyer

Dear All I am very new to MS SQL Server and I am wondering is there some tool which would allow me to build pivot tables in SQL more easily. At...

wujtehacjusz

07-10-2007 08:29 AM
Dan Guzman

I'm trying to send an email using master..xp_sendmail with parms and the default Outlook profile. I can successfully test the profile on my own...

Stephen2

07-10-2007 07:40 AM
Erland Sommarskog

I have a table with the following columns, NAME, TYPE, TAG And there may be 'duplicates' on name and type. How can I delete them?? I want to...

cobolman

07-10-2007 05:13 AM
Erland Sommarskog

Hi to all... I've a little trouble with a t-sql db... I've 2 tables int he db. On the child table i've a trigger that do some controls and...

Masterx81

07-09-2007 08:31 AM
Jason Lepack

How do you combine two SELECT statements from two different tables into one result (assuming bioth tables have the exact same fields)? Like,...

dwightarmyofchampions@hotmail.com

07-08-2007 10:04 AM
--CELKO--

Hello I'm a newbie to programming and need help writing an if statement. I have a database set up in SQL with the following fields: Category ...

JJ297

07-08-2007 10:00 AM
--CELKO--

I have a Stored Procedure that performs a simple SELECT. The Select have no locking hints or other hints and the database is set up in a standard...

bjornsuneandersen@gmail.com

07-06-2007 06:24 PM
Erland Sommarskog

On SSMS 9.00.3042.00, any query that runs longer than 10 minutes gets the following error message: The statement has been terminated. Msg -2, Level...

M Bourgon

07-06-2007 06:22 PM
Erland Sommarskog

Learn Oracle Database Administration in 10 Minutes. No kidding. Check it yourself, http://www.takveen.com Only good analogy makes complex concepts...

takveen@gmail.com

07-06-2007 06:17 PM
Erland Sommarskog

Recently I moved from Crystal reports to the Reporting Services module. In Crystal, I was able to use the TOP N function to report only the top 15...

Dan.Diasio@gmail.com

07-06-2007 10:32 AM
Dan.Diasio@gmail.com

Dear Experts, What is the best way to do a large insert WITHOUT having direct access to the machine SQL Server is running on? For example, imagine I...

Emin

07-06-2007 09:41 AM
Roy Harvey

I've got the following SELECT statement in a stored procedure: SELECT FirstName, LastName, BusinessName, MailingAddress1 FROM tblAddresses WHERE...

manning_news@hotmail.com

07-06-2007 09:25 AM
manning_news@hotmail.com

I've scoured Google searching for an answer that seems like it should be easy but apparently isn't...when I open SSMS to connect to a SQL...

Ben Hanson

07-06-2007 02:39 AM
Damien

Hi! I have a table looking like (username) (account number) (start date) (end date) (product) wich I can have up to 4 lines for the same...

hlajeunessse@gmail.com

07-05-2007 09:14 PM
--CELKO--

Short of scripting, dropping, rerunning-the-script and resynchronizing, is there any way to change continuous replication to a periodic replication? ...

M Bourgon

07-05-2007 04:54 PM
M Bourgon

I cannot seem to connect to this Instance locally which was i able to in the past. I can connect to the instance from out side. The instance is...

rubeel@gmail.com

07-04-2007 05:19 PM
Erland Sommarskog

Hi, I am creating creating a table with a Date column dd-mm-yyyy. But I cant seem to find a SQL function that just returns today's date. getDate()...

Yas

07-04-2007 01:01 PM
Roy Harvey

Hi, I created a user account on my active directory service. I then tried to assign a service located on my SQL server to be executed by...

Zero

07-04-2007 12:50 PM
Nayaz

Hi, I have 2 fields in a database: 'email' and 'website'. In the majority of cases, the website field is not populated even though the email...

Mintyman

07-04-2007 12:05 PM
Mintyman

Hi Friends, What is the equivalent function of pwdcompare() in Sql2005? Thanks, ArunDhaJ

ArunDhaJ

07-04-2007 05:59 AM
David Portas

3.2 is out! And it is awesome! The major theme of Release 3.2 is enhanced data visualisation and user interaction. We have not forgotten all the...

YellowFin Announcements

07-03-2007 09:32 AM
YellowFin Announcements

Hi, I want to script replication using T-SQL statements in SQL Server 2005. Could you please let me know if it is possible. If yes, please provide...

Thyagu

07-03-2007 09:02 AM
Thyagu

Don Burleson said in SQL Server2005, several new features are introduced include function based index.( Specialised index on a computed column (ala...

Steven

07-03-2007 08:25 AM
Plamen Ratchev

We're looking at using SQLServer Reporting Services for our general reporting requiremets. We have a mixed DBMS environment of which SQLServer is...

Laurence Breeze

07-03-2007 04:26 AM
Laurence Breeze

Hello, Can I import an OLTP (Reltional DB) as a Data Source into SQL Server Analysis Services 2005 and then use the Cube Wizard and the new...

russzee

07-03-2007 04:09 AM
russzee

Hi! I am trying to dynamically modify my pass-through query containing a procedure call with 2 parameters. When I run my access app, I get this...

Ben

07-03-2007 04:07 AM
Erland Sommarskog

I need to do something that goes against normalization, but it is what the client wants. Let's say one person has several addresses. I need to be...

imani_technology_spam@yahoo.com

07-02-2007 06:00 PM
Erland Sommarskog

Hello, everyone I have one question about the standard join and inner join, which one is faster and more reliable? Can you recommend me to use?...

Chamnap

07-02-2007 05:45 PM
Erland Sommarskog

I have an odd one for everyone and hopefully someone can help me. I have a process that selects from table 1 using a left join to Table 2. Table 2...

serwin@gmail.com

07-02-2007 05:37 PM
Erland Sommarskog

I'm getting this, after upgrading from 2000 to 2005. Replication-Replication Distribution Subsystem: agent (null) failed. The subscription to...

bourgon@gmail.com

07-02-2007 11:46 AM
bourgon@gmail.com

Learn, Read and Post C#, ASP.NET, JAVA, C/C++, PHP, LINUX, UNIX, WINDOWS VISTA Articles here and many more.... www.exposecode.com

Mussarat

07-02-2007 07:55 AM
Mussarat

Hi Friends, Help me in retrieving a table with a SNo column Select Name From SysObjects Where type = 'U' Order By Name asc the above query would...

ArunDhaJ

07-02-2007 05:35 AM
ArunDhaJ

Hello, I was wondering if anyone can help me figure something out. Is it possible to do a querey in MS SQL server and have the results returned so...

Yas

07-01-2007 06:52 AM
Yas

Greetings All, I'm working on a specification for an Enterprise-class Open Source batch scheduler, and I really would like some expert commentary...

carl

06-30-2007 06:05 PM
carl

I have a client who has reported a discrepancy in their database. In their test database a certain report returns 5,333 rows, but in the production...

teddysnips@hotmail.com

06-29-2007 10:10 PM
Roy Harvey