T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• need to find out % value

  select Distinct ClientIdentifier, sourcesystem, methodtype, voicedatatype ,Count(CASE WHEN …

  san-1015392

  8 replies

  15 years, 7 months ago

  By: Jeff Moden

• Find all data for a Month

  I use this query below that collates all records for that current day, I need to be able to use the…

  J39L4753

  2 replies

  15 years, 7 months ago

  By: J39L4753

• How to automatically add .ndf files with Trigger

  I'm trying to write some code, either a trigger or another monitoring object that watches for a new…

  Bryan Wilson

  8 replies

  15 years, 7 months ago

  By: Elliott Whitlow

• Query Tuning~CPU Usage

  All, I fine tuned a procedure from 3 minutes to 50 seconds(i am looking the procedure to fine tune …

  karthik M

  17 replies

  15 years, 7 months ago

  By: SQLRNNR

• inserting Commas

  hai guys, say suppose i have a string like ABC my function have to return A,B,C …

  sql.kishore1

  19 replies

  15 years, 7 months ago

  By: Jeff Moden

• update table with tally doesnot work

  Guys.. following is the dml script alng with sample data.. if object_id('tempdb..#forecastperiods')…

  NewBeeSQL

  3 replies

  15 years, 7 months ago

  By: NewBeeSQL

• Datetime with timezone

  Hi experts, In sql server 2008, function called SYSDATETIMEOFFSET() output: 2010-05-06 04:26:35.557…

  Mohamed Asane

  3 replies

  15 years, 7 months ago

  By: Mohamed Asane

• Calculating cumulative product from previous row (without using cursors)

  Hi good folks, I'd appreciate some expert assistance on this. I am looking to produce the third col…

  vijay.s

  12 replies

  15 years, 7 months ago

  By: SQLRNNR

• Very large transactions and log space

  Hi everyone, I have to work with a very large set of data and this causes my transaction log to fil…

  shahgols

  4 replies

  15 years, 7 months ago

  By: shahgols

• Opendatasource query with parameter not working

  Hi All, I've tried this a million ways around...but nothing... I have a table with a list of all o…

  Henrico Bekker

  6 replies

  15 years, 7 months ago

  By: ColdCoffee

• Find out which table columns were inserted from within a trigger

  Hi All, I've got a question that I can't seem to find an answer to anywhere - it leads me to believ…

  Grant Scanlen

  17 replies

  15 years, 7 months ago

  By: mdrost77

• T-sql query to extract dependency results

  Hi Everyone, I am facing a peculiar scenario of data. I actually need to find out the dependency v…

  saidwarak01

  3 replies

  15 years, 7 months ago

  By: Mitesh Oswal

• For XML Auto

  We have a proc that has been working fine...but for no known reason, it is now (sometimes) adding a…

  krypto69

  1 replies

  15 years, 7 months ago

  By: LutzM

• Updating a single record from Multiple

  Here's a simple example of the scenario I'm trying to address: T1 IDField1Field2Field3Field4 1…

  kramaswamy

  22 replies

  15 years, 7 months ago

  By: spaghettidba

• price to pay: IMPLICIT conversion INT to DECIMAL(9,0)?

  I'm working with an Oracle database that was converted to SQL Server by headless horsemen (no thoug…

  SethT3

  7 replies

  15 years, 7 months ago

  By: SethT3