T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• rows are repeating 2 times,how to avoid that

  hi i am getting result like this 1 product1 12.34 32.11 1 product1 …

  hbtkp

  3 replies

  14 years ago

  By: hbtkp

• TOP 1 in an INNER JOIN query

  I have two tables : Users ID | Name 1 | Bob 2 | Robert and BackOffice ID | UserId…

  TcW_1978

  17 replies

  14 years ago

  By: CapnHector

• Return records with Max Sequence Number

  I need to return the records with the Maximun Sequence Number only. This is some sample Detail Data…

  Welsh Corgi

  8 replies

  14 years ago

  By: GSquared

• need help aggregating

  I would like a query which shows avg salary of all teachers and assistants, by school as in the exa…

  xenophilia

  7 replies

  14 years ago

  By: Orlando Colamatteo

• varchar options

  In a new table in sql server 2008 R2 that I will be setting up, I am wondering if there is a proble…

  wendy elizabeth

  1 replies

  14 years ago

  By: Lynn Pettis

• Shrink log file if at a certain percentage...

  I'm reading a lot about the "evils" of log file shrinking. It shouldn't really be done but sometim…

  John Waclawski

  5 replies

  14 years ago

  By: Johan Bijnens

• MAT Quarter

  Hi, I want to create a MAT quarter based on the below data and use it as an attribute in cube. I wa…

  jothibhatt_s

  11 replies

  14 years ago

  By: Dwain Camps

• Can I create a schema bound view from this?

  I am trying to create a schema bound view as follows. -- GroupID - BIGINT NOT NULL -- LanguageID - …

  SQLOzzie

  2 replies

  14 years ago

  By: SQLOzzie

• Using database to store (locate) pdf files

  My user needs to keep pdfs as legal documents. What is the best way to do that using ss2k8? Store p…

  valeryk2000

  7 replies

  14 years ago

  By: Sean Lange

• we're throwing around using the image data type for a project we're doing

  Anybody have any comments on pros and cons for going this route as opposed to storing the physical …

  Snargables

  5 replies

  14 years ago

  By: Lynn Pettis

• Script run on one server but error on the other.

  SQL instance names are SQLSERVER1\foundation and SVBerry. Both are 2008 R2 10.50.1600. The query …

  Jeff Sims-413169

  3 replies

  14 years ago

  By: Lowell

• Primary Key: GUID vs. INT

  Hi Folk, is it a big performance loose when using GUIDs as Primary Keys? Greetz Teutales

  Teutales01

  23 replies

  14 years ago

  By: Lynn Pettis

• I need my columns to trim off a few pounds...!

  Okay Guru's, I got one for you! I believe I'm on the right path, but need some Syntax assistance. …

  SQL_Enthusiast

  10 replies

  14 years ago

  By: Anders Pedersen

• How to insert two date values into table sending that values as parameter

  Hi i created a procedure for inserting data into table when i passing values as parameter for date …

  nhimabindhu

  4 replies

  14 years ago

  By: OTF

• call/exec a Stored Procedure from a View

  Hi, is there a way, to call/exec a Stored Procedure from a View (SQLS 2008/R2)? 😉 Thanks and Best R…

  info 58414

  7 replies

  14 years ago

  By: Lowell