SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• How to avoid using a cursor?

  Hi everybody! I'm trying to figure out the best way to go about a solution, and I'm trying to avoid…

  pixeldude

  28 replies

  12 years ago

  By: Lynn Pettis

• Date Conversion Problems Using BIDS

  Hi, I'm loading a bunch of files that have one column which is a date/time stamp. It's of the fo…

  bkmooney

  6 replies

  12 years ago

  By: Koen Verbeeck

• INCLUDE option in index

  I understand the use of include option in index. However, the index is supposed to point to the loc…

  N_Muller

  10 replies

  12 years ago

  By: Evil Kraig F

• 1 Simple Question

  I just have 1 question for the SQL Server community. Which sql server version and edition I can dow…

  LearningDBA

  7 replies

  12 years ago

  By: LearningDBA

• Converting DateDiff to HH:MM:SS

  Evening All, We're having some issues with some data and i will do my best to explain, The question…

  waqqas.zia

  4 replies

  12 years ago

  By: jdineshk

• BIDS looking for ideas.

  I have a DTSX package that receives, daily, 5 flat files. It's a known format of extract so it's a…

  CptCrusty1

  4 replies

  12 years ago

  By: Lempster

• Convert integer date to datetime

  Hi, I have 2 columns with integer values, Column1=Date, Column2=Time and I want to convert them int…

  mattias.lundqvist

  5 replies

  12 years ago

  By: HanShi

• UPDATE STATISTICS on SQL 2k8 R2

  /* Hi Gurus, I am using following piece of code to update statistics everyday mid night on SQL serv…

  sqlbee19

  14 replies

  12 years ago

  By: SQLBuddy123

• Delete Duplicate records based on 2 fields

  Hi, I am trying to remove duplicates based on 2 fields (rtno and acctno). Also, I want to leave the…

  rlsublime

  6 replies

  12 years ago

  By: Keith Tate

• Inner Join Based on Conditional Column in Sql server-2008

  I Have Table Called 'Sales' and 'Voucher',I Need To Show Each Customer ""Dueamount"" Details Based …

  pradeep.joy21

  1 replies

  12 years ago

  By: Sean Lange

• Return a default if query returns 0 rows

  Hai All I have written a stroed procedure where I pass a parameter called category. If the category…

  shaik.mussarath

  6 replies

  12 years ago

  By: shaik.mussarath

• SQL DBA:‘It is being used by database in logshipping

  We have completed LOG SHIPPING for few databases except two databases. and Getting an error as ‘I…

  venushakamuri

  1 replies

  12 years ago

  By: Suresh B.

• Pull certain periods based on todays date

  I have a sales history table with invoice totals by period. (1=Jan, 2=Feb,...) My sales fall into t…

  jcobb 20350

  10 replies

  12 years ago

  By: Dwain Camps

• How To Sort By the MAX value in one cal

  I have a very simple table (DDL below) that stores audit data that includes the WHEN (DateUsed), th…

  YSLGuru

  3 replies

  12 years ago

  By: YSLGuru

• Test if table columns are identical

  CREATE TABLE #tblTasks ( TaskID int, Task varchar(20), SortID int …

  webskater

  2 replies

  12 years ago

  By: webskater