T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• stored procedure

  I have a requirement whereby I have to query 3 different tables and return the results in one resul…

  solus

  6 replies

  15 years, 3 months ago

  By: solus

• Dates must be shown as string with comma separtor

  I have table User ID Date 1 01\03\2011 1 02\03\2011 1 03\03\2011 1 07\…

  sujavani.l

  5 replies

  15 years, 3 months ago

  By: Jeff Moden

• How to return hrs,mins and secs from a function when date time stamp is passed to that function..

  Hi All, Can anyone please let me know how to write a function ... for returning days,hours,minutes …

  srividyakudumula

  9 replies

  15 years, 3 months ago

  By: WayneS

• SQL Query - create Stored procedure

  Hi Experts, I have a table and on top of that I am running a SQL query to get the average calculati…

  Best_boy26

  1 replies

  15 years, 3 months ago

  By: Jim Murphy

• Return ColumnName from Max Value in columns

  Hi sirs ! I have a Table like this (to simplify) : COL1 | COL2 | COL3 | COL4 |... | COL24 | COL_MAX…

  frankdotnet

  3 replies

  15 years, 3 months ago

  By: frankdotnet

• Date related query

  Hi, i have date field and product field now i want result in following format Can anyone provi…

  latitiacasta

  2 replies

  15 years, 3 months ago

  By: latitiacasta

• Running total "quirky update" previous row value problem

  (note: I accidentally posted into SQL2K so reposting here) Hello all, I am trying to quickly store …

  Robert Melancon

  1 replies

  15 years, 3 months ago

  By: WayneS

• Server Roles

  How do I check to which server role I belong to?

  Khades

  1 replies

  15 years, 3 months ago

  By: Dan.Humphries

• T-SQl CASE

  I have three table X,Y and Z TAble X ID Record 1 1 2 3 3 4 TAble Y ID Record 1 2 2 5 3…

  PSB

  3 replies

  15 years, 3 months ago

  By: PSB

• Looking for Elegant Efficient T-SQL Code

  'd like to find a more elegant an efficient solution than a cursor or a dynamic "exec @sql" loop f…

  P Jones

  11 replies

  15 years, 3 months ago

  By: Wildcat

• Need Records from strings

  Hi, I have some records which need to be subtracted. Please see the below sql and provide me the so…

  kiran.rajenimbalkar

  12 replies

  15 years, 3 months ago

  By: UMG Developer

• Exporting data to text file

  Hi All, I am having more than 1 lack records. I should export these records from a table to the tex…

  srinadh.ramineni

  6 replies

  15 years, 3 months ago

  By: Orlando Colamatteo

• Sq ft to Acres

  How I can convert sq ft to acres Below are sample data 1776 sq ft 1.848 1.510 0.217 323 sq. ft. 0.7…

  rocky_498

  2 replies

  15 years, 3 months ago

  By: Ross McMicken

• About AdventureWorks database

  hi, I have AdventureWorks database with 70 tables (schemas dbo, HumanResources, Person, Production,…

  suresh.muppidi

  1 replies

  15 years, 3 months ago

  By: Grant Fritchey

• comparing strings using <> operator, not getting expected results

  Wonder if anyone can help me with this problem, Not getting the expected results. CREATE TABLE #tem…

  tan110

  3 replies

  15 years, 3 months ago

  By: tan110