T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• join

  account transction amount =============================== A-1234 Cr 6454 A-8464…

  raghuldrag

  8 replies

  13 years, 11 months ago

  By: Lynn Pettis

• Help the query

  Hi Guys, Thanks for advance, i have 3 tables like 1.MainProduct,2.sub product,3. product this tabl…

  ranganathanmca

  7 replies

  13 years, 11 months ago

  By: ranganathanmca

• assigning a number or step to a sequence that restarts within a result set

  I have a record of CIP cleaning processes that have been applied to a number of tanks. They have u…

  DavidL

  7 replies

  13 years, 11 months ago

  By: DavidL

• Scripts to execute multiple Merge Statements

  I was sent Scripts to execute multiple Merge Statements. There are no Go Stement between each Merge…

  Welsh Corgi

  2 replies

  13 years, 11 months ago

  By: GSquared

• Add/Insert a character mid string

  Hi I'm sure someone will know an answer to this. I need to insert a decimal point (.) as the forth…

  LoosinMaMind

  5 replies

  13 years, 11 months ago

  By: vinu512

• Need help with a count.

  Hi, I've been struggling with a pretty simple count... Ive got a table: companies -> |id|branch|…

  memymasta

  11 replies

  13 years, 11 months ago

  By: vinu512

• sql server

  i have 2 tables like "storage" compny location lotno ----…

  raghuldrag

  13 replies

  13 years, 11 months ago

  By: ayesha.mad

• Combine two similar rows into one row with an extra field

  Hi All, OK let me see if I can explain the problem. I have some SQL in an SSRS report that I've be…

  indieinferno

  3 replies

  13 years, 11 months ago

  By: deepzzzz

• Help Needed in Split Column

  i want to split one column into multiple till the last delimiter ends. Delimiter is comma

  ashish.sys

  3 replies

  13 years, 11 months ago

  By: deepzzzz

• Need help with a trigger

  Hello, I need to create an insert trigger on a SQL Server 2005 database table that will set the ins…

  oradbguru

  3 replies

  13 years, 11 months ago

  By: Lowell

• Insert Null values into a Not null column

  Hi, I have a table where I am trying to add a column create_dt (datetime) and the defalut constrain…

  jaya

  7 replies

  13 years, 11 months ago

  By: jaya

• Need help in T-sql to get the Last Year's first 4 week sales data

  Hi, I need to count the last year's first 4 week's sales data.I have DDL script below. Please help…

  Jay Pete

  6 replies

  13 years, 11 months ago

  By: Jay Pete

• TSQL that returns every item in the left table of a "left outer join" for several rows of the right table in the join?!

  Hello, Table A - Facilities (currently 100 rows - distinct rows) FacilitiesID int Facility …

  WebTechie

  4 replies

  13 years, 11 months ago

  By: Lynn Pettis

• Help in hotel search query

  I am trying to search hotels,i am stuck with this particular search criteria where you have to sear…

  SQL006

  4 replies

  13 years, 11 months ago

  By: Jasmine D. Adamson

• how to login into ssms

  hi i need to add my user name into ssms,how to login first in order to add another user. like sa or…

  harri.reddy

  6 replies

  13 years, 11 months ago

  By: harri.reddy