SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• Export Pivot results to temporary table - Sql Server

  Hi All, Please give me an idea to export the pivot results to a temporary table in Sql Server. Requ…

  srisagar_p

  2 replies

  13 years, 9 months ago

  By: srisagar_p

• Dynamically Creating Table using Excel Sheet

  Hi Is there anyway to dynamically create DB Table by reading the Excel Value. thanks

  ns22boss

  5 replies

  13 years, 9 months ago

  By: Peter Lavelle-397610

• calculated cells and conditional formatting matrix ssrs 2005

  Hi can somebody help me on how to achieve this in Matrix table? Budget Actual Revenue $8,…

  jennette_alambra

  1 replies

  13 years, 9 months ago

  By: jennette_alambra

• sql query to format numbers

  Hi all, Need assistance in building sql server query to format numbers as dont want to handle this …

  nilesh k

  3 replies

  13 years, 9 months ago

  By: Gail Shaw

• SQL query to handle date range criteria

  Hello, need to handle below scenario: user should get data if the eneterd date is within the range …

  nilesh k

  3 replies

  13 years, 9 months ago

  By: Gail Shaw

• Identify SQL Job 'Friendly Name'

  Hi. I am migrating servers and have transfered jobs using ssis. A number of reports have been sched…

  2Tall

  5 replies

  13 years, 9 months ago

  By: MarkusB

• Remote execution of stored procedure is timing out

  First of all, I am not an SQL DBA, but I am as good as my company has. I wrote a stored procedure t…

  Richard Rice

  4 replies

  13 years, 9 months ago

  By: Richard Rice

• SSRS 2005 empty rows in matrix

  Hi all, I am having a problem with SSRS 2005 as following Scenario: following is a sample table dat…

  myjobsinus

  2 replies

  13 years, 9 months ago

  By: SQLRNNR

• New user needing advice about SQL server

  Hi Guys I'm very happy to join SQLservercentral and I'm willing to learn new things on here. I ju…

  adebiyi444

  2 replies

  13 years, 9 months ago

  By: adebiyi444

• write text file using Sp

  hi, how to write a .txt file from Sp. I have used this but not working exec master..xp_cmdshell 'ec…

  Mishal

  7 replies

  13 years, 9 months ago

  By: genehunter29009

• INSERT INTO - OBJECT NOT EXIST SQL2005 SP3

  Hello, I meet some problem when I tried to insert some data inside a new table. Basically, I connec…

  ERIC CRUDELI

  14 replies

  13 years, 9 months ago

  By: ERIC CRUDELI

• Creating Stored Procedures for Updating the Value

  Hi All, I am updating my excel data values in to SQL DB. Excel sheet having thousands of Records. W…

  ns22boss

  4 replies

  13 years, 9 months ago

  By: ns22boss

• Create parameter from getdate() to extract all previous years

  Hi, I have a requirement to display all previous years starting from 2010 and above as parameters. …

  pwalter83

  6 replies

  13 years, 9 months ago

  By: Jeff Moden

• Auto Increment Option in SQL Server Management Studio Express

  Hi, I want to auto increment my ID field.. Is there any option Like Auto - Increment in SQL Server …

  ns22boss

  11 replies

  13 years, 9 months ago

  By: ns22boss

• Sql connection error when connecting with broadband

  When we connect database locally it works properly but when we use broadband or isdn then error occ…

  ruchikakkar2005

  5 replies

  13 years, 9 months ago

  By: Divine Flame