T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Updating Base Table from a View of that Table joined to other Views

  Hi all. This might have been covered before but I was wondering if you can update the base table; i…

  r.pe

  4 replies

  17 years ago

  By: Elliott Whitlow

• Group Totals

  Greetings, I am still trying to master SQL. I am now at the point of trying to do totals ie aggreg…

  darryl-715744

  3 replies

  17 years ago

  By: Jack Corbett

• Convert Dynamic rows into columns of varchar type

  Hi, How to Convert Dynamic rows into columns of varchar type Name Content Value Test Column1 …

  rajeshsur

  2 replies

  17 years ago

  By: Florian Reischl

• Need to increment alpha field

  I'm trying to increment the last character of an alpha value by one - but can't for the life of me …

  iluvmyelement

  2 replies

  17 years ago

  By: dmc-608719

• Converting date time

  I am trying to convert a date field to last day of previous month but don't know how to drop the ti…

  tschuler-738392

  6 replies

  17 years ago

  By: Lynn Pettis

• Replacing misspellings in a string

  Hello: I'm working on standardizing address fields in a large contact database. I have a list of co…

  lk-681111

  8 replies

  17 years ago

  By: lk-681111

• How to Create Format File w/ BCP

  Hi, According to this web site SQL Server 2005 Integration Services - Part 45 - Bulk Insert Task an…

  MegaZord

  1 replies

  17 years ago

  By: MegaZord

• Alter procedure and useing "grant execute" in the same query window against it - REQUIRE GO?

  If I alter a procedure and tell SSMS to script out permissions and then have something like ALTER P…

  Maxer

  3 replies

  17 years ago

  By: Gail Shaw

• dynamic sql - string being truncated issue

  I have a string that is declared nvarchar(max). Once the string has been built the length is 4178.…

  TT-131210

  3 replies

  17 years ago

  By: TT-131210

• TSQL Search and Compare

  I have 2 tables each having same column but data in one column differs from the other. Ex tableA h…

  ishaan99

  1 replies

  17 years ago

  By: Lynn Pettis

• Retrieve comma-separated list within group by

  Hello folks, I have two tables TblGRINMaster and TblIssueNoteDetail. For one issue note, issuen…

  t.hitendra

  11 replies

  17 years ago

  By: t.hitendra

• Max 3

  Hi i want to select 3 highest Salary in a company. Suggest me a sql query.. my table is Emp_ID …

  manikandan-1115962

  3 replies

  17 years ago

  By: Pandian S

• search for ' in string column

  I have one varchar(string) column. I want to query that column for character ' (char(39)). like s…

  mayank jarsaniya

  3 replies

  17 years ago

  By: Mike_D

• View problem

  The view named Production.vExpensiveExpiredProduct do not succeed. I had confirm that the insert s…

  roderno_maraalaine

  1 replies

  17 years ago

  By: Adi Cohn-120898

• How to print each record in a result set?

  Hi all, I would like to print each record in the result set, is using CURSOR a proper approach? Exm…

  yaya1899

  4 replies

  17 years ago

  By: Anam Verma