T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Splitting a Full Name

  I'm trying to split a full name column up into First / Middle / Last....but some of the names are l…

  brickpack

  15 replies

  6 years, 10 months ago

  By: Chris Wooding

• Date error in query

  Hi; I am trying to get all objects created and or modified during last week, but instead the query …

  Orestes

  3 replies

  6 years, 10 months ago

  By: Orestes

• .nodes.value showing as invalid object in sq; server 2008 r2

  Hi, I have a requirement to convert columns to rows in a dimension table load process.I have put to…

  david_h_edmonds

  1 replies

  6 years, 10 months ago

  By: david_h_edmonds

• Left Join madness

  Hi I'm trying to figure out a "simple" join that's got me going in circles.  I'd joining on tw…

  gjoelson 29755

  9 replies

  6 years, 10 months ago

  By: Lynn Pettis

• Extract string between delimiters

  HI I want to extract string between the delimters where data is as follows: abc_def_cet_qwe o…

  sanjay831

  11 replies

  6 years, 10 months ago

  By: Jeff Moden

• Identify Deals Sold by W2 Employees Only

  For this example assume a company has both W2 and commission employees. What I'm trying to identif…

  texpic

  6 replies

  6 years, 10 months ago

  By: John Mitchell-245523

• Strange Replication Initialize a Transaction Replication from a Database Backup

  Hi All Many thanks in advance for any info provided 🙂 I have tried this out on our DEV enviroment f…

  Northern Monkey

  5 replies

  6 years, 10 months ago

  By: Sue_H

• Split comma delimited field?

  Hi I have a field that is comma dellitted (text1,text2,text3)Id like to split the field into separa…

  jbalbo

  20 replies

  6 years, 10 months ago

  By: Jeff Moden

• Using Current and Previous Row of a Group of Data to Identify Status

  Hi there I have the following sample dataIF OBJECT_ID(N'TempDB.dbo.#OutputTable')   …

  Weegee2017

  2 replies

  6 years, 10 months ago

  By: Jonathan AC Roberts

• Convert Local Time to UTC

  Is there a good way to convert a local time to UTC time? I expected to find some sort of built in c…

  BSavoie

  8 replies

  6 years, 11 months ago

  By: ScottPletcher

• sp_RefreshSQLModule run on a view completely changed the view definition

  SQL Version:Microsoft SQL Server 2008 R2 (SP3) - 10.50.6000.34 (X64)     Aug 19…

  TangoVictor

  11 replies

  6 years, 11 months ago

  By: x

• Storing Spatial Data

  Hi All, I work with geospatial specialists who provides me with polygons which i save it to my geog…

  krishna.kumar

  8 replies

  6 years, 11 months ago

  By: Eirikur Eiriksson

• Help on query

  Hi everyone, I was trying to make a query that gives me all the row where Key's relationship isn't…

  mbichari

  11 replies

  6 years, 11 months ago

  By: Jonathan AC Roberts

• Initial size of the database file using T-SQL

  Hi, Please let me know how to get the initial size of the database file using T-SQL. sys.master_fi…

  karthik.catchme

  5 replies

  6 years, 11 months ago

  By: Lawrenc450

• calling a PHP page from SQL

  Hi,Is it possible to call a php (or any web) page from SQL?I have to create a script that will call…

  EamonSQL

  4 replies

  6 years, 12 months ago

  By: EamonSQL