SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Only one expression can be specified in the select list when the subquery is not introduced with EXISTS

  I've the followin code: select ( select vestiging.naam, count(*) as Aantal_Incidenten from incid…

  htilburgs

  16 replies

  15 years, 8 months ago

  By: GSquared

• Problem with Stored Procedure

  I have been killing myself over this code, any help would be greatly appreciated. first i created a…

  sql-1010785

  2 replies

  15 years, 8 months ago

  By: Dugi

• Getting an error while trying to copy a DB from SS2000 to SS2008

  My current setup is a server with SBS 2003 running SQL server 2000 sp4 and a second server running …

  binettec

  20 replies

  15 years, 8 months ago

  By: binettec

• Code to return top 10 within each subcategory

  I work with contributor data across a nonprofit with many chapters. I want to list the top 10 cont…

  Greg Herr

  3 replies

  15 years, 9 months ago

  By: Michael Valentine Jones

• How to change sql service log on account (SQL2008) through code

  Hi, I can do this using the configuration manager. Is there a way to do it through code? Thanks, nbs

  nbs098-signup

  1 replies

  15 years, 9 months ago

  By: Gail Shaw

• Server not found or not accessible

  I'm new to SQL Server. I have installed SQLServer Express 2008. I can not access the server using S…

  robblot

  3 replies

  15 years, 9 months ago

  By: Steve Jones - SSC Editor

• Sql error 1807.

  Hi I have downloaded a trail version of SQL 2008 Enteprise from Microsoft. I have some Sql 2000 dat…

  morten-908506

  2 replies

  15 years, 9 months ago

  By: morten-908506

• datediff mm between a timestamp in varchar(50) and a small datetime ???

  Here is what i have Timestamp - nvarchar(50) hire date - smalldatetime Timestamp …

  JPLeBlanc

  23 replies

  15 years, 9 months ago

  By: GSquared

• Create and Schedule Package to Import Tables

  I just installed a developer addition of SQL Server 2008 on my local machine at work. Work still u…

  dugoneill

  2 replies

  15 years, 9 months ago

  By: dugoneill

• How do I connect to a SQL Server on an XP peer-to-peer network?

  I am trying to develop an Access 2005 "Project" (ADP) application as a "front-end" to a SQL Server …

  colin-514459

  8 replies

  15 years, 9 months ago

  By: Jack Corbett

• Formulas and Formats

  Hi, I am a newbie to this enviroment and I just wondering if any one could guide me to a reference …

  Vitor da Fonseca

  2 replies

  15 years, 10 months ago

  By: Vitor da Fonseca

• installing 2005 and 2008 on same server

  Hi Folks, can you install 2005 and 2008 instances on the same server without a problem? also if I i…

  bodhilove

  2 replies

  15 years, 10 months ago

  By: Christo Wolmarans

• Multiple Connections on a PC/Server

  Hi All, I'm very new to this forum as well as to SQL Server. We are looking to move from MS Access …

  Os-984017

  4 replies

  15 years, 10 months ago

  By: Os-984017

• How to obtain start and end values in a sequence grouped by another column value

  Hi All, I have a requirement to obtain the start value and end value of a sequence based on a parti…

  gvsriramakrishna

  2 replies

  15 years, 10 months ago

  By: gvsriramakrishna

• XML Data Type Problems in SQL Server 2008 and Access 2003

  I am using Access 2003 via ODBC to connect to tables in a SQL Server database. (The database was c…

  mtgardn

  6 replies

  15 years, 10 months ago

  By: bilo_sta_bre