T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Need help in query

  Hi Expert, I have a result set like this (4 coulums PEriod,Sense,mt,Total) Period Sense …

  snsingh

  4 replies

  11 years, 5 months ago

  By: Alan Burstein

• Need help in query - urgent plz

  "Class""studentid" "is_std_prim""EnrolCheck""Subject1" "Subject2" "ClassA" "10001"…

  calibar2k

  2 replies

  11 years, 5 months ago

  By: Alan Burstein

• Previous Max Event

  An interesting scenario. Source Table stores history of events with TimeStamp: CustomerIDChangeTyp…

  Gagandeep Singh

  3 replies

  11 years, 5 months ago

  By: serg-52

• Order by numeric doesn't work

  the select statement in the join orders the numbers asc and if you run everything below the case st…

  Shelley Allen

  7 replies

  11 years, 5 months ago

  By: Matt Miller (4)

• SQL SERVER Comma Separated values XML PATH

  Hi I Have a very critical issue in Comma separated values using XML Path I have table "MENU" stori…

  cnu1252

  10 replies

  11 years, 5 months ago

  By: cnu1252

• Import access database

  Hello, I need to create a job that import an access database. Does exist a command that I can use t…

  sistemas_casinomnes

  6 replies

  11 years, 5 months ago

  By: sistemas_casinomnes

• Geometric Median / Weiszfeld's algorithm

  Does anyone have a function that determines the geometric function from a series of spatial points …

  busraker

  24 replies

  11 years, 5 months ago

  By: busraker

• Rows into Columns - remove duplicates and variable rows

  late edit.. title should say variable columns Hi Folks Thanks to the excellent Cross tabs article b…

  ldanks

  6 replies

  11 years, 5 months ago

  By: ScottPletcher

• Need to Create (or Insert) a Row for Every Calendar Month.

  I have a Table with Financial Data in it and for Certain Accounts (the Key Field is actindx Column…

  jameslauf

  3 replies

  11 years, 5 months ago

  By: jameslauf

• Working with Image,text,binary datatypes

  Hi Mates, I have a requirement to export the blob(image)file, excel and word documents that are sto…

  vamsi2.k

  2 replies

  11 years, 6 months ago

  By: Lowell

• Help needed in Joins

  I have a table that contains student ids that have been assigned to 2 teachers as reader1 and read…

  amar_kaur16

  1 replies

  11 years, 6 months ago

  By: mickyT

• seeking advice: is #temp table for calendar days-of-year possible for a sproc that supports a websites reporting needs

  Problem: (1) am disallowed to create a calendar table in database. (2)A sproc used at my company to…

  KoldCoffee

  5 replies

  11 years, 6 months ago

  By: ScottPletcher

• Select all CustomerID's where their last PaymentDate is more than 12 months ago

  Hi Guys, I have the following query: ;WITH CTE_LastOrder (CustomerID, LastOrderDate) As ( SELECT Cu…

  michaeleaton 36224

  5 replies

  11 years, 6 months ago

  By: ScottPletcher

• Using isnull in where filter

  Hey guys, I remember in the past using IsNull in a where filter of a stored proc that was used for …

  dndaughtery

  3 replies

  11 years, 6 months ago

  By: ScottPletcher

• CLR, RTF to Plain Text not working.

  Hey, Trying to troubleshoot an CLR/ RTF to Plain Text issue I am having. I have 3 instances on one …

  itpcpro

  2 replies

  11 years, 6 months ago

  By: itpcpro