T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Check constraint on multiple columns

  I have a case where if the Id field is a specific value, I don't want to allow null in another fiel…

  sqlpadawan_1

  4 replies

  11 years, 10 months ago

  By: TomThomson

• Group by performance FK / PK

  Hello all, I have something I can't explain, hope some of you can? We have a medium sized database …

  Peter Kruis

  14 replies

  11 years, 10 months ago

  By: ScottPletcher

• need to merge two tables

  Hi, I've One table that contains all current appointments booked as below. RNappt_idclinic_idder…

  harsimranjeetsinghwasson

  8 replies

  11 years, 10 months ago

  By: MMartin1

• Unintended Escape\Continuation Character, BackSlash, in Executed Variable?

  I was trying to see if there is any documentation regarding the backslash symbol "\" as a escape or…

  DB_Newbie2007

  5 replies

  11 years, 10 months ago

  By: Rudyx - the Doctor

• Trying to SUM row with Current Date to Row with "Last Month" Date

  Hello, I am trying to SUM a column of ActivityDebit with current Calendar_Month to a Column of Tria…

  jameslauf

  9 replies

  11 years, 10 months ago

  By: jameslauf

• MERGE Statement MULTIPLE INSERT into different tables

  Hello, Can we insert into multiple table using merge statement ? If not then what are the alternati…

  singhswat

  2 replies

  11 years, 10 months ago

  By: Umer Akram

• Multiple updates using a CTE

  Hi Everyone, Can anyone help me on writing this code using a CTE or any other method which do not u…

  ksrikanth77

  4 replies

  11 years, 10 months ago

  By: Lynn Pettis

• When Does Minimum not Mean Minimum?

  I've got an interesting little problem that's really puzzling me. I have two tables like those bel…

  Neil Burton

  4 replies

  11 years, 10 months ago

  By: Neil Burton

• Insert multiple values based on parameter

  Hi All, I need to write SP where user select SUN to MON check boxes. If user select Class A with su…

  abhas

  6 replies

  11 years, 10 months ago

  By: Hardy21

• Access EXCEL using OPENROWSET

  I'm trying to access Excel file from SQL Server management studio using OPENROWSET using the below …

  sql server developer

  9 replies

  11 years, 10 months ago

  By: J Livingston SQL

• Specifying Faiover partner in OpenRowset

  We have a database,which has been mirrored.Also,We have an application which uses OpenRowSet to con…

  Aspet Golestanian Namagerdi

  1 replies

  11 years, 10 months ago

  By: MG-148046

• Where clause Integer Greater than

  Hello! I'm not very technical on T-SQL so hoping this is an easy answer for someone. When I use the…

  Davebhoy

  11 replies

  11 years, 10 months ago

  By: Davebhoy

• Checking user's AD Group

  Is it possible to check for Active Directory group.. ie see if the user running the Stored Proc, is…

  dwilliscp

  6 replies

  11 years, 10 months ago

  By: benjamin.reyes

• Stored procedure with results

  Hi everyone I am new on the stored procedure area and I have created a stored procedure that return…

  phelisamoss

  4 replies

  11 years, 10 months ago

  By: phelisamoss

• calculate the sum of dates minus repetitive dates

  Hi experts, Today I have got one scenario to calculate the (sum of days difference minus(-) the dat…

  pmadhavapeddi22

  18 replies

  11 years, 10 months ago

  By: pmadhavapeddi22