T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• TRIGGERS

  Hi all, I am new to tsql .i need to write trigger based on source table and rules. My source table…

  maheshkrishnas

  5 replies

  14 years ago

  By: Dwain Camps

• Column value to a Cell of Table

  Hi, I have a table like, Invoice No Vendor 1 vendor 1 2 …

  farrukh635

  4 replies

  14 years ago

  By: farrukh635

• I am using temporay tables instead of table variables and cte in stored procedure would this be ok if 2000 users run the same stored procedure at the same time

  I am using temporay tables instead of table variables and cte in stored procedure would this be ok…

  Sarsoura

  3 replies

  14 years ago

  By: Ron McCullough

• Why Is one XML import so much faster

  Hi, need help with understanding the mechanisms involved in these 2 queries which accomplish the sa…

  Edward-445599

  5 replies

  14 years ago

  By: Edward-445599

• a very COMPLEX aggregation query

  I need to capture two statistics: 1) The total count of legal Case_IDs that take <30, 30-60, and…

  polkadot

  59 replies

  14 years ago

  By: Jeff Moden

• insert into table variable

  DECLARE @Table TABLE( [ID] int, [CostA] real, [CostB] real, [CostC] real ) INSERT INTO @Table E…

  riya_dave

  32 replies

  14 years ago

  By: Lynn Pettis

• just curious

  hi this is just question to know. in my cursor i am giving condition like(@maxdate =null) it was no…

  riya_dave

  25 replies

  14 years ago

  By: ColdCoffee

• return multiple columns based on single CASE evaluation

  Is their a slick way that I can check the condition of a field and return multiple discrete fields …

  jwmott

  8 replies

  14 years ago

  By: jwmott

• HOW TO USE DBCC COMMAND FOR SCRIPT TABLE

  HI I want to script a table with data using query wise. if its having any possible to script the…

  er.rajesh89

  7 replies

  14 years ago

  By: Lynn Pettis

• comparison operator for number values?

  Two part problem: (1) For validation purposes need to compare returned int values of result set wit…

  polkadot

  14 replies

  14 years ago

  By: mtassin

• Adding Computed Column

  Below is an example of a script I have, which works fine. However, I would now like to multiply the…

  bpowers

  10 replies

  14 years ago

  By: bpowers

• Prepare data for binding to chart

  Hi all, I have a table with this structure : CREATE TABLE dbo.tblStuffPriceHistory ( sphI…

  farax_x

  1 replies

  14 years ago

  By: spaghettidba

• Aggregating at Different Levels

  It seems that my brain has eroded over the week, because I can't think how best to do this. I am ag…

  Phil Parkin

  2 replies

  14 years ago

  By: Phil Parkin

• How to transfer data (from one column) from one table to another table? Please help.

  Hello SQLCentral.com members and administrators, A greeting of peace. I want to ask help because I …

  marksquall

  11 replies

  14 years ago

  By: OTF

• replace function

  hi, i am using replace function. giving me error like 'Error converting data type nvarchar to float…

  riya_dave

  23 replies

  14 years ago

  By: Sony Francis @EY