Answered SQL Server 2005 Questions

Sort by:

Date Title Author
05/21/12

Excel, tables,  and SQL connections

iamzeus
05/20/12

SQL Max Function

pauledwardian
05/20/12

update from one table to another

sevensnake77
05/20/12

ASK - how to create Insert sql statement given a record need to insert

tommym121
05/20/12

Database Backup Failure on Blackberry Enterprise Express

mercuriousu2
05/20/12

TSQL script to insert row and update a index

wilfordrocks
05/19/12

Sybase DATETIME to SSIS variable error

thomaszhwang
05/18/12

Displaying utilization effectively for each day over a specified period of time

britpopfan74
05/19/12

SQL - Create a SCHEMA or create another DATABASE

tommym121
05/21/12

TRY/THROW/CATCH in SQL Server Stored Procedure

axnst2
05/17/12

SQL - unable to get table name

tommym121
05/18/12

How to Query Distinct Values - Only Different

zberg007
05/18/12

Select += statement

lrbrister
05/17/12

Syntax of this SQL

Farzadw
05/18/12

using DB after log backup (w/ NORECOVERY )

25112
05/18/12

less of Datareader access and more of views

25112
05/17/12

SQL - can you use a variable for table name in the select statement

tommym121
05/17/12

Best way to handle divisor zero error messages

lrbrister
05/17/12

Separate WHERE clauses in the select line...

hpdvs2
05/17/12

Returning the ROWCOUNT of a SELECT statement

cdemott33
05/17/12

c# connecting to a sql server via connection string

sydneyguy
05/21/12

Slowly Changing Dimension

ac_davis2002
05/17/12

How to count nuber of views

ac_davis2002
05/17/12

SQL UDF to map source to target values (SYNTAX ERROR)

cipriano555
05/17/12

Join Queries

plucenko
05/17/12

With Statement from 2 selects

lrbrister
05/16/12

Problem on where clause

bibi92
05/18/12

how to delete all rows from a select?

hidrau
05/16/12

Mimic limit in sql

erikTsomik
05/16/12

Combine Two queries into One...

plucenko
05/18/12

How to use Aggregate Functions with Top Function

shah36
05/17/12

Selecting one row

Farzadw
05/19/12

Sql server unistill

banu111
05/18/12

How to delete all repeated row from my table?

hidrau
05/16/12

SQL - error in case

tommym121
05/17/12

Query Result

Pthepebble
05/17/12

controversial DBA topics

25112
05/16/12

restore with VERIFYONLY, often to confirm that backups are ok

25112
05/16/12

error - is this SQL Server or external

25112
05/16/12

CTE Join Problem

plucenko
05/16/12

Select with paramater

lrbrister
05/16/12

SQL Multiple LEFT JOINS AND COUNT Addition

rmartes
05/15/12

sql install

mkramer777
05/15/12

Generate a smart macro to print certain spreadsheets from multiple workbooks

Putoch
05/15/12

MSSQL QUERY - Get rows that don't have exact phone format

Valleriani
05/19/12

Strange behavior of the Sort component in SSIS

thomaszhwang
05/18/12

space is profile name (DBMail)

25112
05/20/12

reads and writes to Log at the same time

25112
05/15/12

how to get a list of data in a single field in a result set

CASorter
05/15/12

SQL - How to use PRINT

tommym121
05/15/12

SQL - generic stored procedure that compares fields of the two table

tommym121
05/14/12

Can we use a different column name in where cluase based on a condition?

Tpaul_10
05/15/12

Single table COUNT include 0

rmartes
05/20/12

SSRS on SQL Server 2008 is limiting report parameters

Damian_Gardner
05/15/12

MaX ID based on where

lrbrister
05/15/12

JOIN MULTIPLE QUERIES

plucenko
05/15/12

Trying to write a pivot statement for the month

Siulonbow
05/21/12

using  CONTAINS  in SQL statement

rmtogether
05/14/12

Get most recent date entry for compairison.

fcsIT
05/14/12

SQL 2005 Query Question

LostInWindows
05/14/12

Join problem - sql

plucenko
05/14/12

SQL Update

Prec94513
05/15/12

Select Left JOIN

lrbrister
05/17/12

Need help getting "Group By" working in T-SQL statement

cdemott33
05/14/12

Exchange 2003 on a Windows 2008 Domain

MeenanM
05/17/12

Changing SQL Authentication mode to Windows Only Authentication

sg05121983
05/14/12

Fill/update gaps in rows

tbaseflug
05/14/12

update table from view

ac_davis2002
05/16/12

Create new, blank database from an existing database whilst keeping the …

AbeSpain
05/14/12

inserting Auto incremental Number as a Line No

ali_alannah
05/13/12

cakculation in sql

patd1
05/17/12

Manage Multiple SQL Servers Remotely

spaced45
05/11/12

if exists check table insert

sevensnake77
05/11/12

Case Statement not working

rcowen00
05/11/12

Results from Function

rcowen00
05/14/12

create a mask data on some of the columns in the view for some users

tristonyip
05/11/12

select check all rows

sevensnake77
05/11/12

T-SQL Date Diff

thomasm1948
05/16/12

SQL Server 2005 Ent Running of Memory

Favorable
05/10/12

How do I use a SQL IN statement using a locally defined variable in a stored …

jxbma
05/11/12

Converting a query

nmarano
05/14/12

SQL Server Login Auditing - many hits for "Microsoft SQL Server Manage…

JRuiter
05/10/12

How do I coalesce column values into a comma separated list when I'm gro…

jxbma
05/18/12

What is DB2 version of PIVOT or SQL

hongning2009
05/10/12

insert if do not exist

jsbx
05/10/12

SSRS Report Wizard

lrbrister
05/10/12

SELECT * FROM [sheet1$]

jsbx
05/10/12

SSIS Lookup error

johnnyaction
05/14/12

Sincronize an SQL Server database From Laptop to central server and vice…

Masteraco
05/17/12

MS SQL Query Optimiser...

garethtnash
05/16/12

map parameters of xp_smtp_sendmail to sql 2008

sqlserverdba
05/11/12

Issue with grouping

plucenko
05/09/12

SQL Date Conversion

chokka
05/09/12

Nesteled Query

NJPhillips
05/09/12

SQL Server 2005 enable msdb sql mail

lrbrister
05/09/12

Code to Transfer large amount of records

Eamon
05/11/12

Editing Olap Queries in SSRS

trawley
05/17/12

How to enable connections problem in sql server.

searchsanjaysharma
05/15/12

SSAS aggregation of very large numbers into readable smaller numbers

ryanmccauley
05/09/12

want to write custom error details in the event logs

VIVEKANANDHAN_PERIASAMY
Loading Advertisement...

Top MS SQL Server 2005 Experts

  1. ScottPletcher

    181,549

    Guru

    1,920 points yesterday

    Profile
    Rank: Genius
  2. jogos

    170,423

    Guru

    0 points yesterday

    Profile
    Rank: Sage
  3. acperkins

    137,453

    Master

    2,000 points yesterday

    Profile
    Rank: Genius
  4. TempDBA

    109,607

    Master

    1,400 points yesterday

    Profile
    Rank: Sage
  5. matthewspatrick

    88,224

    Master

    0 points yesterday

    Profile
    Rank: Savant
  6. lcohan

    84,634

    Master

    0 points yesterday

    Profile
    Rank: Genius
  7. dtodd

    82,612

    Master

    0 points yesterday

    Profile
    Rank: Genius
  8. mwvisa1

    76,156

    Master

    0 points yesterday

    Profile
    Rank: Genius
  9. ValentinoV

    72,711

    Master

    0 points yesterday

    Profile
    Rank: Genius
  10. angelIII

    53,816

    Master

    0 points yesterday

    Profile
    Rank: Elite
  11. EugeneZ

    53,602

    Master

    0 points yesterday

    Profile
    Rank: Genius
  12. anujnb

    53,164

    Master

    0 points yesterday

    Profile
    Rank: Wizard
  13. ralmada

    50,844

    Master

    0 points yesterday

    Profile
    Rank: Genius
  14. HainKurt

    49,150

    0 points yesterday

    Profile
    Rank: Genius
  15. Buttercup1

    46,068

    0 points yesterday

    Profile
    Rank: Master
  16. huslayer

    40,600

    0 points yesterday

    Profile
    Rank: Sage
  17. appari

    37,400

    0 points yesterday

    Profile
    Rank: Genius
  18. wdosanjos

    33,836

    0 points yesterday

    Profile
    Rank: Genius
  19. tim_cs

    32,200

    0 points yesterday

    Profile
    Rank: Wizard
  20. dqmq

    31,136

    0 points yesterday

    Profile
    Rank: Genius
  21. Cluskitt

    30,940

    0 points yesterday

    Profile
    Rank: Wizard
  22. SJCFL-Admin

    30,877

    0 points yesterday

    Profile
    Rank: Master
  23. jimhorn

    28,975

    0 points yesterday

    Profile
    Rank: Genius
  24. Brichsoft

    28,107

    0 points yesterday

    Profile
    Rank: Sage
  25. momi_sabag

    27,903

    0 points yesterday

    Profile
    Rank: Genius

Hall Of Fame