SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Job Details

  In my requirement,My production server running more then 5 jobs . I want details in running schedul…

  vs.satheesh

  1 replies

  11 years ago

  By: Y.B.

• Issue - Quering XML data with column value in the same select clause

  I'm working on a query in which I need to get few nodes values from the XML data by using the value…

  windows_mss

  10 replies

  11 years ago

  By: windows_mss

• non trusted constraints vs performance

  Hi friends, We are troubleshooting a performance issue at client's database and need some of your…

  newbieuser

  21 replies

  11 years ago

  By: Eric M Russell

• Running "subreport" in SSRS from custom code

  Hello, This question is regarding SQL Server 2008 R2 SSRS. Please let me know if this is the incor…

  brett.walker

  5 replies

  11 years ago

  By: sgmunson

• only show the duplicated records

  Hi, I have a query below to show all the records with joining these two tables. SELECT DISTINCT…

  kennyhuang0108

  13 replies

  11 years ago

  By: kennyhuang0108

• Dynamic query Pivot values change

  Hello I have below script CREATE TABLE dbo.TestPivot( CollectionDate DATETIME, Products VARCHAR(40…

  ramrajan

  2 replies

  11 years ago

  By: Luis Cazares

• Get max of group no matter ccy

  Hi guys, hope you can help out with this thanks I have this data below : isin | market | ccy| stock…

  d_martins

  3 replies

  11 years ago

  By: Luis Cazares

• Return top 10 from data set

  I'm trying to get the top ten problems for each ProvName in the table based on the number of patien…

  NineIron

  2 replies

  11 years ago

  By: NineIron

• How to split varchar variable to multiple rows and columns based on two delimeter

  Dear All , declare @var varchar(8000) set @var='Name1~50~20~50@Name2~25.5~50~63@Name3~30~80~43@N…

  s.chandrahasan

  6 replies

  11 years ago

  By: WayneS

• temporary tables (# tables) & tempdb

  Hi Team, I have a Database say DB1 which has collation "SQL_Latin1_General_CP1_CI_AS". The tempdb i…

  GonnaCatchIT

  8 replies

  11 years ago

  By: crmitchell

• Delete folders/sub folders older than N no of days

  Hello Experts, If I run the below command, it helps to clean up the files inside the folders but un…

  SQL_Hunt

  4 replies

  11 years ago

  By: gsc_dba

• DB Collation change Impact

  Hi All, Our SQL Server 2008 r2 has collation Latin general. And my database 'DB1' , 'DB2' has colla…

  GonnaCatchIT

  1 replies

  11 years ago

  By: JohnG69

• Replication of stored procedure execution fails

  Hi, I am replicating a stored procedure execution, which builds and executes the following dynamic …

  Roust_m

  6 replies

  11 years ago

  By: Roust_m

• Recursive update on 3000 rows

  Hello, I need some help with this. I have a table where I would like to update the document number…

  naydenov.stoqn

  7 replies

  11 years ago

  By: sgmunson

• Distributed transaction

  Hello everyone, I am trying to run a query from a Linked server "ABCD" Set @SQLCMD = 'Select * from…

  haichells

  2 replies

  11 years ago

  By: Eirikur Eiriksson