SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Rollback in SSIS

  What I want to achieve is to have a Rollback on the inserts when any one of the tasks fail in the c…

  Sridhar-329062

  3 replies

  6 years, 10 months ago

  By: jinuelsa88

• Dynamically Build Replace (from table values)

  Two questions: When I cut/paste code from the SQL query window into this area I always get spaces.&…

  texpic

  3 replies

  6 years, 10 months ago

  By: texpic

• I need to change the value of two fields as I insert the rows into a table

  So I have the source table   TdatasegTestI have the target table TdataSegIf I needed…

  randyetheridge

  13 replies

  6 years, 10 months ago

  By: randyetheridge

• Can't remove multiple char(32) strings

  Hi, I have some double spaces in text strings that I would like to remove.I have tried the usu…

  david_h_edmonds

  7 replies

  6 years, 10 months ago

  By: ChrisM@Work

• Stored Procedure

  Hi  IN below code i want that this Case condition should also check , If Type = 'T' and t.Peri…

  jsshivalik

  1 replies

  6 years, 10 months ago

  By: laurie-789651

• SQL Server 2008 R2 installation error "a mof syntax error occurred "

  Hi; Team; at the time of installation MS SQL Server 2008 R2 on windows server 2003 I am facing fol…

  SQL_Helper

  3 replies

  6 years, 10 months ago

  By: Thom A

• Record with Max Date from Table T2

  Hi  I have below code and i want record with Max Date from Table 2 SELECT * FROM dbo.Employee …

  jsshivalik

  1 replies

  6 years, 10 months ago

  By: Thom A

• Update Statement

  Hi  Can the below 2 Update statements be executed with 1 Update statement Update [Test] set DT…

  jsshivalik

  1 replies

  6 years, 10 months ago

  By: Eirikur Eiriksson

• Error - 'The multi-part identifier A.Months could not be bound"

  Hi  In below query it is showing 'The multi-part identifier A.Months could not be bound" . I w…

  jsshivalik

  1 replies

  6 years, 10 months ago

  By: Gail Shaw

• Blocking problem

  I was given a stored procedure that has a query which frequently blocks other processes. Here is a …

  SQL Guy 1

  3 replies

  6 years, 10 months ago

  By: ScottPletcher

• Error - The multi-part identifier "dbo.ComputeLowest" could not be bound.

  Hi   I have written below code in function . When i execute  select [dbo].[ComputeLowest]…

  jsshivalik

  1 replies

  6 years, 10 months ago

  By: Eirikur Eiriksson

• Function

  Hi   What is wrong in the below query. It is saying Target invalid column name . I have writte…

  jsshivalik

  1 replies

  6 years, 10 months ago

  By: Jonathan AC Roberts

• Query

  Hi I have below code . I want record should be inserted only in tblTest if No_ value in test e…

  jsshivalik

  3 replies

  6 years, 10 months ago

  By: C DBA Lockhart

• Issue in IF EXISTS

  Hi, We are facing a strange problem in our stp. The query is as below IF EXISTS (SELECT 1 FROM tbl_…

  saum70

  4 replies

  6 years, 10 months ago

  By: saum70

• Index space

  Hi Guys  I just created an index ( with only 1 key column ) in testserver , index space…

  WhiteLotus

  4 replies

  6 years, 10 months ago

  By: Jeff Moden