SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• How to ? Insert multiple records in a table from a single record in another table

  I have a table that contains department and names ; Department char(20) Name1 char(20) Name2 char(2…

  SteveEClarke

  5 replies

  13 years, 11 months ago

  By: SteveEClarke

• SSIS Loading data from row number

  I started a load that ended up failing because of an SSIS error SSIS Error Code DTS_E_PRIMEOUTPUTFA…

  Jonathan Marshall

  8 replies

  13 years, 11 months ago

  By: Jarom Richardson

• Error when viewing Registered server

  Hi, In one of our server SQL server 2008 express edition is installed. When I view the Registered s…

  Ryan007

  1 replies

  13 years, 11 months ago

  By: Jared

• Memory Utilization Advise

  Hi Guys, I do understand that SQL Server's caching behaviour is the reason for the substantial memo…

  chewychewy

  4 replies

  13 years, 11 months ago

  By: TheSQLGuru

• help eliminate duplicate rows

  Hi, the script below returns duplicates, how can i make it return 1 result per machine_name. SELECT…

  FTdenali

  8 replies

  13 years, 11 months ago

  By: FTdenali

• Ranks in SSRS

  Hi All, I have a report that shows figures for branches and the sales manager want to see the top 3…

  SceloM

  3 replies

  13 years, 11 months ago

  By: Ant-Green

• Cannot open data file error while running SSIS package through SQL Server job

  Hi, I created a SSIS package which will generate an output file and place it on a remote fileshare …

  sqlstud

  4 replies

  13 years, 11 months ago

  By: Perry Whittle

• where clause, vs AND clause in the join

  I was playing with a query to see the most efficient way to write it. it takes a table that contain…

  winston Smith

  1 replies

  13 years, 11 months ago

  By: Gail Shaw

• Case Condition in the Where Clause

  Hi All, I want to retrieve two table based on the following condition 1) m.ids = '1800m380000ioet75…

  farooq.hbs

  9 replies

  13 years, 11 months ago

  By: farooq.hbs

• copy data from one table to another.

  CREATE TABLE [dbo].[abcd]( [Aid] [int] IDENTITY(1,1) NOT NULL, [Title] [varchar](50) NULL ) ON [P…

  freecoder

  7 replies

  13 years, 11 months ago

  By: Perry Whittle

• Duplicate Records

  I am creating a report that lists Move Ins and Move Outs between specific dates. When testing my r…

  nscott 48570

  7 replies

  13 years, 11 months ago

  By: ChrisM@Work

• WAITS, Network_IO and confusion!

  Hi all, We have some queries that are taking users over 100 seconds to complete. So i thought i wo…

  Staggerlee

  3 replies

  13 years, 11 months ago

  By: Staggerlee

• call web service from sql server 2008 R2

  Hi, I am wondering , if there a way to call web service from sql server and send emails, wich sends…

  anush_tar

  3 replies

  13 years, 11 months ago

  By: Ant-Green

• The AcquireConnection method call to the connection manager failed with error code 0x80004005.

  Hi I am using oracle source connector from Attunity in my SSIS package. When I am executing my pac…

  rakesh_itcvrce

  2 replies

  13 years, 11 months ago

  By: rakesh_itcvrce

• EXEC Sp in another sp.

  I have doubt Recording SP's i have to use previous developed sp in my present sp. here previous sp …

  Prasad.N

  4 replies

  13 years, 11 months ago

  By: Prasad.N