T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• 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, 9 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, 9 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, 9 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, 9 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, 9 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, 9 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, 9 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, 9 months ago

  By: harri.reddy

• Aggregate

  Hi All, This is my sample data Composite_id Index Value MX0493 …

  sqlenthu_11

  5 replies

  13 years, 9 months ago

  By: sqlenthu_11

• T SQL Error Capturing

  Hello, A quick question trying to handle an error when using sp_attach_db. Here it is in the scrip…

  mymail.default

  10 replies

  13 years, 9 months ago

  By: andegre

• Need Help on This Script [Split Column through XML & Function]

  Pls Explain ------------------------------------------------------------------------------ ;WITH Ct…

  ashish.sys

  3 replies

  13 years, 9 months ago

  By: Sean Lange

• Combining multiple rows to single row

  Hi, I have a table like below structure PID ID FileName FIle_Type_ID 1 1 File1 1 2…

  deepzzzz

  4 replies

  13 years, 9 months ago

  By: vinu512

• Need assistance with converting [0..n] to [1..1] for a view

  The following image should make things clear: The view in question is created via a LEFT OUTER JOI…

  zxxz

  5 replies

  13 years, 9 months ago

  By: vinu512

• Need Help to schedule a script to get an email alert with few colored attributes

  Hi, I'm trying to have few records appearing with colored background in the email("red" > 80% a…

  Mac1986

  1 replies

  13 years, 9 months ago

  By: Ant-Green

• Any set-based solutions to this problem?

  Given a dataset like this: [font="Arial"]Name Quarter Amount1Date1 Amount2 …

  virgilrucsandescu

  2 replies

  13 years, 9 months ago

  By: Jeff Moden