SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• SQL Server 2005 installation error

  "An instance with the same name is already installed on this computer. To proceed with SQL Server S…

  m261

  5 replies

  11 years, 3 months ago

  By: m261

• getting duplicate rows when adding a new join

  I am working on some Else's code, I am enhancing a report the program the code is coming from is vi…

  mcummings

  15 replies

  11 years, 4 months ago

  By: SQLRNNR

• Maximum count of allowed ODBC sessions are exceeded.

  Hello, I have an application that connects to a SQL 2005 ENT Database. The app (running on a clust…

  bluefox

  1 replies

  11 years, 4 months ago

  By: PaulB-TheOneAndOnly

• Grouping by day on a rollover count

  Hi, I have a table containing a count that rollsover at around 32000 to 0 possibly many times a day…

  brett.y

  12 replies

  11 years, 4 months ago

  By: Jan Van der Eecken

• Help me buddy's... in sql server 2005 (topic:columns update)

  Hi everyone, I would appreciate if anyone help me in this topic.In brief i will describe about my w…

  DivyaMohankumar

  4 replies

  11 years, 4 months ago

  By: DivyaMohankumar

• Help me guys. CARRIER CONFUSION!! MS SQL or ORACLE

  Hi guys , I live in INDIA. For one year i have been working in sql server 2005 as a developer an…

  JoNTSQLSrv

  5 replies

  11 years, 4 months ago

  By: JoNTSQLSrv

• Order of rows in a Table with Identity Column.

  I have a table with an Identity Column as TransactionId and also it is a primary key. The table has…

  jignesh209

  12 replies

  11 years, 4 months ago

  By: Dwain Camps

• Linked tables in Acess from Sql server (call failed) error!!!

  i have an access db which has appx 25 linked tables which read from a SQL server db, i have a macro…

  devilsid

  2 replies

  11 years, 4 months ago

  By: SmackMule

• Different Approach

  I am in the process of writing a stored procedure to extract data from one of our systems, to impor…

  volleygirl029

  6 replies

  11 years, 5 months ago

  By: ChrisM@Work

• Need Urgent help in procedure

  Please find both the procedure here tghe columns named as daystosuggested is calculating different …

  Avik Roy

  1 replies

  11 years, 5 months ago

  By: Gail Shaw

• connection failed sqlstate 37000 SQL error: 4064

  MS-Access Front End and SQL 2008 in a Server 2008 Domain. Microsoft SQL server Login Connection fai…

  drnorbert

  1 replies

  11 years, 5 months ago

  By: Sean Pearce

• Newbie needs help

  Hi, Newbie here would like some help if possible. I’m trying to write a sql statement to extract…

  krzykris

  4 replies

  11 years, 5 months ago

  By: Jan Van der Eecken

• Adding an Extended stored procedure

  I am having some problems creating / using an extended stored procedure. (SQL 2005 sp 4) When tryin…

  Stuart Davies

  1 replies

  11 years, 5 months ago

  By: Stuart Davies

• Querying two time columns for sum of datediff

  Hi, I have a table with two columns of datetime. The first is considered the 'startdate' and the s…

  brett.y

  3 replies

  11 years, 5 months ago

  By: Sean Pearce

• SSIS not importing zipcode data correctly into SQL from Excel

  Using SSIS under MS SQL 2005 Server SP2. Using SSIS to create a package that takes data from an Exc…

  rons-605185

  11 replies

  11 years, 5 months ago

  By: 1rohan2289