SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• need query help with case

  select p.ProjectName, b.BidPackageNumber, c.ConstructionManager, Case when (cp.City = 'Clev…

  postonoh

  2 replies

  14 years, 8 months ago

  By: postonoh

• Need help on a query

  I have a table employee with name and age as columns. I need a query with result as EMPNAME and cou…

  tdmech56

  1 replies

  14 years, 8 months ago

  By: tommyh

• log for database 'my db' is not available

  Hello, I have a strange problem since last 2days with two of my db's when the scheduled job ran shr…

  Pritam Salvi

  9 replies

  14 years, 8 months ago

  By: Pritam Salvi

• alter database is not happening in sqlserver 2000

  Hi all, I am using sql server 2000 I am trying to use alter database option to move datafiles. But …

  Pritam Salvi

  5 replies

  14 years, 8 months ago

  By: Joie Andrew

• Dedupe order by field

  Hello All I have a table which contains a postcode, source and a distance field Postcode,Source,Dis…

  bicky1980

  1 replies

  14 years, 9 months ago

  By: kabi

• Using DSQL to Slect a field from a table

  Hi all, having a problem trying to select Data using DSQL for two of the fields. The majorit…

  Mitch2007

  1 replies

  14 years, 9 months ago

  By: Greg Snidow

• Is there a way to do this dynamicaly

  Our company has a DTS job that takes a data file and seperates it into seperate files of data for e…

  michael.morse

  4 replies

  14 years, 9 months ago

  By: Greg Snidow

• Difficult Count/Group By query

  Here are stripped down versions of the tables/columns involved in my problem: [font="Courier New"] …

  Martin Davies-966230

  2 replies

  14 years, 9 months ago

  By: Greg Snidow

• Transactions in sql

  Hi, In a transaction there are 3 update statements. The 2nd update statement invokes a trigger whic…

  suraj.app

  4 replies

  14 years, 9 months ago

  By: suraj.app

• SQL Server Analysis Services not starting

  HI SQL2005 is started but SQL Server Analysis Services is giving this error Message: The service …

  patilharshalv

  5 replies

  14 years, 9 months ago

  By: curious_sqldba

• Advantages of Cursors

  Hi, What is advantage of cursors. What ever we can do with cursors can also be done using while loo…

  suraj.app

  4 replies

  14 years, 9 months ago

  By: GSquared

• Cannot attach database in sql server manager

  Hi there, I created a database with one table on my computer (XP) and can update the table with sql…

  cari

  3 replies

  14 years, 9 months ago

  By: bijvoets

• Inserting value from one DB to another.

  Hi all, would love some guidance on what I thought would be a simple insert statement. I'm insertin…

  Mitch2007

  3 replies

  14 years, 9 months ago

  By: Mitch2007

• Help for BCP error

  I'm trying to dump a Sql Server 2005 table's contents into an Excel sheet But got this error NULL S…

  MJ-1115929

  4 replies

  14 years, 10 months ago

  By: nick.realdini

• Trigger conunderum

  I have 2 simple tables tst_a and tst_a_arch On tsts_a I have this trigger -------------------------…

  douglas.allison-1136597

  1 replies

  14 years, 10 months ago

  By: PaulB-TheOneAndOnly