T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• CASE 'inside' COALESCE

  Hiya, I have the following statement; ISNULL(COALESCE(ap.ABP_Name,at.ABT_Name,sp.SKP_Name,st.SKT_Na…

  lanky_doodle

  3 replies

  15 years ago

  By: lanky_doodle

• money or decimal type

  Hi. i do a shopping site and i need to keep products' price. Which data type do i use? i think to u…

  sa.ordekci

  2 replies

  15 years ago

  By: Jayanth Kurup

• here is the smart question.............

  I have created two partitions on different columns for same table. I posted queries below ON Dateti…

  sqlmaverick

  1 replies

  15 years ago

  By: Steve Jones - SSC Editor

• Can anyone solve this question..PLZ

  I have created partition and scheme as shown below Create partition function platform_idPF(varchar(…

  sqlmaverick

  1 replies

  15 years ago

  By: Evil Kraig F

• How to insert row using another name

  Hello: I have table1 who has fields: name, dd I want to insert new name: Jenny, but use value of na…

  cc 80999

  3 replies

  15 years ago

  By: Robert Klimes

• Using OUTPUT INTO with an INSERT INTO

  I've found examples out there for everything except the one part I'm trying to do ... so I'm assumi…

  Putts

  1 replies

  15 years ago

  By: GSquared

• About partitioning....will any one help plz.......

  Hi, i am existing with below parti Create partition function archive_dtPF(datetime) as range ri…

  sqlmaverick

  2 replies

  15 years ago

  By: Steve Jones - SSC Editor

• Find variable length text string

  I have a variable length text field that is often populated with a string of constant charachters t…

  Howard C. BAchtel-438731

  8 replies

  15 years ago

  By: Mike John

• Query

  I have a table dbo.Listing ( Id VARCHAR(20), Location VARCHAR(255), [Status] VARCHAR(6) ) ID …

  PSB

  5 replies

  15 years ago

  By: PSB

• Determining last update to a table

  Hi, I have googled this to see how you can determine the last update to a table and they keep refer…

  dale_keller

  7 replies

  15 years ago

  By: GSquared

• Create a look up in SQL similar to HLookup in Excel

  Hi I'm trying to create a query to populate a new created column with values based on another colu…

  Jnrstevej

  14 replies

  15 years ago

  By: Orlando Colamatteo

• FURTHER GROUPING OF RECORDS

  This is essentially a follow up of my 2 previous posts. I am working on a migration project and kee…

  eseosaoregie

  2 replies

  15 years ago

  By: eseosaoregie

• Look like typical..............

  Can any one help me to create partition on existing table. I have seen so many examples and links …

  sqlmaverick

  1 replies

  15 years ago

  By: RTaylor2208

• Insert unique records from staging

  Hi, I have a staging table STAG Col1 Col2 col3 col4.... and a main table dbo.Main which have the …

  PSB

  5 replies

  15 years ago

  By: Jayanth Kurup

• one to many relationship in sql

  Hi I have a different situation. I would like to find out one-many relationship in my tables. Here…

  anitha.cherukuri

  2 replies

  15 years ago

  By: sanjay.kumar-853392