T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Query Help

  Any help with the following would be greatly appreciated. Out of a particular table, Cust_Order_Lin…

  bpowers

  4 replies

  16 years ago

  By: bpowers

• Try Catch

  I have declared some variables on the top then I have try catch. Then after the catch I have an ins…

  doran_doran

  1 replies

  16 years ago

  By: GSquared

• Rolling back transactions for a paticular table

  Made updates to a table (SQL Server 2005) Would like to rollback those changes Doing log shipping …

  jparks-1090949

  4 replies

  16 years ago

  By: Bru Medishetty

• File move

  Hello- I’m attempting to create a SQL job that will move some files around and needing some advice.…

  igloo21

  9 replies

  16 years ago

  By: SQLRNNR

• list tables and columns referenced by functions, stored procs, views

  Hi All I'm looking for some TSQL that will look through all the user defined functions, stored proc…

  GOC-481399

  2 replies

  16 years ago

  By: Jack Corbett

• Update condition where numeric

  Hi, I have a problem with an update query. Table1 contains FieldA which can feature leading and/or …

  DerbyNeal123

  2 replies

  16 years ago

  By: DerbyNeal123

• record of updates

  I am running the following 2 sql's UPDATE dbo.adds SET code = dbo.format_chars(code) UPDATE dbo.a…

  newbie_sql

  8 replies

  16 years ago

  By: newbie_sql

• inconsistent record set using ROW_NUMBER() function

  Getting inconsistent record set While doing paging using ROW_NUMBER() function. Each time of execut…

  dbsiva-707412

  1 replies

  16 years ago

  By: Lempster

• Auto incrementing value in column per charge for each account number

  I have 2 tables I'm pulling data from. One is a table that logs charges on accounts and the other …

  J M-314995

  8 replies

  16 years ago

  By: Lynn Pettis

• Update Statement Joins

  How can I accopmlish the following? I want to update the Cust_Line_Del table based on information f…

  bpowers

  10 replies

  16 years ago

  By: bpowers

• If we do not know exactly which column to join to, can we use an or clause?

  Hi I have 2 tables - Table1 with columns RowID and TableID Table2 with columns RowID1, TableID1, Ro…

  namrata.dhanawade-1143388

  14 replies

  16 years ago

  By: ChrisM@Work

• Common Table Expressions

  so for example. I have the below. Is this the same basic principle as using an into #tablename and …

  BaldingLoopMan

  15 replies

  16 years ago

  By: Garadin

• To cursor, or not?

  I have a simple holding table thats populated with filenames from a directory and I'm wanting to cl…

  Dom Horton

  11 replies

  16 years ago

  By: Garadin

• Optimize Insert

  I need to insert into a table , and define the type of each reocrd depending on some conditions ( T…

  ansz5

  2 replies

  16 years ago

  By: BaldingLoopMan

• Allow other users to run SELECT while TRANSACTION is being run by one user

  Assume that a user U1 is running a transaction on a table T1. While the transaction is in process a…

  khatri03

  1 replies

  16 years ago

  By: Jack Corbett