T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Rounding computed columns on subquery

  Can someone explain this strange behavior to me? When I run this query: IF OBJECT_ID('tempdb..#Tab…

  Chi Chi Cabron

  2 replies

  15 years, 10 months ago

  By: Chi Chi Cabron

• Changing Non-ANSI Standard JOINS to ANSI Standards

  [font="Verdana"]if i have non-ansi syntax query as SELECT A.COL1, B.COL1, A.COL2, B.COL2 FROM A, B…

  Abrar Ahmad_

  4 replies

  15 years, 10 months ago

  By: Eugene Elutin

• Sorting with multiple columns using CASE

  Hi there, I've been searching the web and the forums for an answer to this problem, but can't seem …

  ThomasHess

  6 replies

  15 years, 10 months ago

  By: David Dubois

• Using composite key to update

  Hi , Here is the scenario . I want to update a table having 6 columns. I want to update a date col…

  Aspg

  13 replies

  15 years, 10 months ago

  By: Aspg

• SQL 2008 R2 convert styles running 90 database

  Hi guys, I have found some issue running a SQL 2005 database in a SQL 2008 R2 instance. the issue i…

  @fracionero

  2 replies

  15 years, 10 months ago

  By: @fracionero

• package to truncate and update data

  Hi, I need help in creating a package which copies data from one table in one database to another t…

  tripri

  2 replies

  15 years, 10 months ago

  By: tripri

• need to create process for db compare after migration

  Anyone have any advice here. i need to create a process to compare the differences between our diff…

  BaldingLoopMan

  1 replies

  15 years, 10 months ago

  By: Grant Fritchey

• Format varchar value to numeric

  Hi , I have ar Tarief column in temp table where data comes through SSIS .I want to insert this da…

  Aspg

  13 replies

  15 years, 10 months ago

  By: ColdCoffee

• sqlserver developer

  Hi, Any one can help me for how to prepare sql server developer certification exam thx.

  SVDURGA

  2 replies

  15 years, 10 months ago

  By: SVDURGA

• Cursor or While Loop - Do I really need to?

  Hi, I have a situation where I may need to use a cursor or while loop and trying with all my might …

  rellafella74

  1 replies

  15 years, 10 months ago

  By: Ben Teraberry

• Find the min and max effective date for when a value changed

  We have a table that stores all changes to a table based on some triggers. We're looking to do som…

  Tom_Hogan

  2 replies

  15 years, 10 months ago

  By: Tom_Hogan

• case condition

  my query is : Select distinct CoveNoteNo,ProposerName, convert(decimal(18,2),FinalPremium) as fina…

  scottichrosaviakosmos

  2 replies

  15 years, 10 months ago

  By: ChrisM@Work

• Embed the SPROC/script name in the SQL statement

  Write maintainable code - Embed the SPROC/script name in the SQL Statement Peter http://seattlewor…

  Peter Samson

  4 replies

  15 years, 10 months ago

  By: creditreports101

• how to copy tables in a particular order

  Hi, I got two databases named A and B A got tables like A1,A2,A3,A4 now i want to copy some tables …

  tripri

  3 replies

  15 years, 10 months ago

  By: Steve Cullen

• Hirerchy Query Help Required

  Hi Guys, I have an oracle background and now working on a project which is SQLServer based so stuck…

  joshtheflame

  6 replies

  15 years, 10 months ago

  By: Jeff Moden