T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Create a view for Merged records

  Table Rowointer Notes ------- --------- Row0001 TestNotes1 Row0002 TestNotes2 Row0003 TestN…

  skb 44459

  4 replies

  11 years, 11 months ago

  By: Sean Lange

• Update record if master table record exist

  I want to update the PO table with the BuyerName if there is a Buyer record exist. In below example…

  skb 44459

  2 replies

  11 years, 11 months ago

  By: mayurkb

• Replacements for cursors

  Hi, I inherited a few stored procedures that use cursors to build create table statements, reading …

  sqldriver

  8 replies

  11 years, 11 months ago

  By: sqldriver

• adding line break changes execution plan

  Hi , I am confused I had seen a rather long query in SQL profiler its all on one line and I ran it …

  Edward-445599

  5 replies

  11 years, 11 months ago

  By: Jan Van der Eecken

• Need query assistance.

  Is there a way to structure a single query to select all the unique values from field 1 of table A,…

  RPSQL

  1 replies

  11 years, 11 months ago

  By: Gail Shaw

• LTRIM and RTRIM are not working

  SELECT * FROM [dbo].[REPORT_NOTES] AS Rptn results in one record. A column called INV_NUM with a va…

  SQL_Enthusiast

  4 replies

  11 years, 11 months ago

  By: Gail Shaw

• Insert dummy records

  I got asked to do this today, with some generic country data. Here's what I did: begin tran declar…

  sqldriver

  7 replies

  11 years, 11 months ago

  By: Jeff Moden

• Conversion failed when converting the varchar value '12.00' to data type int.

  DECLARE @mv_mark varchar(500), @ob_mark varchar(500), @tot varchar(500), …

  neethu payal

  7 replies

  11 years, 11 months ago

  By: neethu payal

• how can i select distinct values from 1 column in my query

  I would like to select distinct values from 1 column in my query. If I was selecting just 1 column …

  mrichardson 57577

  2 replies

  11 years, 11 months ago

  By: Phil Parkin

• DELETE based on one-to-many relationship

  I must be having a "senior moment" (no insult intended), because I just can't figure this one out. …

  SQL_Padre

  6 replies

  11 years, 12 months ago

  By: SQL_Padre

• Hierarchial Query Help Needed

  Create table TableA ( col1 int indentity(1,1), col2 varchar(10), col3 int ) insert into TableA v…

  kalikoi

  2 replies

  11 years, 12 months ago

  By: Sean Lange

• 2008 SQL Stored Procedure output to a pre-existing Excel 2003 spreadsheet

  I want to create a stored procedure where the output will to into an Excel spreadsheet that will ha…

  gpbyron

  3 replies

  11 years, 12 months ago

  By: Sean Pearce

• Emailing in HTML

  Hi All, I am trying to format an auto-generated email from SQL into HTML, i've sussed a bit of it …

  ghostiv

  3 replies

  11 years, 12 months ago

  By: Sean Pearce

• Brain lock...

  I have a table with schema that looks like this Year, Jan, Feb, Mar, Apr, May,June, July, Aug, etc.…

  jconaty54

  3 replies

  12 years ago

  By: Sean Lange

• Create index progress.

  Hi Freinds, Suppose i had started create/alter index process. how can i know remaining time to fini…

  Pravin Patel-491467

  2 replies

  12 years ago

  By: HARIANGEL