T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• SQL Inline table-valued function

  Hi, When I am looking for a database object getuserrelations in sysobjects I get that as a type IF …

  sql_novice_2007

  2 replies

  14 years, 5 months ago

  By: sql_novice_2007

• Flexible filters - can XML be used to avoid lots of "or xxxx IS NULL"?

  Hello experts, in a meeting we were talking about being able to filter the results of a stored proc…

  paul.jones

  7 replies

  14 years, 5 months ago

  By: Matt Miller (4)

• Varying results when converting proc using exec to use sp_executesql

  I am trying to convert a proc which uses dynamic sql (using exec) to use sp_executesql. Original pr…

  jaya

  3 replies

  14 years, 5 months ago

  By: Sean Lange

• Create table problem

  I'm trying to create a table - there will be others for a partitioned view. Column names only for t…

  kuopaz

  2 replies

  14 years, 5 months ago

  By: kuopaz

• filter two table by date arrange

  Hi. i have two table. My tables are: ProductDetail table: ProductDetailId,ProductId,Title,Descripti…

  sa.ordekci

  2 replies

  14 years, 5 months ago

  By: sa.ordekci

• Pivot

  create table tempdocinfo (irecordid int, instrument_type_abbreviation varchar(250), sbooktype varch…

  viiki.seth

  3 replies

  14 years, 5 months ago

  By: R.P.Rozema

• join two table and then group by

  Hi. i have two table that have relation. CommentId Title Content ... .. HitsId Hit(int) CommentId C…

  sa.ordekci

  3 replies

  14 years, 5 months ago

  By: Toby Harman

• Data Cleansing

  Hi, I have got a address line as: Unit3 Unit 4 Shop2 Shop 5 Villa 7 Villa11 I want the output to be…

  rka

  4 replies

  14 years, 5 months ago

  By: JonFox

• Script step in a job

  Hi, I am trying to replace the commands of step2 with my new command in a sql server agent job by c…

  Deepthy

  3 replies

  14 years, 5 months ago

  By: Deepthy

• case statement help.

  below is part of code that includes many subselects, sums, etc. here's the problem I have, in the C…

  bass8117

  7 replies

  14 years, 5 months ago

  By: bass8117

• Inserting records in a table fills up TempDB

  Hi, I am executing an Insert statement in to a table in a user database and this process is filling…

  Vishal Sinha

  10 replies

  14 years, 5 months ago

  By: Vishal Sinha

• noob tsql confusion!

  Hi all, trying to learn tsql so thought i would try and make a data dictionary for my class in db …

  Staggerlee

  4 replies

  14 years, 5 months ago

  By: Jeff Moden

• Optimizing SP

  Hi, I have a question regarding SQL Server stored procedures. Imagining that there is procedure to …

  RMiranda

  8 replies

  14 years, 5 months ago

  By: RMiranda

• Convert column in multiple rows to a single csv column

  Hey all, I need to return a single csv column for [sys].[dm_db_index_physical_stats]'s [alloc_unit_…

  Adam Bean

  5 replies

  14 years, 5 months ago

  By: Adam Bean

• Date manipulation and pivottable in excel

  Hello, I'm trying to set something up and can't for the life of me figure out what to do. I have a…

  Stephen crocker

  6 replies

  14 years, 5 months ago

  By: drew.allen