comp.databases.ms-sqlserver

How can I combine different rows?

Started on 03 Juli 2007 22:53
Last reply by Joe Celko on 06 Juli 2007 03:14
[ Posts: 2 ] [ Views: 183 ]

Converting continuous replication to hourly?

Started on 05 Juli 2007 22:54
Last reply by M Bourgon on 05 Juli 2007 22:54
[ Posts: 0 ] [ Views: 179 ]

Error 0xc02020a1: Data Flow Task: Data conversion failed

Started on 05 Juli 2007 16:20
Last reply by Sharif Islam on 05 Juli 2007 16:54
[ Posts: 2 ] [ Views: 11381 ]

Cannot connect to database using Enterprise Manager

Started on 04 Juli 2007 20:53
Last reply by Erland Sommarskog on 04 Juli 2007 23:19
[ Posts: 1 ] [ Views: 335 ]

MS SQL getDate() Function remove Time

Started on 04 Juli 2007 16:53
Last reply by Roy Harvey on 04 Juli 2007 19:01
[ Posts: 4 ] [ Views: 6160 ]

No mapping between account name and security ID

Started on 02 Juli 2007 17:57
Last reply by Nayaz on 04 Juli 2007 18:50
[ Posts: 1 ] [ Views: 301 ]

Find website from email address

Started on 04 Juli 2007 16:27
Last reply by Mintyman on 04 Juli 2007 18:05
[ Posts: 3 ] [ Views: 205 ]

pwdcompare equivalent in Sql2005

Started on 03 Juli 2007 17:47
Last reply by David Portas on 04 Juli 2007 11:59
[ Posts: 1 ] [ Views: 627 ]

Yellowfin Business Intelligence 3.2 released

Started on 03 Juli 2007 15:32
Last reply by YellowFin on 03 Juli 2007 15:32
[ Posts: 0 ] [ Views: 202 ]

[SQL Server 2005] T-SQL for configuring replication

Started on 03 Juli 2007 15:02
Last reply by Thyagu on 03 Juli 2007 15:02
[ Posts: 0 ] [ Views: 185 ]

How to use function based index in SQL Server2005?

Started on 03 Juli 2007 08:05
Last reply by Plamen Ratchev on 03 Juli 2007 14:25
[ Posts: 1 ] [ Views: 234 ]

Reporting Services

Started on 03 Juli 2007 10:26
Last reply by Laurence Breeze on 03 Juli 2007 10:26
[ Posts: 0 ] [ Views: 195 ]

OLTP vs OLAP (Data Warehouse) as a DataSource in Analysis Services 2005

Started on 03 Juli 2007 10:01
Last reply by russzee on 03 Juli 2007 10:09
[ Posts: 1 ] [ Views: 205 ]

Dynamic Query

Started on 03 Juli 2007 00:00
Last reply by Erland Sommarskog on 03 Juli 2007 10:07
[ Posts: 3 ] [ Views: 439 ]

Combining Values

Started on 30 Juni 2007 01:03
Last reply by Erland Sommarskog on 03 Juli 2007 00:00
[ Posts: 8 ] [ Views: 196 ]

Performance between Standard Join and Inner Join

Started on 28 Juni 2007 07:04
Last reply by Erland Sommarskog on 02 Juli 2007 23:45
[ Posts: 15 ] [ Views: 237 ]

SQL Query question

Started on 02 Juli 2007 19:15
Last reply by Erland Sommarskog on 02 Juli 2007 23:37
[ Posts: 2 ] [ Views: 189 ]

SQL 2005 error: Replication-Replication Distribution Subsystem: agent (null) failed.

Started on 14 Juni 2007 23:52
Last reply by M Bourgon on 02 Juli 2007 17:46
[ Posts: 3 ] [ Views: 206 ]

Select with serial number column

Started on 02 Juli 2007 10:37
Last reply by Oonz on 02 Juli 2007 11:35
[ Posts: 2 ] [ Views: 315 ]

Output Column names in each Row along with the row Value

Started on 29 Juni 2007 12:09
Last reply by Yas on 01 Juli 2007 12:52
[ Posts: 4 ] [ Views: 208 ]

Need Scheduling Support for Your Databases?

Started on 01 Juli 2007 00:05
Last reply by carl on 01 Juli 2007 00:05
[ Posts: 0 ] [ Views: 135 ]

Mismatch between Count(*) and Properties -> Rows

Started on 29 Juni 2007 16:28
Last reply by Roy Harvey on 30 Juni 2007 04:10
[ Posts: 3 ] [ Views: 126 ]

Connecting to SQL 2005 using VB6

Started on 29 Juni 2007 17:06
Last reply by Erland Sommarskog on 29 Juni 2007 23:36
[ Posts: 1 ] [ Views: 224 ]

Mass Update on Table with Trigger

Started on 29 Juni 2007 22:20
Last reply by Erland Sommarskog on 29 Juni 2007 23:29
[ Posts: 2 ] [ Views: 510 ]

XML INTO SQL

Started on 28 Juni 2007 16:44
Last reply by Erland Sommarskog on 29 Juni 2007 23:27
[ Posts: 3 ] [ Views: 449 ]

question about a query

Started on 28 Juni 2007 21:44
Last reply by nina297 on 29 Juni 2007 15:00
[ Posts: 3 ] [ Views: 216 ]

Scope in derived tables

Started on 29 Juni 2007 13:09
Last reply by Erland Sommarskog on 29 Juni 2007 13:13
[ Posts: 1 ] [ Views: 240 ]

problem in date comparison

Started on 26 Juni 2007 12:42
Last reply by navneetkasulkar on 29 Juni 2007 11:04
[ Posts: 5 ] [ Views: 201 ]

problem about comparing date

Started on 26 Juni 2007 12:34
Last reply by navneetkasulkar on 29 Juni 2007 11:00
[ Posts: 2 ] [ Views: 176 ]

SELECT QUESTION

Started on 28 Juni 2007 02:27
Last reply by Erland Sommarskog on 28 Juni 2007 23:31
[ Posts: 1 ] [ Views: 228 ]

Strange performance issue with UPDATE FROM

Started on 26 Juni 2007 17:31
Last reply by Alex Kuznetsov on 28 Juni 2007 23:12
[ Posts: 10 ] [ Views: 203 ]

Is Not Null and Query Optimization

Started on 28 Juni 2007 18:22
Last reply by Erland Sommarskog on 28 Juni 2007 22:35
[ Posts: 3 ] [ Views: 185 ]

Forcing an IDENTITY column to have a certain value

Started on 27 Juni 2007 22:11
Last reply by Gert-Jan Strik on 28 Juni 2007 21:31
[ Posts: 3 ] [ Views: 420 ]

How to make a SQL run longer?

Started on 27 Juni 2007 20:16
Last reply by raj on 28 Juni 2007 00:30
[ Posts: 8 ] [ Views: 378 ]

How to reliably ensure that only one set of rows is bulk imported into a table at a time

Started on 27 Juni 2007 21:27
Last reply by Erland Sommarskog on 27 Juni 2007 23:28
[ Posts: 5 ] [ Views: 401 ]

How to find the maximum possible value of a given datatype

Started on 27 Juni 2007 03:39
Last reply by Gert-Jan Strik on 27 Juni 2007 20:26
[ Posts: 6 ] [ Views: 228 ]

Parse field into multiple rows

Started on 27 Juni 2007 13:22
Last reply by Plamen Ratchev on 27 Juni 2007 19:30
[ Posts: 3 ] [ Views: 293 ]

sum columns into column in same table

Started on 26 Juni 2007 22:33
Last reply by azriley on 27 Juni 2007 19:09
[ Posts: 4 ] [ Views: 216 ]

mass alter table fields - script help

Started on 27 Juni 2007 14:30
Last reply by rcamarda on 27 Juni 2007 17:25
[ Posts: 2 ] [ Views: 225 ]

Free client

Started on 26 Juni 2007 23:13
Last reply by Erland Sommarskog on 27 Juni 2007 14:07
[ Posts: 1 ] [ Views: 211 ]