T-SQL

• Topics

  Started by

  Posts

  Last post

• Parsing question in T-SQL ---- PLEASE HELP!!

  Hi there, I need to parse a database field with following condition: i have a variable length field…

  moin6

  8 replies

  20 years ago

  By: Jeff Moden

• SUBSTRING a DATETIME value in a SELECT statement

  Hi all, I am having issues when trying to truncate a DATETIME column using the SUBSTRING() function…

  Trystan Hughes

  6 replies

  20 years ago

  By: Jeff Moden

• Using sp_executesql hangs up!!

  I'm dynamically creating my query and executing it with sp_executesql command. My problem is t…

  Claudia Navarro Gonzalez

  3 replies

  20 years ago

  By: don c-309367

• Error reported by COM object

  Hi, The following error is returned by a COM object while executing a stored procedure.  This …

  Prakash-205770

  2 replies

  20 years ago

  By: noeld

• Multi aggregation column CrossTab

  Hi, I have a view with the following columns Task, Quarter, Hours, Cost, EstHours, EstCost I need t…

  Richard Binnington

  5 replies

  20 years ago

  By: steve dassin

• Fully Qualified Names?

  Hello, I'm in a situation where I need to run querries from multiple servers. I need an example of …

  cdun2

  3 replies

  20 years ago

  By: cdun2

• OpenRowSet with parameters

  Inside a stored procedure, I'm trying to read in a csv file.  I'd like to be able to pass both…

  JMarx

  7 replies

  20 years ago

  By: JMarx

• If condition is not working properly

  Hi I have this if condition that invokes one stored procedure else invoke another.  However on…

  Joe Contreras

  7 replies

  20 years ago

  By: RyanRandall

• Performance difference between using IN CLAUSE and JOINS

  Hi, I have a query where I am retrieving data using the IN Clause. I am planning to rewrite th…

  Sridhar-137443

  2 replies

  20 years ago

  By: Gift Peddie

• Trigger SQL to UPDATE Only row being Updated

  Need to create a Trigger to UPDATE a tables DATETIME column to current DATE/TIME any time an UPDATE…

  Express12

  4 replies

  20 years ago

  By: Express12

• Altering a Column that has an Index on it

  Hi all, I seem to be having problems trying to Alter a table column (i'm trying to change its Data …

  Trystan Hughes

  3 replies

  20 years ago

  By: sushila

• Please help in Outer join

  Hi All The below query is (Old STYLE) working fine and also gived the desired result but the s…

  venkat-216866

  6 replies

  20 years ago

  By: venkat-216866

• TRIM Function in SQL?

  With VBScript, I use TRIM to take out the speces in a string value, what should I use with SQL? For…

  WooGor

  3 replies

  20 years ago

  By: Sergiy

• Table Lock on a Simple Update .. Using PrimaryKey as the only value in the WHERE clause // The whole table locks

  The short of it.. is that I have a table ... with a PrimaryKey   I'm doing a simple Upda…

  sholliday

  1 replies

  20 years ago

  By: Gail Shaw

• query i cant get my head round...

  can you help me create this query im having a problem, i cant quite get my head round it. i have a …

  ben potts

  4 replies

  20 years ago

  By: noeld