T-SQL

• Topics

  Started by

  Posts

  Last post

• Need help for creating couple SQL queries

  Table: Students index# PK Name Surname Table: Exams index# subject# Grade Table: Subjects subject# …

  dejansoftware

  4 replies

  16 years, 2 months ago

  By: Gail Shaw

• Find data that has not changed for 5 days

  I have a requirement from a User to build a report that shows data that did not change for 5 days. …

  JMI

  9 replies

  16 years, 2 months ago

  By: JMI

• BEGIN TRANSACTION/COMMIT TRANSACTION in STORED PROCEDURE called from TRIGGER

  Trying to resolve a problem we do an update to a table has a trigger, that trigger calls an SP that…

  Brad Schroeder

  3 replies

  16 years, 2 months ago

  By: Brad Schroeder

• Using a subselect in an open query

  I'm having syntax error with the following openquery statement: UPDATE OPENQUERY(BHOBHT01, 'Update …

  swede

  10 replies

  16 years, 2 months ago

  By: loralei.riney

• BCP - SP returns multiple record set

  Hi All, I am having an SP which is like as follows, CREATE PROC dbo.Test AS BEGIN SELECT 1…

  rajasekar.x.jeyarajan

  1 replies

  16 years, 2 months ago

  By: J-F Bergeron

• Trying to use a CASE statement to derive name of column for query

  Hi there I have an sproc as follows: dbo.RB_UpdateSequence ( @ProdID int, @sequence int, @Modif…

  Lorna-331036

  2 replies

  16 years, 2 months ago

  By: Jon Campbell

• CASE Statements

  I have a table with many columns. 3 columns are to be used for determining what data can be viewed …

  netguykb

  1 replies

  16 years, 2 months ago

  By: Kruti Kansara

• Setting a variable of a different datatype equal to another.

  Declare @Contract_ID varchar(100), @Return_ID uniqueidentifier set @Return_ID = @Contract_ID …

  Faye Fouladi

  4 replies

  16 years, 2 months ago

  By: Faye Fouladi

• Oracle to TSQL - query question

  I have this query that runs in ORACLE and I wanted to convert this to run in TSQL under SQL server …

  SQLMAIN

  4 replies

  16 years, 2 months ago

  By: SQLMAIN

• Eliminate duplicate ID by concatenating string values from rows, where all columns except first one are dynamic

  I have a table as follow-: TranID Field1 Field2 1 f2 1f1 22f2 22f1 where field1, field2 a…

  naik.jo

  6 replies

  16 years, 2 months ago

  By: naik.jo

• Single Core Count Help Needed in T-SQL

  Dear Gurus Here is my scenario.... hmmm single call - count stockgroup IF CUSTOMER SAME BUT DIFF …

  Terri .K Wei

  2 replies

  16 years, 2 months ago

  By: Jeff Moden

• incorrect syntax error

  Here is my trigger :- set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER TRIGGER [insAssemblyParts…

  schauhan13

  5 replies

  16 years, 2 months ago

  By: Jack Corbett

• How to use if condition in where clause

  Hi Experts, select distinct assign.trainee_id ,trn.First_Name+' '+trn.Last_Name as traineeName,assi…

  Eswin

  1 replies

  16 years, 2 months ago

  By: Gail Shaw

• Query to call Stored Procedure repeatedly

  I am trying to reduce the size of a database for a development project and have created a table wit…

  maurine

  5 replies

  16 years, 2 months ago

  By: GSquared

• Creating column through T-SQL

  Is there any possibility to create columns through TRIGGER? I mean to say, if I have table name emp…

  mail2payan

  3 replies

  16 years, 2 months ago

  By: Daniel Smith-480684