SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Error on upgradation of SQL 2K8 over cluster

  Hello All, We got the following error during the SQL Server 2008 standard edition service pack 2 up…

  jitendra.padhiyar

  1 replies

  12 years ago

  By: jitendra.padhiyar

• SELECT question

  I have 2 tables. Each one has the following columns: SSN, PKT and FICE_NBR. I need to be able to …

  gary.morey

  15 replies

  12 years ago

  By: Luis Cazares

• Using REPLACE

  Hi I have a requirement where I have replace two different strings with another string. i.e. if the…

  VSSGeorge

  2 replies

  12 years ago

  By: VSSGeorge

• Finding the MIN and MAX date - How do I approach this?

  I have a table with the following data: EMPIDEffectiveDate PrimaryRater 1234510/10/2001 …

  terry.ward

  10 replies

  12 years ago

  By: Luis Cazares

• Tabledesign (newbie)

  Hello, I am creating a simple database to log the number of visits from clients. The table is as fo…

  andreas 77518

  4 replies

  12 years ago

  By: AndrewSQLDBA

• Display all months with no data

  Newbie...I've seen some suggestions on how to display query results for all months even if there is…

  boehnc

  2 replies

  12 years ago

  By: stevenb 14609

• Get Data Last 5 Days average data if value is less then 100000

  Hello Experts ! I have a data sheet attached as a sample... In column B dates are placed, Column C …

  smer

  1 replies

  12 years ago

  By: CKX

• Sql Select statement running slow

  Hi I have a select statement that runs forever because of 'Select Distinct' and it makes tempdb gro…

  jdbrown239

  5 replies

  12 years ago

  By: Jason Wolfkill

• Help with multiple events per user on Same day query

  I have to create a report that tells us if a Patient has had a Behavioral Health visit and a Medica…

  thomashohner

  2 replies

  12 years ago

  By: thomashohner

• part of database backup

  Hi, Is it possible to backup part of database. i have 2 yrs data in my database can i backup last …

  $t@r

  9 replies

  12 years ago

  By: jitendra.padhiyar

• Database activity

  Hello, We have a SQL Server 2005 Enterprise Edition - 64 bit instance with 12 user databases. The …

  jralston88

  6 replies

  12 years ago

  By: kevaburg

• Difference between Now() and Today()

  Hi Please explain the Difference between Now() and Today() functions in SSRS reports. Are they both…

  VSSGeorge

  4 replies

  12 years ago

  By: Umer Akram

• how to maintain test environment

  Hi all, I was asked to create a test environment for one of our apps that is supported by 3 databas…

  RightOnTarget

  6 replies

  12 years ago

  By: RightOnTarget

• sp_send_dbmail; one record at a time

  Hello All, I am using dbmail to send out the results of a query. The results are being sent to SMS…

  wheelsthatgrip

  8 replies

  12 years ago

  By: wheelsthatgrip

• Select top X for each multiple item in column

  I have the following script: SELECT dbo.HemAnimal.AniUserNumber, dbo.HemAnimal.AniResponderNumber…

  domleg

  2 replies

  12 years ago

  By: CKX