T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• 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 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 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 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 ago

  By: WayneS

• Server Roles

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

  Khades

  1 replies

  15 years 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 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 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 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 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 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 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 ago

  By: tan110

• What are you "must have "CLR" procs

  What, if any, CLR procs and procedures do you all have and actually use? in my limited experience, …

  Lowell

  11 replies

  15 years ago

  By: spaghettidba

• how to populate child dependecies for an object or any table type.

  this is my query.It is showing all dependencies for particular table type.but i need the child tabl…

  malleswarareddy_m

  4 replies

  15 years ago

  By: Lowell

• How to create global temp table in the remote server and we can query it via linked server?

  Hi, Do you know how to create a global temp table on a remote server? I tried to use EXEC ( 'Select…

  lindsaywang

  9 replies

  15 years ago

  By: lindsaywang