T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• UPDATE with multiple joins

  and I can't seem to find the correct syntax. UPDATE UPDTABLE SET updtbl_lat = i.infotbl_lat, updtb…

  roy.tollison

  4 replies

  11 years, 6 months ago

  By: roy.tollison

• Min/Max values using order by

  Hi folks, I have a product table that needs 4 columns updating using joins to 2 other tables. Colum…

  DerbyNeal

  1 replies

  11 years, 6 months ago

  By: Dwain Camps

• string splitting with charindex

  Hi i have the following field in a progress db which contains analysis codes for a given account. I…

  spin

  4 replies

  11 years, 6 months ago

  By: Dwain Camps

• Understanding REVERSE(STUFF(REVERSE... code

  Hello - I've got a lot of experience writing basic queries, but I've not come across the REVERSE(ST…

  Patrick Dooley

  2 replies

  11 years, 6 months ago

  By: Luis Cazares

• Manually increment smallint column during an INSERT command.

  Here is how the table is created... SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDI…

  roy.tollison

  4 replies

  11 years, 6 months ago

  By: roy.tollison

• Customer Purchase Incentive Validation in T-SQL

  Hello all - I would like your input on how to address this problem using T-SQL. I don't expect you…

  SQLSig

  4 replies

  11 years, 6 months ago

  By: SQLSig

• FOR XML EXPLICIT - One to many relationship at level 3 (3 = parent, 4 = child)

  I am trying to generate a one time export to send to a vendor. They are requesting XML and for one…

  SoCal_DBD

  4 replies

  11 years, 6 months ago

  By: Dwain Camps

• Logic question regarding inserting of rows from 1 table to another.

  at various times i need to copy the rows to another table but it has minor differences. table1 t1.…

  roy.tollison

  9 replies

  11 years, 6 months ago

  By: SqlBound

• Grouping data for more efficient data selection

  I have a table containing 50000 records. The fields are, Phase, KVA, Amt and Group. To begin with…

  SqlBound

  1 replies

  11 years, 6 months ago

  By: J Livingston SQL

• Output Query & Stored Procedure results to Text File with Headers (Pipe Seperated )

  Our users want a Dump of the SQL Data which could come by running Query and Stored Procedure every …

  skb 44459

  3 replies

  11 years, 6 months ago

  By: skb 44459

• INSERT avoiding duplicate error on multi-column unique index

  Got the insert part going just trying to figure out how avoid duplicate error. i have figured out h…

  roy.tollison

  4 replies

  11 years, 6 months ago

  By: LinksUp

• Am I blind here?

  Declare @SVPID int Set @SVPID = 0 Select SummaryTitle = Case When @SVPID = 0 Then 'All SVPs' Else D…

  halifaxdal

  2 replies

  11 years, 6 months ago

  By: halifaxdal

• remove leading 0's from a character string

  Hi, I have a character srting that has leading 0's,How can I get rif of those leading 0's from this…

  sql_learner29

  5 replies

  11 years, 6 months ago

  By: John Hanrahan

• Move file from one Directory to other

  Hi, I want to move file from c:\test1\test1.txt to c:\test2\test1.txt using FilesystemObject. I am …

  Dhananjay-440114

  14 replies

  11 years, 6 months ago

  By: Jeff Moden

• List job name which didn't run today but supposed to run today.

  Hi, I have one query.i face one issue almost every day. We have lot of scheduled jobs configured ,s…

  Alone

  2 replies

  11 years, 6 months ago

  By: juancabrer