T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Update one column for one table from another table

  I have to tables say 'employee1' and 'employee2' employee1 has lastname employee2 has firstname, la…

  susmitha117

  8 replies

  11 years, 10 months ago

  By: Sean Lange

• Problem with group by and order by

  Hi All, Iam having below schema. CREATE TABLE #Turnover ( location varcha…

  abhas

  5 replies

  11 years, 10 months ago

  By: rahulrathore.1986

• Report Non-existant child rows

  I am trying to get a "Zero Values" report. The following code works except when there is no child r…

  LinksUp

  5 replies

  11 years, 10 months ago

  By: LinksUp

• Default INT Parameter in SP

  Hi, in a StoredProc I want depending on whether a parameter is passed formulate the Where clause ac…

  info 58414

  3 replies

  11 years, 10 months ago

  By: Sean Lange

• Bulk insert - Code Page for French_CI_AS collation

  Hello, I am trying to insert a csv file into a table using Bulk Insert , but all special(french) ch…

  ralu_k_17

  4 replies

  11 years, 10 months ago

  By: ralu_k_17

• Minimum datetime value

  Hi I am searching for t-sql code which the following criteria: If Column C3 = 1 then take this row,…

  info 58414

  6 replies

  11 years, 10 months ago

  By: ChrisM@Work

• Repopulating a sequenced column that has gone out of sequence.

  We have an application which has had a big design floor and is now causing an issue which needs to …

  Maddave

  16 replies

  11 years, 10 months ago

  By: Maddave

• Best way to write a Search Query

  So I've been charged with rewriting a very horribly written Stored procedure which is being used to…

  Byzza

  7 replies

  11 years, 10 months ago

  By: Byzza

• Calculating average

  Hi All, Please help me to calculate Average sal foe below scenario. I am having tables with 12 colu…

  abhas

  5 replies

  11 years, 10 months ago

  By: abhas

• Nested user-defined functions in tsql. Parameters passing trough INSERT-SELECT structures

  Hello, I have got two user-defined functions: fn_Top and fn_Nested. The first one, fn_Top, is struc…

  Newcomsas

  5 replies

  11 years, 10 months ago

  By: Cadavre

• If not exists returning false when should be true

  Edit: Actually title should be returns true when should false. Am I doing this all wrong? I want …

  Maddave

  13 replies

  11 years, 10 months ago

  By: Maddave

• Finding maximum value out of 5 different columns

  Hey Guys, How can we find maximum value on column level? Suppose we have table A wi…

  abhisheksrivastava85

  21 replies

  11 years, 10 months ago

  By: Evil Kraig F

• Counting Decimal Places in a float field

  I have a table with three columns: UniqID, Latitude, and Longitude. I need to write a query to ide…

  hughesj23

  7 replies

  11 years, 10 months ago

  By: Eugene Elutin

• APR Calculation NEEDED.

  I was hoping someone could help me with doing an APR calculation in SQL. I have Loan Amount, # of …

  murrabp

  4 replies

  11 years, 10 months ago

  By: Chris_M

• Need to add Balance of previous Row to Current Row

  Hello I am novice to intermediate writer of T-SQL. I need help with a query. Here is my current Que…

  jameslauf

  9 replies

  11 years, 10 months ago

  By: Alan Burstein