SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• DB Development Project Spec Template

  Hi, all: Sorry if this is the wrong place to post this; I didn't really see an area for this kind o…

  lek103

  1 replies

  14 years, 1 months ago

  By: sturner

• Dynamically select Rows and Columns based one NULL value

  Hi All, I have encountered a problem. I believe that this community will solve the problem./I am a …

  mollaa

  5 replies

  14 years, 1 months ago

  By: mollaa

• SQL Server "Last Command in IBI Focus equivelent to SQL Server

  I have used IBI Focus for over 20 years now and am just starting SQL Server. It has been interesti…

  cljolly

  4 replies

  14 years, 1 months ago

  By: Mark Fitzgerald-331224

• Replication agent error

  Distribution agent is failing with below error SQLServerAgent Error: Request to run job Job_id (fro…

  vb5566

  3 replies

  14 years, 1 months ago

  By: vb5566

• transfere data between branches

  I work in company have more branches main branch and other branches work with sql server 2005 all d…

  ahmed_elbarbary.2010

  4 replies

  14 years, 1 months ago

  By: rameshrohan

• Nth Max /Min value

  How to find the nth max or min value in a column select * from (select distinct ext_price,ROW_NUMBE…

  GuruGPrasad

  2 replies

  14 years, 2 months ago

  By: Jeff Moden

• help with "joiN' quiries

  Help, i am doing a small project name 'school'..these are my tables ..after the table i have so…

  samg.j23

  20 replies

  14 years, 2 months ago

  By: JeffRush

• Data in tthe same order in which it is inserted

  Hi, I am inserting data into a table from a flat file. I want the data in the table to be in the sa…

  sqlSer12

  34 replies

  14 years, 2 months ago

  By: Orlando Colamatteo

• is it possible to create primary key on non-clustered index ?

  is it possible to create primary key on non-clustered index ?

  charipg

  2 replies

  14 years, 2 months ago

  By: charipg

• Filestream on 2K8 Active\Active Cluster

  Hi All Please advice, I need to use Filestream on our 2K8 cluster Active\Active Cluster, what thing…

  smthembu

  2 replies

  14 years, 2 months ago

  By: smthembu

• between dates

  Hello Can not get this query to bring up the rows with just the dates i have asked for in the betw…

  hifromb

  4 replies

  14 years, 2 months ago

  By: Mark Fitzgerald-331224

• returning 0 records

  I have a query: SELECT 'TEST',t1.name+', '+t2.address FROM table1 t1 full outer join table2 t2 on t…

  Mark_1820

  3 replies

  14 years, 2 months ago

  By: roryp 96873

• FTP task recently stopped working

  Hello, I have an FTP task in a SSIS package. This task has been running great for a year. But not…

  Sector7G

  1 replies

  14 years, 2 months ago

  By: Sector7G

• Stored Procedure Error

  Hi all,trying to run a Stored Procedure on a 2008 SQL data from a desktop machine via Microsoft Acc…

  davidshephard

  5 replies

  14 years, 2 months ago

  By: Orlando Colamatteo

• sql server scheduled job fails if double quote around db name

  Hi, i have a database having dash in the db name - MMG-Events, do I have to add double quote around…

  zxmgh

  3 replies

  14 years, 2 months ago

  By: CapnHector