T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Unable to login users

  It is an 8 years project.I am working on this project since 1 year.ther is a stored procedure to ve…

  suresh0534

  3 replies

  12 years, 9 months ago

  By: suresh0534

• Difference between cross apply and outer apply

  Based on http://technet.microsoft.com/en-us/library/ms175156%28SQL.105%29.aspx, the difference betw…

  _simon_

  1 replies

  12 years, 9 months ago

  By: Sean Lange

• If Update() in a trigger

  I have a question that I thought I knew the answer to but I am now not sure. When in a trigger, su…

  dean.giberson 64357

  6 replies

  12 years, 9 months ago

  By: Gail Shaw

• Selecting Query Takes so much time

  This is structure of the Table. CREATE TABLE [dbo].[recent_items]( [id] [int] IDENTITY(1,1) NOT NU…

  suresh0534

  3 replies

  12 years, 9 months ago

  By: Grant Fritchey

• Unpivot Help

  This should be easy but I'm not getting this to work. I have a number of rows that look something l…

  rburko

  9 replies

  12 years, 9 months ago

  By: Dwain Camps

• Dropping indexes

  Hi All, I need to drop indexes on a table over 500mil records, I wandering is it better to drop the…

  Catcha

  8 replies

  12 years, 9 months ago

  By: Catcha

• Combine 2 queries into 1 output

  I have 2 queries and I need to add them together to get 1 row of data for each invoice_no, order_no…

  turkey-500673

  2 replies

  12 years, 9 months ago

  By: turkey-500673

• Using a variable as a field name - Syntax question

  I'm trying to use a variable but don't understand the syntax. I'm following the suggestions from t…

  Kaminskit

  5 replies

  12 years, 9 months ago

  By: GSquared

• Problem with BULK INSERT

  I'm trying to use the BULK INSERT statement to populate some table from a TXT file. In the TXT file…

  FelixG

  4 replies

  12 years, 9 months ago

  By: RBarryYoung

• Minimum Value 3 Fields > 0

  This seems like it should be easy but I can't seem to come up with a simple formula. Need the mini…

  texpic

  16 replies

  12 years, 9 months ago

  By: raghava_tg

• Update using Max() value on multi join query

  Hi, I have a problem where I need to update a table (Results). The one thing I can't get my head ar…

  DerbyNeal

  1 replies

  12 years, 9 months ago

  By: ChrisM@Work

• Need a SQL query to list the table names used in a view.

  Dear All, I have a view with 7 to 9 tables and it is running slow so i need a query to list all the…

  neellotus07

  10 replies

  12 years, 9 months ago

  By: Jeff Moden

• How to get week of a mont with input parameter date.

  Hi, i have a question, How to get First week of a actual month? In my procedure i will send a param…

  xRafo

  12 replies

  12 years, 9 months ago

  By: Jeff Moden

• Puzzle

  Step:1 CREATE TABLE tbl_Group_Test ( _ID INT IDENTITY, _Place VARCHAR(50), _Name VARCHAR(100) ) St…

  Anju Renjith

  2 replies

  12 years, 9 months ago

  By: rhythmk

• Table update using a hierarchy

  Hi I need a table updating using a lookup. In my example, Table1 has 3 AccType columns which need t…

  DerbyNeal

  1 replies

  12 years, 9 months ago

  By: Mark Cowne