T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• joins

  hiii guys... I want a detailed clarification on when to use various join operations. please help me…

  Trainee SQL

  5 replies

  12 years, 4 months ago

  By: BenWard

• Latest Data Retrieval Query

  I have four source tables as below: [vw1], [vw2], [vw3], [vw4] I need to get an output joining all …

  kiran.ragipudi

  3 replies

  12 years, 4 months ago

  By: spaghettidba

• Stuck with query

  Hi All Not sure why I'm having such a mental block on this. Below is sample code and data with inli…

  mark 4643

  7 replies

  12 years, 4 months ago

  By: Dwain Camps

• Best way to determine tables which contain a list of specific columns

  I’ve got an issue which has come up with enough regularity that I wanted to see if you knew of a cl…

  Xedni

  5 replies

  12 years, 4 months ago

  By: Xedni

• comparing ip addresses in sql

  i have a table with 2 fields IpMax, IPMin i want to compare an ip whether it is in the range(in ma…

  sqlnew

  24 replies

  12 years, 4 months ago

  By: Guss Davey

• Multiple Column Joins

  I have two tables and I need to join on one column if there is a match else join on another Example…

  chcampbelljr 84439

  2 replies

  12 years, 4 months ago

  By: chcampbelljr 84439

• Determine time elapased by hour

  Hi, Wondering if anyone has an elegant solution to finding out how much time has elapsed for a spec…

  Matthew24

  11 replies

  12 years, 4 months ago

  By: Matthew24

• How can I select values where first 2 characters are non numeric and last character is 1

  I need to make a condition where I exclued results from a column where the first 2 characters are n…

  Steve Kinnaman

  4 replies

  12 years, 4 months ago

  By: Steve Kinnaman

• MSDB.dbo.sp_send_dbmail HTML formatting fails, but unformatted works

  This sample code should work if folks want to test this - just add your email in the 2 sections [in…

  rtrim(ltrim(' '))

  3 replies

  12 years, 4 months ago

  By: sestell1

• sql help table join

  Hi, I have the following two tables SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADD…

  SQL_Kills

  2 replies

  12 years, 4 months ago

  By: SQL_Kills

• Export particualr column of Stored Procedure to a Table

  Hi I know that It's possible to export the entire result set of a Stored Procedure to file, table e…

  wak_no1

  4 replies

  12 years, 4 months ago

  By: Dwain Camps

• Phone number question - detecting and replacing

  Hello, I have a website/database app with a text column that stores a user's bio where users are no…

  matt6749

  12 replies

  12 years, 4 months ago

  By: matt6749

• Selecting n Closest (Geographic) Rows

  Hello there! This is a high-level explanation. I have two sets of data. One set , let's say, is em…

  Robert A. Shannon III

  2 replies

  12 years, 4 months ago

  By: mickyT

• Sp runs from 7 sec to 10 min (UnitPricingTrans)

  I compiled a stored procedure (UnitPricingTrans) 3 days ago. The first execution took 10 min. When …

  RVO

  25 replies

  12 years, 4 months ago

  By: Ville-Pekka Vahteala

• Help with Text search

  I have a customer that is upgrading his legacy to updated version of his software and I have to dev…

  Kerrie Sorrell

  2 replies

  12 years, 4 months ago

  By: Sean Lange