T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Calling function on select statement

  select col1, col2, col3, dbo.fun1(col1,col2) from tb1 function returns a string value with comma s…

  muthukrishnan.e

  9 replies

  13 years, 6 months ago

  By: ChrisM@Work

• In case of multiple matches for a key in a join , which value is updated ?

  HI All Below is the scenario : create table #test2 (j int,i int ,k char(1) ) create table #test3 (…

  koustav_1982

  2 replies

  13 years, 6 months ago

  By: Gail Shaw

• Add Minute

  Hi, I've got quite an unusual question. I'm running this simple query: SELECT SourceHub, Snap…

  kapil_kk

  6 replies

  13 years, 6 months ago

  By: Jeff Moden

• Query SQL version across estate

  Hi - I am wanting to query the SERVERPROPERTY of all out SQL servers and put the information in a t…

  Kwisatz78

  1 replies

  13 years, 6 months ago

  By: Steve Jones - SSC Editor

• Foreign Key Question

  If I have a table T1 with colA, ColB, ColC combined as primary key and another table T2 onant to de…

  sqlnaive

  11 replies

  13 years, 6 months ago

  By: sqlnaive

• Sending Mail

  How to send a mail through Storedprocedures with out using system stored procedures _______________…

  kapil_kk

  3 replies

  13 years, 6 months ago

  By: Lowell

• Change Data Capture 2008

  I have enable the change data capture on db and enabled one table and i made updates on couple of r…

  Mvs2k11

  4 replies

  13 years, 6 months ago

  By: Jason-299789

• char(??) vs varchar(??)

  Hi all. I have a database with over 200 tables. They all use char(xx) instead of varchar(xx). I…

  mike 57299

  10 replies

  13 years, 6 months ago

  By: kapil_kk

• Some way to write an INNER JOIN, but joining on either of two columns

  Hi, Each doctor in my doctors table has a main zip code and an alternate zip code. SELECT D.* FROM …

  matt6749

  8 replies

  13 years, 6 months ago

  By: matt6749

• Getting Year-Over-Year growth data

  I've a SQL query that returns the TotalMemberCount for the past 5 years on a yearly basis. Now I w…

  sql5322

  3 replies

  13 years, 6 months ago

  By: Dwain Camps

• Partitioning on a computed column (int based)

  I am trying to implement Search functionality using the partitioned table concept. Every search tha…

  charles99

  5 replies

  13 years, 6 months ago

  By: Evil Kraig F

• Inventory Report

  My database with the following table: ITDetail Table InvTrans Table Currency Table Database Rela…

  manhthao.dn

  1 replies

  13 years, 6 months ago

  By: T_Dot_Geek

• A maths puzzle for anyone up for a challenge!

  Hi, I've been given the task of creating a single unique numerical value from two composite unique …

  webtekkie

  33 replies

  13 years, 6 months ago

  By: Cadavre

• Alphanumeric number generation

  Hi, I need to write a SQL query to print the following aphanumberic sequence in SQL 2008. 0001, 000…

  Minnu

  26 replies

  13 years, 6 months ago

  By: Dwain Camps

• Get last row based on duplicate column

  I have a table that contains: userid email name 1 a@a.com Bill 2…

  jamie_collins

  6 replies

  13 years, 6 months ago

  By: Evil Kraig F