SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Creating reference

  HI, I am creating a table GV_ReceivedOffice with this strucutre: But VoucherNo column in this table…

  kapil_kk

  3 replies

  13 years, 1 months ago

  By: kapil_kk

• SSRS 2008 Running Value Function

  Hi, I am trying to calculate running total by order using SSRS 2008. When i pass following code to …

  mbsquery

  4 replies

  13 years, 1 months ago

  By: dilipc01

• Is there ready function for a column to break up into two ?

  Hi , I have a table.Table name of LG_XXX_. I have a "Definition_" string column in Table.Locate th…

  Lsuersoy

  2 replies

  13 years, 1 months ago

  By: Lsuersoy

• Order by CASE

  Hi geniuses, need some help here. Select r.Title, r.impact,r.probability FROM DB_Tabs_Risk r Order …

  davdam8

  1 replies

  13 years, 1 months ago

  By: davidandrews13

• Function in where clause

  Hi all Generally speaking I know that using functions in a where clause is bad practice as it can c…

  Kwisatz78

  9 replies

  13 years, 1 months ago

  By: Kwisatz78

• File Groups advatages

  hi, We have a best practice in BOL that "We need to have a separate File Group for the User data". …

  SQL*

  3 replies

  13 years, 1 months ago

  By: Gail Shaw

• SQl date script help

  I need to check if days are Sat, Sun and Mon and time between Sat 6am to Monday 6am. Can you please…

  SQL_Surfer

  1 replies

  13 years, 1 months ago

  By: Stuart Davies

• Indexing question

  Hello, I'm trying to create indexes on a table that will hold all of data changes in any columns of…

  Biank

  4 replies

  13 years, 1 months ago

  By: Biank

• SQL to divide one row by another row based on formula or rule.

  Hi All, I have a below table and need to divide one row by another row based on the formula. Date…

  shashi.bi245

  8 replies

  13 years, 1 months ago

  By: shashi.bi245

• Data Conversion Error

  I have a staging data which holds all data as NVARCHAR, I am now loading from the staging table to …

  ron.grace

  2 replies

  13 years, 1 months ago

  By: matak

• Anyone help to script the linkedservers on weekly basis by automatically

  Hi , Anyone help to script the linkedservers on weekly basis by automatically in text or .sql form…

  saran.dharsh

  3 replies

  13 years, 1 months ago

  By: saran.dharsh

• Oracle to 2008 R2 SSIS

  Hi All, Scenario: Migratin Oracle to SQL Server Issue: I was succesfully connected to Oracle from …

  SQListic

  1 replies

  13 years, 1 months ago

  By: SQListic

• script

  can anyone help me with a script to move some data in the same table. the data looks like this id …

  frecal

  9 replies

  13 years, 1 months ago

  By: frecal

• Average hourly rowcounts

  Hi I have a table with RunId, RunDateTime, RowCount RunDateTime will be every 15 minutes. 1 2013-…

  a2zwd

  2 replies

  13 years, 1 months ago

  By: ScottPletcher

• How do we know whether or not a column is involved in an index?

  We have so many indices in a table. Is there any script to easily find whether or not a column is i…

  SQL ORACLE

  2 replies

  13 years, 1 months ago

  By: SQLRNNR