T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Over (Partition By)

  Hi Guys AdventureWorks 2008 DB When using the following Code select distinct SalesOrderID ,SalesOrd…

  SQLSACT

  8 replies

  14 years, 8 months ago

  By: SQLSACT

• Multiplication operator in a trigger

  G'day guys, I have a service that writes to a database, one of the tables the service writes to hol…

  ZombieRick

  1 replies

  14 years, 8 months ago

  By: ZombieRick

• Split Comma Separated String to Multiple Columns

  Hello Guys I am working with SQL Server 2008 and I have to make a T-SQL query to break a comma sepa…

  Sy-1148362

  3 replies

  14 years, 8 months ago

  By: Jeff Moden

• How to divide on row by another

  Hi, im looking for help with a query that im writing. Im not that great with math and I need to pop…

  strawb2

  16 replies

  14 years, 8 months ago

  By: Jared

• 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, 8 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, 8 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, 8 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, 8 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, 8 months ago

  By: sa.ordekci

• Pivot

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

  viiki.seth

  3 replies

  14 years, 8 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, 8 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, 8 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, 8 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, 8 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, 8 months ago

  By: Vishal Sinha