T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Null Values are not being accepted

  Hi All, I have the following Stored Proc. If I pass a valid value for the @ABIClass variable, I rec…

  william_crawley

  2 replies

  14 years, 12 months ago

  By: Johan Bijnens

• DB2 Open Quey : Read Uncommitted data

  I have a simple link server accessing a mainframe DB2 database. Select * from OpenQuery(DB2_SAMPLE,…

  v.vinesh

  3 replies

  14 years, 12 months ago

  By: Henrico Bekker

• Group By

  Hi: I have a query that return data in 8 columns. I need to group then, depend on parameter pased t…

  Alejandro Alberini

  5 replies

  14 years, 12 months ago

  By: Alejandro Alberini

• searching for Space in a string

  Hi All, declare@posStart int, @BuildStr varchar(max), @OccupationFilter varchar(50) set @Occu…

  william_crawley

  4 replies

  15 years ago

  By: WayneS

• SUM of a column in output table

  Hi, Can some one help in solving this...... hav a query and output as select input_file, rec_cnt,…

  gnaneshs

  4 replies

  15 years ago

  By: gnaneshs

• Coerce SQL Server to use HASH JOIN physical operator for ANTI SEMI-JOIN logical operator

  SQL Server 2005 Enterprise Hi I have a problem with a query. This query is on a read only (log ship…

  hallidayd

  7 replies

  15 years ago

  By: Gail Shaw

• Update trigger is not working

  Dear All, I have created the below trigger on a main table and we have exact schema of main table a…

  Gangadhara MS

  7 replies

  15 years ago

  By: Vedran Kesegic

• Calculating balance from previous row

  xx

  SQL006

  2 replies

  15 years ago

  By: Abhijeet Chavan

• t-sql

  For 'selected' stored procedure(s) in 'selected' databases, I would like to know the t-sql statemen…

  wendy elizabeth

  7 replies

  15 years ago

  By: WayneS

• how to add data into these two tables

  USE [SSISDB] GO /****** Object: Table [dbo].[Table_2] Script Date: 12/26/2010 18:10:23 ******/…

  malleswarareddy_m

  6 replies

  15 years ago

  By: tfifield

• Now Do You Break The Data When Using A Group By Clause

  Hi Folks I cannot figure out what I need to do in my T-SQL to break the data Example output: Projec…

  JC-3113

  2 replies

  15 years ago

  By: GSquared

• change schema for stored procedure

  Hello I have a bunch of stored procedure(more than 200) in my database. I have to change the schema…

  manoharanpraveen

  2 replies

  15 years ago

  By: VSSGeorge

• Bulk Inserts

  I have a project where i need to bulk insert a log test file into my table. That works great. howev…

  purplebirky

  1 replies

  15 years ago

  By: Jeff Moden

• Trying to Trim Words From a String

  I have a table that has a column with employee names and who they report to. Example: Jane Doe repo…

  ducksql@gmail.com

  5 replies

  15 years ago

  By: GSquared

• COUNT(CASE THEN (COUNT DISTINCT)) ?

  Hi, I have problem to code what i want to. Please find attached my table and also the result i want…

  apnw7931

  3 replies

  15 years ago

  By: apnw7931