T-SQL

• Topics

  Started by

  Posts

  Last post

• Automating the saving of DTS packages to .BAS format

  Does anyone know how to automate the conversion of all our DTS packages to the .BAS format? The clo…

  Carlos Urbina

  5 replies

  20 years ago

  By: Carlos Urbina

• Help with tables & SQL behind Matrix-like GridView

  Is there anyway to accomplish this sketch I created (http://www.webfound.net/graph_grid.jpg) in a G…

  dba321

  3 replies

  20 years ago

  By: Joe Contreras

• Is there any way to generate excel files by using T-SQL?

  Is there a function that generate excel files such as foxpro's?

  kpao

  4 replies

  20 years ago

  By: Joe Contreras

• Row To Column

  Please someone show me how to convert data from row to column: ex.  Product   &…

  joemai

  8 replies

  20 years ago

  By: RyanRandall

• unable to insert row into table with uniqueidentifier column

  I just inherited a system that uses merge replication, I am trying to insert some rows into a table…

  Chris Golla

  2 replies

  20 years ago

  By: Chris Golla

• Nested case statements

  Is it possible to write nested case statements. would somebody  please provide a sample statem…

  Prema sambandam

  2 replies

  20 years ago

  By: Prema sambandam

• combine all tables in a database with a union query

  Hi, all user tables in a database of mine have the same structure and i would like to combine then …

  Marcel Prosch

  9 replies

  20 years ago

  By: Marshall Smith

• Is more fater the execution of a store procedure?

  Hi friends, how are you?, well here in my work, my partners with me we were executing store procedu…

  Hector Angello Silva Carmona

  5 replies

  20 years ago

  By: Hector Angello Silva Carmona

• Need Update Statement for the following

  Hello All, First of all sorry for posting the same topic again. Actually previously I posted t…

  Niladri Kumar Saha

  2 replies

  20 years ago

  By: Marshall Smith

• How to filter out unwanted data

  I have the following fields in table A: Date     |  Descrip | Amt Dr …

  dave-318819

  3 replies

  20 years ago

  By: RyanRandall

• "CASE Function: it powers in theoretical and practical scripting?"

  I read BOL for CASE function (SQL Server Scriptings). But it seems the information is mentioned sho…

  johnsql-193053

  3 replies

  20 years ago

  By: Mike Prascak

• Error when creating a View

  When I try to create a view with the following sql an error message appears as ...... Server: Msg 1…

  Philip Sivyer

  2 replies

  20 years ago

  By: Vladan

• problems restoring logs & bak

  hi , i'm trying to restore logs & bak with tsql, but when for example when i type RESTORE LOG …

  Sergio Campos

  1 replies

  20 years ago

  By: Kenneth Wilhelmsson

• adding a column where data required is "next row date field"

  example ....... There are two tables one is called oc and the second table is called issue. oc.oc_i…

  Philip Sivyer

  10 replies

  20 years ago

  By: Philip Sivyer

• how do i use rich text box editor on my website

  i want to put this rich text box editor on my website just like this site how can i do that,  …

  sukhoi971

  3 replies

  20 years ago

  By: sukhoi971