T-SQL

• Topics

  Started by

  Posts

  Last post

• Cannot Select the max of an alphanumeric column

  Hi. Well, I think this is my very first post to SCC...and it's kinda long - sorry about that...I wa…

  Dan Peerenboom

  3 replies

  15 years, 7 months ago

  By: spaghettidba

• Selectively update one row

  Hello: I am working on exporting a legacy billing system into Microsoft SQL Server 2000.  Ther…

  Brian Lich

  3 replies

  15 years, 7 months ago

  By: Sergiy

• Left join versus *=

  Hi all, wondering if someone could please explain to me how / why I'm seeing this... We have a SQL …

  darth.pathos

  2 replies

  15 years, 7 months ago

  By: darth.pathos

• CASE in the WHERE clause

  Hi, I want to apply a conditional where criteria depending on the evaluation of two dates, but can'…

  Ulysses_Infinity

  1 replies

  15 years, 7 months ago

  By: vaibhav.tiwari

• Incorrect syntax near the keyword 'IF'.

  Incorrect syntax near the keyword 'IF'. I'm a new SQLServer DBA while trying to wite the code below…

  mashikoo

  7 replies

  15 years, 7 months ago

  By: Garadin

• Help, question on returning two addresses from the same table in one record

  Hello, I have a question, im having problems returning data in a single record from a single table.…

  chris.kastavunis

  8 replies

  15 years, 7 months ago

  By: bykerbytch

• Indexing partitioned views (or improve performance)

  I have created the following view: Create   VIEW dbo.TD_EMP_Assignment AS SELECT [EM…

  Bryan P. Clauss

  7 replies

  15 years, 7 months ago

  By: Sergiy

• Bulk Insert problem

  So, this one has me entirely baffled. I have a process which is bulk loading data files to a table,…

  David Lester

  3 replies

  15 years, 7 months ago

  By: Sergiy

• Output columns from lowest to highest in a pivot type query help

  I have a query (SQL 2000) which works fine: Select sum(case when a.[Month] = 1 then ([Avg Balance]…

  newmang

  5 replies

  15 years, 7 months ago

  By: Jeff Moden

• Optimizing Remote Scan with Linked Server

  The following result in a ridiculously slow remote scan: UPDATE [RemoteSQLServer].[Remote].[dbo].[I…

  Karl Kieninger

  3 replies

  15 years, 7 months ago

  By: Garadin

• Generic Audit Trigger

  Hi All, SQL Server 2000   Could someone please help me with the following…   I need to pr…

  Charlottecb

  31 replies

  15 years, 7 months ago

  By: Jeff Moden

• What SQL or Stored Procedure is Running? SS2K

  Hi! I inherited a SS2K database that is the back end to a COTS web application. We are having diffi…

  Tom Carnahan

  15 replies

  15 years, 7 months ago

  By: Tom Carnahan

• Insert - Exec Select statements

  Hi all, I have a difficulty in this piece of code inside a stored procedure. .... .... SET NOCOUNT …

  renu.iitkgp

  4 replies

  15 years, 7 months ago

  By: Garadin

• equivalent of DateSerial() in T-SQL? (SQL2000)

  Hi, I need to calculate the last day of the month in a stored proc--any month. In VB, I do this wit…

  Adam O'Neil

  11 replies

  15 years, 7 months ago

  By: Ian Yates

• Help with a T-SQL Script

  Hello - I'm in the process of using a script that will help with re-indexes. I keep getting the fo…

  david.ostrander

  5 replies

  15 years, 7 months ago

  By: Garadin