T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Pivot the rows to columns

  Hi, I have data as below name code guid abc c.o.2 84B…

  SQLServerMS

  2 replies

  14 years, 10 months ago

  By: WayneS

• Index requirement on Join

  Hi, I have a query that I have tuned to some extent and from its earlier execution time of 15 secon…

  chandan_jha18

  10 replies

  14 years, 10 months ago

  By: chandan_jha18

• Insert Into vs Insert Statement Recompile in SQL Server 2008

  I have a one stored procedure which executes the t-sql statement using sp_executesql. This t-sql co…

  sherwincurt

  1 replies

  14 years, 10 months ago

  By: Gail Shaw

• question on join and max

  I have table1 with unique logid and table2 with multiple logid and timestamp. If do the left join,…

  ktlady

  4 replies

  14 years, 10 months ago

  By: ktlady

• Hierarchy using CTP & extra column for HasChildren?

  Hi, I am plannning to retrieve a Hierarchy stored in database. Please use the following structure f…

  CodeLake

  8 replies

  14 years, 10 months ago

  By: CodeLake

• Format a date so Excel can read it correctly

  I run a lot of ad hoc queries for others which I then copy into an Excel spreadsheet to send to the…

  brosspaxedi

  3 replies

  14 years, 10 months ago

  By: brosspaxedi

• Find all orders that have EXACTLY the same items

  create table orders( oid int, item int ) insert into orders (oid, itemid) values (1,1111) insert in…

  Todd Mathews

  28 replies

  14 years, 10 months ago

  By: Evil Kraig F

• Checksum vs Comparing each row

  Hi All, I wanted to know what peoples thoughts were on how best to identify SCDs. I prefer to use t…

  aaa121

  8 replies

  14 years, 10 months ago

  By: vishal.gamji

• Migrating T-SQL from SQL 2000 to SQL 2008

  Everybody, I have to migrate T-SQL stored procedures and functions from SQL 2000 to SQL 2008. Is th…

  lev.gurevich

  14 replies

  14 years, 10 months ago

  By: lev.gurevich

• Using DYNAMIC SQL to generate a custom CTE on the fly. A simple sol to sorting issues.

  I found an interesting issue that took a bit to debug whilst using dynamic sql to create a cte tha…

  sqlPirate_Fl

  3 replies

  14 years, 10 months ago

  By: Lamprey13

• Help with CASE

  Hi, Is it possible to do as follows: If Column1 = 0 then instead select the value from column2? Li…

  agh100

  6 replies

  14 years, 10 months ago

  By: Cadavre

• Stored Proc with dynamic table column

  Hi, RDBMS : sqlserver 2005 OS : windows I have to write a stored proc, for given below scenario T…

  thbaig

  11 replies

  14 years, 10 months ago

  By: Ninja's_RGR'us

• XML file using T-SQL

  Hello, I need to create a xml file with sub master tags. Below is the script. Please provide any he…

  UnionAll

  1 replies

  14 years, 10 months ago

  By: Mike01

• assistance with SQL (COUNT, GROUP BY, HAVING, etc...)

  Hi there, I am trying to create a report to audit parking permits. 3 tables to join. Now I understa…

  mmontero

  4 replies

  14 years, 10 months ago

  By: Ninja's_RGR'us

• Dynamically generating a MERGE statment based on table name

  Hi All, I wanted to know if anyone has managed to do the above? Generally I try to avoid dynamic SQ…

  aaa121

  3 replies

  14 years, 10 months ago

  By: GSquared