T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• compare bit values without using multiple or's

  Hi, I feel I should know this but for the life of me I can't think of an elegant solution...I have …

  cantor

  11 replies

  14 years ago

  By: cantor

• Sum up certain accounts accross period

  Hi SQL gurus, I have a fact table shown as below. It consists a mixture of Profit & Loss (PL) …

  yingchai

  10 replies

  14 years ago

  By: Dwain Camps

• Which Isolation level should i use for booking flight

  I have a flight reservation program use mssql ,For reserving flights i want to be sure should i use…

  ra0o0f

  4 replies

  14 years ago

  By: Jack Corbett

• discusssion forum,thread,messages,totalnumber of replies last post date

  I need help with the following query Table 1: ThreadID, SectionID,OpenDate,CloseDate Table 2: Messa…

  Sarsoura

  1 replies

  14 years ago

  By: Mark Cowne

• Send Mail task

  I have to send the error message to the mail which i gave in Send mail task. How can i store the er…

  SQL_Starter

  1 replies

  14 years ago

  By: MyDoggieJessie

• Retrieve First Name and Last Name

  I have a table which has a column called Name, which contains the name of our vendors. The data fo…

  QQ-485619

  2 replies

  14 years ago

  By: CapnHector

• Aggregating multiple columns into 1

  I have a table containing some customers names and the amounts they have spent per month. I would l…

  eseosaoregie

  5 replies

  14 years ago

  By: eseosaoregie

• Case Statement

  Hi Friends, I'm learning the dynamic SQL Server, Any one can tell me what is the use of case statem…

  sandeep4testing

  7 replies

  14 years ago

  By: sturner

• CSV tables

  Hi This is my table(dynamic) id type dynamic_name dynamic_table_id 2 2 View Art Work 1072,1310 3 2 …

  sqlfriends@sql.com

  2 replies

  14 years ago

  By: sqlfriends@sql.com

• Database Backup via T-SQL

  Hi, We want our software users to be able to click some button or select some menu-option in our ap…

  vinceknockaert

  4 replies

  14 years ago

  By: vikingDBA

• CTE( common table expression)

  Hi dude, can u tell me what is CTE( common table expression), how we can use this?. Thank's Sandeep.

  sandeep4testing

  5 replies

  14 years ago

  By: Jeff Moden

• Composite non-clustered index.

  Hi Team, In our sinario ExchangeTable have 24 columns in this one we have create one clustered inde…

  shiv-356842

  2 replies

  14 years ago

  By: shiv-356842

• Accessing SQL Server with other Client tools

  I have been working with SQL Server 2005 since 2 years and have always used SQL Server Management S…

  itskanchanhere

  14 replies

  14 years ago

  By: gladys14g2

• Need separeta last, first and midin from full name

  I have situation where I have nest full name contain format like First Name Initial Last Name First…

  asluchok

  8 replies

  14 years ago

  By: GSquared

• Error with WHERE in OPEN QUERY Statement

  The following works: SELECT * FROM OPENQUERY(LSCTLRDAT1, 'SELECT * FROM Company') This does not w…

  Welsh Corgi

  32 replies

  14 years ago

  By: Welsh Corgi