T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• SQL Query for calendar connected table result

  I want to write SQL query that, when given a month of the year, will return a table with eventID as…

  dan-737342

  3 replies

  14 years, 1 months ago

  By: dan-737342

• Update using subquery help!

  Hi all, I'm trying to update a table using a subquery. when I run the below script I get an error M…

  bighow2008

  14 replies

  14 years, 1 months ago

  By: jshahan

• Last day of last year

  hi, i want last day last year,what is the function for that. example if i put date 02/29/12 the i …

  riya_dave

  16 replies

  14 years, 1 months ago

  By: riya_dave

• Fairly complex update/delta logic using T-SQL, best approach?

  Hi folks, First of all, hello SQLServerCentral users. I have been a member for some time but this i…

  spgainham

  5 replies

  14 years, 1 months ago

  By: MVDBA (Mike Vessey)

• Update column to another column using condition

  I have a table that looks like the following: I want to be able to update the trendValue column ba…

  djhorn

  1 replies

  14 years, 1 months ago

  By: Eugene Elutin

• Error performing Count Text Data Column

  I execute the following Statement: Select 'DATED_TEXT','DATED_TEXT_RTF',DATED_TEXT_RTF, count(*) …

  Welsh Corgi

  15 replies

  14 years, 1 months ago

  By: Eugene Elutin

• Convert Code to Common Table Expression

  I wrote some Stored Procedures using CTE but not that much. How could I convert the code below to C…

  Welsh Corgi

  30 replies

  14 years, 1 months ago

  By: Welsh Corgi

• rows to columns

  I have the following sample data: create Table dailyLog( logId int, name varchar(100), date da…

  chandrika5

  6 replies

  14 years, 1 months ago

  By: chandrika5

• SET or SELECT to assign a default value to a nullable variable

  What is best way to write this statement? 1) DECLARE @L_ZERO INT SELECT @L_ZERO = IdMyTable FROM My…

  Alexeins

  9 replies

  14 years, 1 months ago

  By: Loundy

• SomersD and Statistical analyses

  Hi All, I've been googling like crazy for an approach to calculate SomersD statistic on data sets. …

  Michael G

  3 replies

  14 years, 1 months ago

  By: Michael G

• Many to one TOP N UPDATE troubles

  Hoping the gurus here can offer some advise here. I need to update a field ( Age ) in Table_1 base…

  AlAndrew

  13 replies

  14 years, 1 months ago

  By: Paul White

• Next Previous and current rows

  I am trying to create a stored procedure where i would like to fetch the next previous and current …

  namanthakral

  6 replies

  14 years, 1 months ago

  By: Dwain Camps

• Assign ungrouped terms to "Other" either in query or related table?

  I have created a table that will assign several activities in my Primary table into four groups (ru…

  chornung

  2 replies

  14 years, 1 months ago

  By: Dwain Camps

• Import from .bcp, .cft & .dri files

  Hi Guys, I've received a set of files. The files can be grouped, with 3 files per group. For exampl…

  diamondgm

  1 replies

  14 years, 1 months ago

  By: Dung Dinh

• parse string

  i need to parse a string like [p]a]a]s]s][p when a [ sign occurs then next letter need to be conv…

  pnpsql

  27 replies

  14 years, 1 months ago

  By: Dwain Camps