T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• FOR XML clause - RAW / PATH / AUTO / EXPLICIT

  Hello sequel citizens, A day before yesterday I realized the scope of XML we have. I was working on…

  Abhijit More

  1 replies

  15 years, 1 months ago

  By: LutzM

• GROUP BY, PARTITION?

  I have the following table: ColAColBColC 72010 302010 302011 302012 72013 252013 720…

  mikeisace556

  3 replies

  15 years, 1 months ago

  By: mikeisace556

• Parse / join to related records in SMDR log file

  I have data from a phone system that is dumped into an SQL table. The phone calls come in two parts…

  Gary Herbstman

  4 replies

  15 years, 1 months ago

  By: Gary Herbstman

• SQL to split a non delimited string into delimited string

  I have a text string, say '12345', and I need to comma delimit each character in the string, i.e. '…

  Wolfmeister

  25 replies

  15 years, 1 months ago

  By: Lynn Pettis

• Subquery Error

  I have a table with a DateTime2 column named EndDateTime. I'm trying to subtract 1 second from all …

  BSavoie

  5 replies

  15 years, 1 months ago

  By: BSavoie

• Deprecation consternation

  :blush:Hi All The organization that I recently joined does almost all it's reporting off databases …

  GPO

  9 replies

  15 years, 1 months ago

  By: Ron McCullough

• save any file to pc

  hi all. I use below command for retrive varbinary column data and save to local pc,this command sav…

  elham_azizi_62

  1 replies

  15 years, 1 months ago

  By: Larry Kruse

• CASE Function

  Hi, Great forum and wonderful topics. I am new to T-SQL, but have experience with Access code. I …

  jfm3

  14 replies

  15 years, 1 months ago

  By: jfm3

• Get items in many to many relationship table

  background. First a user picks questions that relate to event that then gets saved in a many to man…

  Stubby Bunny

  1 replies

  15 years, 1 months ago

  By: Stubby Bunny

• how to sort cte hierachical data?

  hi there, i'm quite new to complex t-sql querys and want to solve following problem: this is a give…

  stefan.baerthlein

  9 replies

  15 years, 1 months ago

  By: GSquared

• CTE, join or ?

  I have a table that contains persisted data from the 'dm_os_performance_counters' view: CREATE TABL…

  SQLDCH

  3 replies

  15 years, 1 months ago

  By: GSquared

• i want simple example of using joins

  need simple example

  ramya.praba

  4 replies

  15 years, 1 months ago

  By: ghanshyam.kundu

• Insert & Update together based on ID

  I have a source table A in one database DB1 and destination table B in another database DB2 in the …

  PSB

  3 replies

  15 years, 1 months ago

  By: PSB

• know TSQL, need to learn PLSQL

  I'm just starting to write some queries using Oracle SQL Developer on a 10g database, and I'm findi…

  Rekonn

  8 replies

  15 years, 1 months ago

  By: Ninja's_RGR'us

• Calculating Total number of visits

  Hi All, I need help calculating the number of visits in the last 12 months, example data: CustomerI…

  DeJesus

  7 replies

  15 years, 1 months ago

  By: Jeff Moden