T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Cross relationship.

  tableA OrgId ParentId 11 23 32 41 51 how do I diplay r…

  WangcChiKaBastar

  3 replies

  14 years, 2 months ago

  By: WangcChiKaBastar

• Getting DATEDIFF from 2 separate rows...

  Hey guys... Here is how my table looks: SSN | Contract_Number | Effective Date | Term Date 111-11-1…

  asm1212

  3 replies

  14 years, 2 months ago

  By: asm1212

• SP- executed with more wait time and memory using

  Hi, I have attached execution plan, could anyone suggestion where is the particular issues? Thanks …

  SQL Galaxy

  3 replies

  14 years, 2 months ago

  By: Gail Shaw

• updsate query

  Hi friendsI always required to update one column which contains path. eg. Myfolder/folder/dialy/201…

  abhas

  1 replies

  14 years, 2 months ago

  By: Adi Cohn-120898

• aggregation, group by clause, need help tweakng query

  Will someone please show me how to tweak this query so that cus_code and associated "Total Purchase…

  xenophilia

  13 replies

  14 years, 2 months ago

  By: xenophilia

• aggregation, group by query - still learning - please help

  I am trying to modify an aggregated query slightly so that it provides one more column (called cus_…

  xenophilia

  4 replies

  14 years, 2 months ago

  By: xenophilia

• OPEN XML -- Help!!

  I've got an xml file with this format : <Policies> <Policy> <GroupUserName>BUI…

  Raikeru

  4 replies

  14 years, 2 months ago

  By: Raikeru

• Three table query problem in stored procedure

  Hi. I have a simple stored proc that is meant to return for each row in the first table, a count of…

  Forgotten SQL

  6 replies

  14 years, 2 months ago

  By: J Livingston SQL

• Best way to return a 1 or 0 for an if exists query

  what would be the preferred way to return a 0 or a 1 based on a result set, please? option 1 CREAT…

  Geoff A

  12 replies

  14 years, 2 months ago

  By: Paul White

• Compute table column based on other columns by month

  I have a table like this: CREATE TABLE #Test ( [InstNumber]VARCHAR(4) ,[GLLineNumbe…

  dcwilson2009

  12 replies

  14 years, 2 months ago

  By: TomThomson

• Recompile Features include at existing SP?

  HI, Option1: WITH RECOMPILE - only Stored Procedure Option2: Option (Recompile) - only SQL stateme…

  SQL Galaxy

  1 replies

  14 years, 2 months ago

  By: Mike John

• SQL about select records that has max count

  I have a query that wants to make a default orgUnitID to a Orgization. Basically I check to see whi…

  sqlfriend

  3 replies

  14 years, 2 months ago

  By: J Livingston SQL

• query XMLType

  Hi i have a tabel a lot of field AND with a XML field contining a xml. The xml look like following …

  peter_opglab

  1 replies

  14 years, 2 months ago

  By: Mark Cowne

• GROUP BY Problem

  I have a query which uses a CASE WHEN to calculate some value. Inside CAS..END, I have used some fi…

  meelan

  5 replies

  14 years, 2 months ago

  By: Manjuke

• Logic and Theory / Optimisation

  I've just optimised a query to run in 19 seconds rather than just under 5 mins. All I did was take …

  Rob-350472

  8 replies

  14 years, 2 months ago

  By: TheSQLGuru