T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Converting A OUTER APPLY to LEFT JOIN in a query

  Hi I need to convert a OUTER APPLY hint in my query to LEFT JOIN. How it can be done? The code whi…

  VSSGeorge

  4 replies

  11 years, 5 months ago

  By: Eirikur Eiriksson

• return placeholder Property names and 0 for aggregate columns for YYYYMM 'group by', even if no activity happened in that time span?

  Using a relational database (not datawarehouse) sql server 2008 R2. My stored procedure returns sum…

  KoldCoffee

  6 replies

  11 years, 5 months ago

  By: KoldCoffee

• How to rewrite that query using a pivot - And optimizie the query

  Hi I would like to rewrite that query using pivot instead of Union. And also can it be optimized. T…

  Stanley Pagenel

  4 replies

  11 years, 5 months ago

  By: Stanley Pagenel

• how to think about this problem?

  (using sql server 2008R2) I have a query that gets total messages sent and the devices they were se…

  KoldCoffee

  2 replies

  11 years, 5 months ago

  By: KoldCoffee

• Sending multiple emails

  Hi guys, i have an issue i hope someone can help me with. I need to send multiple emails to recipie…

  Keejli69

  2 replies

  11 years, 5 months ago

  By: Keejli69

• Another Issue with Stored Procedures

  I'm starting to really dislike this stored procedure business... So I got not so great grade on the…

  katland226

  4 replies

  11 years, 5 months ago

  By: katland226

• sql help

  I have columns ID,segment,jd_date example values are (AB98237,10,1/1/2012)I want a qry that gives m…

  Reddy-360666

  1 replies

  11 years, 5 months ago

  By: Luis Cazares

• Conditionally select table names from sys.tables

  Greetings folks, I'm having a hard time wrapping my head around what is probably a very easy concep…

  Herpington_McDerpington

  14 replies

  11 years, 5 months ago

  By: Herpington_McDerpington

• Discussion About Date Fucntion

  Hi, I am working in Sqlserver 2008 R2. I would like to know the pros and cons of using Dateddiff D…

  KGJ-Dev

  7 replies

  11 years, 5 months ago

  By: KGJ-Dev

• Partition and order the records using sql

  Hi All, I have the below requirement: (Please provide the sql script for this) 1. Group records acc…

  rohit.kumar.barik

  5 replies

  11 years, 5 months ago

  By: Luis Cazares

• calculate time in minutes

  Hi, I am having below schema: CREATE TABLE #Attendance( [ID] [int] IDENTITY(1,1) NOT NULL, [Stude…

  abhas

  7 replies

  11 years, 5 months ago

  By: Eugene Elutin

• SSMS2008 Debug Sysadmin Permissions

  Is it just me or does anyone find the sysadmin privileges to debug in SSMS2008 crazy? Alot of compa…

  MSSQL_NOOB

  3 replies

  11 years, 5 months ago

  By: MSSQL_NOOB

• Item Sales Batch Allocation

  Hello, I found next script for batch item allocation based on FEFO/FIFO method (according to DateCo…

  Johnny_B

  5 replies

  11 years, 5 months ago

  By: Eugene Elutin

• building groups out of references / eliminate cross references

  Hi all, I got the following problem to solve in TSQL. I don't want to use a cursor. But with the se…

  reto.eggenberger

  11 replies

  11 years, 5 months ago

  By: reto.eggenberger

• help while displaying resultSet in SP

  Hi all, I am simply inserting records in a table, But if record already present then i dont want ad…

  abhas

  4 replies

  11 years, 5 months ago

  By: HanShi