T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• need help to build update statement with 2 conditions

  I have schema and data as below, declare @tApplyProgram table (myID varchar(50), programID varchar…

  miss.delinda

  2 replies

  14 years ago

  By: miss.delinda

• Accounting Degree

  Enroll in on-campus or online accounting degree program. It can give you the foundation you need to…

  justin3i

  1 replies

  14 years ago

  By: Ron McCullough

• how to sum up instances only 3 of the 4 values that can occur in a given column

  Hi, thanks in advance. I have a table that contains a column called Outcome. It can contain 4 poss…

  xenophilia

  15 replies

  14 years ago

  By: xenophilia

• simple tsql question

  Hi i have a filed wich type is datetime : and data in that field are like this: 2012-05-01 00:00:0…

  nazaninahmady_sh

  2 replies

  14 years ago

  By: Mark Fitzgerald-331224

• need help to build update statement with some conditions

  I apply for assistance. May there willing to help I have table's and data as following, declare @t…

  miss.delinda

  2 replies

  14 years ago

  By: miss.delinda

• Last ModifiedDate of any related Table write to a Audit-Table

  I want to update the field "ModifiedDate" in an audit table with the last (up) date (ModifiedDate) …

  info 58414

  1 replies

  14 years ago

  By: Mark Fitzgerald-331224

• trimming a string

  How would you trim a string that looks like this? I need only the string between the first set of …

  xenophilia

  32 replies

  14 years ago

  By: xenophilia

• code

  help me with this code its not showind date declare @row1 datetime set @row1 = @fromYTD …

  hbtkp

  1 replies

  14 years ago

  By: CapnHector

• UDF into variable

  hi i am executing udf as (select fGetGenericDate (@param)) which returns datetime as datatypeof …

  hbtkp

  2 replies

  14 years ago

  By: hbtkp

• Finding Multiple Start and End Dates

  I have a request where I have to find the start and End statuses for a member.  The requirement is …

  Mike01

  4 replies

  14 years ago

  By: Mike01

• Procedure getting stuck

  I've a procedure which insert data into a table from the join of two tables based on the search cri…

  sqlnaive

  7 replies

  14 years ago

  By: Grant Fritchey

• Use one query to get two similar result sets in one

  Hi, I have two SELECT queries. They are the same, only the conditions in the WHERE clause different…

  oolawole

  6 replies

  14 years ago

  By: oolawole

• Two Case Statements

  I am trying to create two new columns,using a case statement of the same data. For example Select …

  bostonjoey

  3 replies

  14 years ago

  By: bostonjoey

• select statement

  hi i am having trouble in select stm select "heading1" = case when (condition) then item1 …

  hbtkp

  17 replies

  14 years ago

  By: vinu512

• hierarchial query in sql server 2005

  Hi, Can i get sample code for hierarcial query in sql ser 2008.My Scenario is as follows: I have a …

  pkkandukuri

  3 replies

  14 years ago

  By: Jeff Moden