T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• join data on strings

  I have following values stored in the table1 and table2 table1.column1 - "US aliance - data" table2…

  pri_sql

  9 replies

  15 years ago

  By: pri_sql

• SUBSTRING Question?

  Can someone please help! I'm having an issue with a query. It's using a SUBSTRING but I think there…

  dustin.walker

  4 replies

  15 years ago

  By: dustin.walker

• Capturing Non-Null Column Names and Values Per Group

  Hi, Wonder if anyone can help. We are migrating an old application to a new one. The old applicati…

  steve 19850

  3 replies

  15 years ago

  By: steve 19850

• Function

  Hi everybody, This is really complicated and i need your help Create a function named loadQueryRes…

  daveriya

  7 replies

  15 years ago

  By: chris.stuart

• When not to like LIKE

  I ran into an interesting challenge during some stored proc testing last week. While watching the …

  sqlpadawan_1

  4 replies

  15 years ago

  By: sqlpadawan_1

• Statements that involve temp tables (#) are not properly reusing plans

  We are submitting multiple dynamic sqls that are using temp tables. For example, let say we submit…

  jfong-786685

  3 replies

  15 years ago

  By: Jeff Moden

• Signature Pad data

  I have a customer that wants to store a signature from a signature pad. What datatype is this? I be…

  Rog Saber

  1 replies

  15 years ago

  By: Orlando Colamatteo

• Trigger Performance

  So I have to populate a table with an SSIS package. The rows that return an error, go off to anothe…

  Khades

  14 replies

  15 years ago

  By: Evil Kraig F

• Practical Use for FULL OUTER JOIN & CROSS JOIN

  Hi All, Where exactly can we use FULL OUTER JOIN & CROSS JOIN ? Do they have any practical use…

  Hakuna Matata

  7 replies

  15 years ago

  By: The Dixie Flatline

• Inserting new and updating missing rows

  Hi there all, I have a table stucture as: location, month, metric1, metric2,..metric100 I want to u…

  greg.bull

  9 replies

  15 years ago

  By: Orlando Colamatteo

• invalid length passed to substring with a subquery

  I have come across an interesting issue and was hoping somebody would be able to help explain why i…

  Robert Klimes

  2 replies

  15 years ago

  By: Robert Klimes

• wrap xml column values into outer for xml path query

  I want to wrap the xml from a column into an out for xml path query without the column name as an e…

  Jules Bonnot

  1 replies

  15 years ago

  By: HowardW

• Read Committed Snapshot Isolation Level & DML

  Hello, I was reading this article below and it got me thinking more about how the RCSI works. htt…

  SQL Dude-467553

  2 replies

  15 years ago

  By: alexsmth114

• column is null query is slowed

  I ran into to a perplexing interesting situation select * from table where column1 is null runs slo…

  G33kKahuna

  3 replies

  15 years ago

  By: alexsmth114

• SQL 2008 Join Logic Bug?

  One of my developers came to me and said the results of the following type query were different bet…

  bpportman 52825

  7 replies

  15 years ago

  By: Jeffrey Williams