T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• @@rowcount for use with UPSERT

  How can you justify doing an upsert (update, if not exist, insert) with the use of @@rowcount. I am…

  loki1049

  3 replies

  16 years ago

  By: scott.pletcher

• Struggling to calculate a percenatge value

  Hi. I am trying to display a value as a percentage. In the formula below the values calculated manu…

  2Tall

  3 replies

  16 years ago

  By: 2Tall

• Need help creating TSQL to indicate 'Multiple Jobs' in a one-to-many relationship

  If more than 1 JobID exists in my [GroupData,GroupDetail] one-to-many relationship, I need to show …

  sdorris-1150234

  3 replies

  16 years ago

  By: Eugene Elutin

• Decimal Separator / Language Setting

  Hi, In German the decimal separator usually is a comma ",". OK, I am already used to using the dot …

  Alexander G.

  3 replies

  16 years ago

  By: jan.nooitgedagt

• Need help on T-SQL

  I've as T-SQL as follow, declare @FromDate datetime set @FromDate='1/1/2011' declare @ToDate Dateti…

  miss.delinda

  6 replies

  16 years ago

  By: jcrawf02

• Passing a local variable to an Alter table

  Hi I have a list of tables that I want to alter. How can I pass a variable (table name) to an Alter…

  chris.murray58

  2 replies

  16 years ago

  By: Adi Cohn-120898

• Why should one use or not use Dynamic SQL

  Hello Everyone I am trying to gather some information about the use of Dynamic SQL, either from a f…

  AndrewSQLDBA

  11 replies

  16 years ago

  By: Eugene Elutin

• How do I reload Judges table?

  Dear all, For over 2 weeks now, I have resisted coming here for help again for 2 reasons. 1, I worr…

  simflex-897410

  48 replies

  16 years ago

  By: simflex-897410

• Select in CASE statement

  Is this possible? OraclePartNo = CASE WHEN Oracle_Part_ID IS NOT NULL THEN Oracle_Part_ID …

  CooLDBA

  2 replies

  16 years ago

  By: CooLDBA

• If Date value is less than current date set date value to today

  Hi. I have a DueDate field in a table. I would like to set this value in a SELECT to be the current…

  2Tall

  12 replies

  16 years ago

  By: scott.pletcher

• Selecting the earliest month wrapping January to December

  I'm stuck, Please help. I have a database with multiple month values per individual in a single tab…

  joefreeman

  68 replies

  16 years ago

  By: Paul White

• ss2k5 rounding v Excel

  I noticed Microcoft Excel seems to not really round-down, when you say format cells to 2 decimal pl…

  bime123

  3 replies

  16 years ago

  By: bime123

• UNPIVOT on mutiple columns

  Hi All, Please let me know can we include two columns in UNPIVOT query. Does any body have sample q…

  somansam

  1 replies

  16 years ago

  By: Eugene Elutin

• Allocation as a Set-Based Operation

  I have a program that attempts to estimate how items will be packaged into boxes based on a number …

  jvanderberg

  11 replies

  16 years ago

  By: Vladan

• Need to select data from 2 rows into one row depending on types

  Hi. I have a table with 5 columns, NAME, answertype(1=Yes, 2=No),amount of answers,YES, NO.. NAME …

  ulf.carlsson

  1 replies

  16 years ago

  By: LutzM