T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• May or may not have to use the pivot table for weekly compare data ?

  HI All..... I have a table" ProdSchedule Model Date upload Lot_qty Prod_Date AAA 2010-05-14…

  phina_el

  2 replies

  15 years, 7 months ago

  By: phina_el

• Help with Select query

  Here's the query I have so far. I don't want to specify a particular my_app_id. I want to do this…

  swingnchad1

  6 replies

  15 years, 7 months ago

  By: LutzM

• BULK INSERT failed on remote computer

  hi, When I run the following on the SQL server itself, it works (I am connected to sql using domain…

  egpotus

  1 replies

  15 years, 7 months ago

  By: Lowell

• Query Cost ~ USD $$$

  All, I have done lot of fine tuning work in sql2005. I just consolidated it in a spreadsheet and se…

  karthik M

  9 replies

  15 years, 7 months ago

  By: DB_Newbie2007

• Alter Table

  I have a table with a primary key. I need to create a query with a command alter table to add a col…

  sistemas_casinomnes

  1 replies

  15 years, 7 months ago

  By: Eugene Elutin

• Index on IDENTITY column

  All, I have seen lot of tables with IDENTITY column created with PRIMARY KEY. I am sure we shouldn'…

  karthik M

  24 replies

  15 years, 7 months ago

  By: Gail Shaw

• Selecting data relative to two Date columns

  Let's say you have an order table defined as: CREATE TABLE order ( order_number INT NOT NULLl, …

  john.delahunt

  10 replies

  15 years, 7 months ago

  By: john.delahunt

• Quotation

  I have written a stored procedure that updates data, it runs ok until it reaches the name Milly's. …

  clucasi

  3 replies

  15 years, 7 months ago

  By: Eugene Elutin

• Set a variable equal to an Execute?

  I have this Stored Procedure which works well. This with other lines allow me to call the Stored P…

  Ken at work

  5 replies

  15 years, 7 months ago

  By: ColdCoffee

• Inner join

  Hi All, I'm joining two tables to get the id name from another table the structure is CREATE TABLE …

  Anamika

  5 replies

  15 years, 7 months ago

  By: Anamika

• Concatenate 2 integer columns and check value in WHERE clause

  I'm trying to concatenate month and year columns and check the resulting date value to be greater t…

  bigclick

  5 replies

  15 years, 7 months ago

  By: shadow_2

• Passing many parameters to a stored procedure

  Hi. What is the most efficient way of sending/passing parameters to a stored procedure from ADO.NET…

  teck-1054678

  6 replies

  15 years, 7 months ago

  By: teck-1054678

• Need some help with SQL (group by and Select)

  Hi, I have an SQL question that I need an answer to. Assume 2 tables: Table 1 : "CDs" that holds '…

  taxali

  1 replies

  15 years, 7 months ago

  By: NewBeeSQL

• Getting most common value from several fields into one record

  Here's the example that I'm working with: CREATE TABLE #TestTable ( ID INT, Field1 VARCHAR(MAX),…

  kramaswamy

  12 replies

  15 years, 7 months ago

  By: Jeff Moden

• T-SQL query to exclude certain rows

  /* Need assistance in creating a T-SQL query to exclude certain rows: The idea is to calculate each…

  kevin_nikolai

  5 replies

  15 years, 7 months ago

  By: kevin_nikolai