T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Get particular day between two dates

  Hi All, I want to list Dates for particular day between two dates. for eg. if user enters 08/01/201…

  abhas

  12 replies

  11 years, 7 months ago

  By: Jeff Moden

• Results doubling up in two columns, can't work out why?

  Hi Everyone, I have written some SQL that relates to the (partial) result set below - I am having …

  david.dartnell

  1 replies

  11 years, 7 months ago

  By: Eirikur Eiriksson

• Need help to give point and set the score

  Hello, I've table and data as following, CREATE TABLE [dbo].[x_SCORE]( [idx] [int] IDENTITY(-2147…

  Qira

  1 replies

  11 years, 7 months ago

  By: ScottPletcher

• Distribute data into groups based on existing numbers

  Hi, i've been looking at moving one of our processed from excel (+vba) into t-sql to make life easi…

  daniel gibbs

  5 replies

  11 years, 7 months ago

  By: daniel gibbs

• T-SQL vs SQL differences

  This is a relatively pedantic but necessary question as I have seen differing explanations on the s…

  meridius10

  22 replies

  11 years, 7 months ago

  By: podmate

• Find matching phone of person based on relation type - duplicates

  I have a patient record and emergency contact information. I need to find duplicate phone numbers i…

  lsalih

  14 replies

  11 years, 7 months ago

  By: Matt Miller (4)

• Join query produce duplicates

  Hi, I need help on join three tables and wont be duplicate records. I have tried and attached the c…

  SPtrt

  4 replies

  11 years, 7 months ago

  By: Ed Wagner

• Report parameter textbox in SSRS report

  I have a report parameter textbox in my SSRS report which has the parameter properties as "allow nu…

  VSSGeorge

  1 replies

  11 years, 7 months ago

  By: Iulian -207023

• fetch next from cursor returns multiple rows. why?

  Hi there, Introduction I have a strange behaviour that I don't understand using a dynamic cursor. M…

  WolfgangE

  8 replies

  11 years, 7 months ago

  By: WolfgangE

• Troubleshooting\Tuning sql query taking more than 40 secs

  [font="Comic Sans MS"]I am trying to troubleshoot/tune a query which is almost running for around m…

  Feivel

  23 replies

  11 years, 7 months ago

  By: LutzM

• Update a field with condition

  Table A - data example Idno Entity Flag 1 1 y 2 1 n 3 1 y 4 1 …

  thiensyh

  4 replies

  11 years, 7 months ago

  By: thiensyh

• Missing Century in Date

  Does anyone have a script handy to fill in a century into a date string. Right now, I'm getting da…

  SQLSeTTeR

  24 replies

  11 years, 7 months ago

  By: Lynn Pettis

• Consecutive streak excluding weekends

  Hi SSC, I'm trying to write an algorithm that returns the most recent and longest consecutive strea…

  Xedni

  5 replies

  11 years, 7 months ago

  By: Jeff Moden

• grant permission help need - Error Msg 2760,

  Hi, Please give me suggestion, how to resolve this issue? --create Login script --use master CREATE…

  SQL Galaxy

  9 replies

  11 years, 7 months ago

  By: sangeet.tuladhar

• display numbers 0-9

  Hi, I am having query where i am calulating datediff value, but i want to display resultser as belo…

  abhas

  2 replies

  11 years, 7 months ago

  By: Sean Pearce