SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Changing Table Names

  Hello good folks of the SQL world. In the database that I have designed I'm having a problem with …

  Mordred

  3 replies

  13 years, 10 months ago

  By: Mordred

• Need to join the results of a Union

  Hi, I perform a count on a certain condition. The results are as follows: Count - Number of People …

  mic.con87

  2 replies

  13 years, 10 months ago

  By: mic.con87

• Error: Unable to switch encoding

  I'm trying to load xml files into table with xml column in sql. getting the below error when i exec…

  Kumar SQL

  4 replies

  13 years, 10 months ago

  By: GSquared

• Restore Copy of Live DB to Production Server?

  Hi All, I am wondering about others views about restoring a copy of a production db to the same se…

  Ness

  12 replies

  13 years, 10 months ago

  By: Daxesh Patel

• Dynamic Pivot - Grouping Results

  I am using a dynamic pivot to get the 'x' number of stock prices for a series of dates. The followi…

  tobinare

  6 replies

  13 years, 10 months ago

  By: vinu512

• sharepoint debugging error

  hi, while debugging a sharepoint project i am getting a following error- Error1Error occurred in …

  RahulSingh

  1 replies

  13 years, 10 months ago

  By: Ant-Green

• SQL QUERY

  pls help me how to get desired out put based below table declare @t1 table(ID VARCHAR(10),ST_DT DA…

  subbu1

  4 replies

  13 years, 10 months ago

  By: subbu1

• Search process

  Hi, Suppose I have created a [test] table with ID, Lastname, Phonenbr,Address and inserted records …

  NLV

  2 replies

  13 years, 10 months ago

  By: John Mitchell-245523

• EXEC ('USE [DataBase] GO; '+@trigger) AT [linkedServer]

  Hi, I might be doing this in the wrong way. But I need your help. (It is SQL Server 2008 SP1) I hav…

  agh100

  4 replies

  13 years, 10 months ago

  By: agh100

• Change Column to PK

  Hi all I am trying to change a column that is a int to a PK this is what I have tried but it never …

  jerome.morris

  3 replies

  13 years, 10 months ago

  By: jerome.morris

• Best Way to swap Databases

  I have a product configuration web app talking to a 2008 R2 SQL Server in the backend. When new pro…

  edwardw 90939

  9 replies

  13 years, 10 months ago

  By: darrenshrwd

• SQL Server Replication between Enterprise and Developer

  Can we setup replication between enterprise and Developer edition of sql server 2008 r2? Thanks

  SQListic

  1 replies

  13 years, 10 months ago

  By: Gail Shaw

• Transpose of Rows To Columns in Sql Server2008

  Hi all, I have got the query results in rowwise for phases for a given project id by cross join wit…

  arubala75

  3 replies

  13 years, 10 months ago

  By: Jared

• sys.dm_exec_query_plan question

  why is it that when executing the following statement, the link in some rows will return graphical …

  Robert Klimes

  3 replies

  13 years, 10 months ago

  By: Robert Klimes

• SQL Query Progress Bar

  Hey Guys, I am a novice sql coder, and I am experimenting with different queries. Some run quickly,…

  cjcolton

  2 replies

  13 years, 10 months ago

  By: Gail Shaw