T-SQL

• Topics

  Started by

  Posts

  Last post

• Advice on Budget code

  Hi folks, I'd like to ask advice on the code below. I've created a budget report and for each month…

  cidr

  1 replies

  16 years ago

  By: arun.sas

• Need to add a FY Dates Table

  Hey all, I have been tasked with adding a table that stores all the dates for our fiscal years. I…

  marty.seed

  6 replies

  16 years ago

  By: LutzM

• Date and Time Selection Query

  Hi everyone, My database table has a time field called [time], Data Type of "Numeric" length of "9…

  frontpedal

  7 replies

  16 years ago

  By: frontpedal

• Getting correct results back from variable

  Hi there, I'm using the expression below to return only the month and year. I'm implementing this …

  cidr

  5 replies

  16 years ago

  By: GSquared

• Error Handling/Commit Transaction

  I have a proc that updates two tables. Table tOrderInfo has an Update Trigger on it.The trigger is …

  AVB

  5 replies

  16 years ago

  By: GSquared

• Using RowCount and Return within a Trigger

  I was purusing thru an old book I had and it had the RETURN Statement and @@RowCount used within a …

  AVB

  3 replies

  16 years ago

  By: GSquared

• Looping through the rows of a result set

  Hello, I would like to loop through the rows retrieved and capture the details of a particular colu…

  martin.edward

  18 replies

  16 years ago

  By: martin.edward

• trying to enable xp_cmdshell on sql 2000

  Trying to enable xp_cmdshell on sql 2000, but getting the following error: " The configuration opti…

  tan110

  3 replies

  16 years ago

  By: EdVassie

• How to retieve column info from a sql query (not table)?

  Hi, I'm looking for a way to retrieve the column info of a select query (I actually just need the s…

  Sascha Koenig

  5 replies

  16 years ago

  By: ssismaddy

• Get Total and Avg Values

  I have a test table as follows: create table #test (item varchar(10), period int, fYear int, to…

  David-155102

  9 replies

  16 years ago

  By: David-155102

• Update Table within CURSOR loop?

  Can someone tell me why this wouldn't work? What I am trying to do is take the data from one table …

  bwild

  10 replies

  16 years ago

  By: larry.eisenstein-820674

• If ... else statements

  Hello, When I run the following query if (select T0.AppObjType from oinm T0 inner join ibt1 T1 on …

  martin.edward

  4 replies

  16 years ago

  By: pradipcjain

• Relational update

  How to update via SQL 2000 if i have situation like this? update payment set Payment.OrderNo=Saleso…

  ridzuan_first

  1 replies

  16 years ago

  By: Garadin

• Distinct one column

  How do I make only loanid distinct? select l.loanid, l.branchoffice, l.AcquiredFrom, l.previouslnnu…

  krypto69

  12 replies

  16 years ago

  By: Garadin

• Create multiple rows from single input

  Given source data as follows: Start Date, Duration, EventID 2009-10-29 1XXX 2009-10-29 2YYY 200…

  Phil Parkin

  6 replies

  16 years ago

  By: Phil Parkin