T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• avoid self join

  i would like to do display results as below. I can achieve results by self joining back, is there a…

  mxy

  8 replies

  12 years, 2 months ago

  By: Jeff Moden

• How to add up the monthly total?

  Here is example table and data CREATE TABLE [dbo].[sales]( [date_value] [datetime]NOT NULL, [mont…

  Seattlemsp

  6 replies

  12 years, 2 months ago

  By: Seattlemsp

• need help on convert function dates

  hi all, please help me to get this out put. details: declare @deadline Datetime = '2014-03-23 15:30…

  kbhanu15

  2 replies

  12 years, 2 months ago

  By: kbhanu15

• Performance nehancemnt in writing the SQl query

  I have written my query like this: select a.ID, a.Name from Table2 b INNER JOIN Table3 c on b.ID =…

  VSSGeorge

  6 replies

  12 years, 2 months ago

  By: MysteryJimbo

• Need to write query to get Steps in custom job that have not completed

  I have the following: create table testdata ( StepName varchar(25) ,StepStatus char(25) ,EntryDat…

  jamie_collins

  5 replies

  12 years, 2 months ago

  By: Dwain Camps

• Cannot create index on view 'ViewTicket' because the view uses an implicit conversion from string to datetime or smalldatetime. Use an explicit CONVERT with a deterministic style value.

  Hi Team, Please advise.... Step 1 Created View CREATE VIEW [dbo].[ViewTicket] WITH SCHEMABINDING…

  ghitpro

  2 replies

  12 years, 2 months ago

  By: mickyT

• Taking long time to executing after created table valued functions as my scripts

  Hello, I have one Table valued functions FN(@param1,,,,,,) . When, I try to selecting the function…

  Saravanan_tvr

  4 replies

  12 years, 2 months ago

  By: Grant Fritchey

• compare records in tables

  There are four tables 1. Matter MID, CID, RType 001, a, m 002, a, m 003, b, m 004, c, m 2. Category…

  Seattlemsp

  18 replies

  12 years, 2 months ago

  By: Seattlemsp

• how to GROUP BY with shortest Distance by AccountNumber

  Given the following example; declare @CustIfno table (AccountNumber int, StoreID int, Distance dec…

  Geoff A

  7 replies

  12 years, 2 months ago

  By: mickyT

• SQL Agent Job - Send SSRS Report Based on Certain Criteria

  I have an SSRS Report that I created. I'd like to set up a job that will run every hour, and what t…

  joshdbguy

  3 replies

  12 years, 2 months ago

  By: SQLRNNR

• Update rows

  I have a scenario: I have a table tablAA with column IDA which is get referened in some other table…

  kapil_kk

  6 replies

  12 years, 2 months ago

  By: mcx5000

• 'New Line' - logic

  I am trying to format to paragraph of output to be used in an email, I have the static portion in a…

  TryingToLearn

  5 replies

  12 years, 2 months ago

  By: TryingToLearn

• Need to consolidate Queries sysjobs, sysjobhistory, sysjobschedules

  I need to modify the first query listed below so that it contains information from the second query…

  Welsh Corgi

  8 replies

  12 years, 2 months ago

  By: Welsh Corgi

• Pivot and Unpivot in same query

  Hi, I have below table and within same query i need pivot and unpivot. create table #temp(name1 va…

  latitiacasta

  4 replies

  12 years, 2 months ago

  By: TEJABI

• SQL Query Help - Thank you.

  Hi Guys, I need some help please, I have two tables listed below, the first table has employees pay…

  DiabloSlayer

  2 replies

  12 years, 2 months ago

  By: DiabloSlayer