SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• SUM Case When (decimal's!)

  Hi, Can someone please explain why this is happening. I am using a select query to do the following…

  dramaqueen

  8 replies

  11 years ago

  By: dramaqueen

• Just Some Help To Impress My New Boss Pls

  i add the file i need help to build sql query as show in file tnx all http://1drv.ms/1R21ene

  asafswis2

  4 replies

  11 years ago

  By: asafswis2

• SQL Server Management Studio Query Analyzer Replacement

  Hi probably a question asked a hundred times, apologies.. My internet host used SQL Server 2000 but…

  Andrew Bagley

  6 replies

  11 years ago

  By: Andrew Bagley

• Summarising transaction data removing nulls

  I have two tables one list changes of hospital ward and one lists changes of consultant doctor. Th…

  David 76709

  11 replies

  11 years ago

  By: Y.B.

• Date Function (Possibility)

  Hello everyone, is it possible that result set only return me the Loan ID (LID) where my Draft Date…

  SQLPain

  19 replies

  11 years ago

  By: SQLPain

• Scripting a query that needs all values.

  This is the database structure I setup: --Main Table CREATE TABLE [dbo].[tbl_RF_Items]( [ItemID] …

  pmb88

  6 replies

  11 years ago

  By: ChrisM@Work

• Login Timeout Expired & Log Backups

  The current contract I'm working on at the moment are getting very intermittent "Login Timeout Expi…

  Ant-Green

  21 replies

  11 years ago

  By: Ant-Green

• numerator

  Hello, I have 2 tables: 1 is with only one field: numerator 2ed is (for example) sales information.…

  sql_u

  3 replies

  11 years ago

  By: ChrisM@Work

• Memory and port 1433 errors

  I have recently been getting the error: Server TCP provider has stopped listening on port 1433 due …

  mlorek

  1 replies

  11 years ago

  By: Jayanth_Kurup

• Enable and disable trigger

  Can I know on what scenario, the disable trigger will be enable again. Because I already disable th…

  chris92mars

  3 replies

  11 years ago

  By: Gail Shaw

• Processes That Update a Certain Column

  Hello All: I have a table and a specific column inside this table. I know this table is being upda…

  kocheese

  8 replies

  11 years ago

  By: ScottPletcher

• How do you setup a listener within SQL2008?

  Hi - One of my colleagues has been asked to setup a listener within SQL. I'm assuming a starting po…

  dax.latchford

  4 replies

  11 years ago

  By: Lowell

• SSRS Report builder (letting user only see their own information)

  I have a column in my report user_name, which consists of the usernames of each individual. When th…

  SQLPain

  4 replies

  11 years ago

  By: Jayanth_Kurup

• Here's a wierd one - Notify Operator only works some of the time

  Hi All, I've been working with Database Mail for some time but I haven't seen this one before. I …

  Moffitar

  11 replies

  11 years ago

  By: Z. Yin

• CASE Statement with Date

  Need help on writing case statement We were assigned to modify the existing query. So, we need to w…

  Tamrak

  6 replies

  11 years ago

  By: Jeff Moden