T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• displaying x y into 5x5 result set

  Hi there, I'm trying to display a grid on a webpage showing location.. I need a grid, broken out li…

  kevmck

  18 replies

  14 years, 5 months ago

  By: vinothraj

• Creating XML using Tsql

  Hi Everyone, I want to create XML file from sql table without using FOR XML EXPLICIT. Because I tri…

  krishusavalia

  5 replies

  14 years, 5 months ago

  By: RowanCollum

• Table Issue---Help

  I have a table that has two columns. 1. Name 2. CurrentDate Table :- Name Varchar (30) Current Dat…

  sqlquest2575

  6 replies

  14 years, 5 months ago

  By: sqlquest2575

• Audit SQL Job Changes - How?

  We are running SQL 2008 R2. Yes, I have tried Change Data Capture and SQL Audit , but I need more d…

  dbajunior

  2 replies

  14 years, 5 months ago

  By: dbajunior

• Time to be split in time slots...

  Hello, I stumbled upon this today while doing reports and thought of asking some help; Here is the …

  JackIntheBox

  11 replies

  14 years, 5 months ago

  By: Paul White

• Cross relationship.

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

  WangcChiKaBastar

  3 replies

  14 years, 5 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, 5 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, 5 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, 5 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, 5 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, 5 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, 5 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, 5 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, 5 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, 5 months ago

  By: TomThomson