T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Theorhetical MERGE Question

  I have two orders tables, one is a staging, the other is a "Orders Sent" kind of table. The staging…

  Brandie Tarvin

  17 replies

  14 years, 1 months ago

  By: Gazareth

• ALTER PROCEDURE result message

  This isn't an important issue, but it struck me as strange and I'm curious to see if anyone can exp…

  shaun.stuart

  2 replies

  14 years, 1 months ago

  By: shaun.stuart

• Setting the Identity in a temp table using a variable

  Hello I have a table Allocations with coulmns AllocationID , PaymentID , …. AllocationID is a PK. D…

  SJanki

  12 replies

  14 years, 1 months ago

  By: Jeff Moden

• List of the last day of the month

  Hi Guys, How can i make list of the last day of each month of the year 2011? Output: January-2011 :…

  Jay Pete

  9 replies

  14 years, 1 months ago

  By: Jeff Moden

• Select all days that are the last day of the month from a calendar table

  HI All, I want to select all days that are the last day of the month from a calendar table. I guess…

  Chrissy321

  3 replies

  14 years, 1 months ago

  By: Jeff Moden

• how to change this scalar valued function to an inline one

  Please I need help in changing the following scalar valued function to an inline one to improve per…

  Sarsoura

  1 replies

  14 years, 1 months ago

  By: imex

• Partioning & SWITCH questions

  I'm studying for the 432 exam & have a few questions about SPLIT, MERGE & SWITCH. When yo…

  dan-572483

  1 replies

  14 years, 1 months ago

  By: Gail Shaw

• grouping info that appears sequentially and then has a break

  Hello, I'm trying to figure out how best way to group records that are consecutive. For example, I …

  mat inwater

  4 replies

  14 years, 1 months ago

  By: mat inwater

• incremental Load

  I have 3 table. Source table, dim table and load table.. I have a source table .. In the source tab…

  patelronaks1983

  7 replies

  14 years, 1 months ago

  By: Brandie Tarvin

• Organically cancel a resultset from proc if rowcount is zero?

  I want to do a select in a proc and if @@ROWCOUNT = 0, I would like to kill that rowless resultset …

  reidres

  27 replies

  14 years, 1 months ago

  By: TheSQLGuru

• System.OutOfMemory Exception in SSRS

  I am using SSRS 2008 for reporting. I made a matrix report but when I preview it that time it shows…

  hmsanghavi

  1 replies

  14 years, 1 months ago

  By: Brandie Tarvin

• Alias Exists Subquery

  How do i alias a Exists subquery? select TOP 1000 E.[Last Name] , E.[First Name] , E.[Department] ,…

  Hollyz

  16 replies

  14 years, 1 months ago

  By: Mark Fitzgerald-331224

• Week of the month

  Hi all, how can i get a week of the month given a specified date? my week start on Monday and end o…

  abdul.badru

  4 replies

  14 years, 1 months ago

  By: Ant-Green

• Japnese char in XML

  when trying process the following string as an XML statement, the japanese character are causing a …

  Bill Maners

  5 replies

  14 years, 1 months ago

  By: Bill Maners

• SQL View or Stored Procedure to display results

  Hi All, I'm currently working out the ideal way to display my result set to a set of people within …

  Tava

  5 replies

  14 years, 1 months ago

  By: Jared