T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• ROUND() function doesn't round properly

  Hello. I use SQL Server 2005 and I'm calculating the age of patients in the following manner: DATED…

  ESB

  9 replies

  8 years, 8 months ago

  By: hrothenb

• IF EXISTS still running subquery when column not found

  I am stumped on this one. I am scanning databases to determine a piece of info if a certain column …

  Mindy Hreczuck

  2 replies

  8 years, 8 months ago

  By: Mindy Hreczuck

• cursor problem

  hi members, I need help to make a cursor in a stored procedure to make it skip to the next id if th…

  blnbmv

  1 replies

  8 years, 8 months ago

  By: gemspring2004

• BCP to Text Files. Odd Character at File End

  I'm trying to streamline a manual process here by using BCP to create some text files. I want the t…

  homebrew01

  9 replies

  8 years, 8 months ago

  By: s.j.iyyappan

• Creating dynamic master insert proc with identity column needing to be omited

  I use the following code to get all the column names except the first one because it is an identity…

  jpgillum

  9 replies

  8 years, 8 months ago

  By: Lynn Pettis

• How To Format Phone Number

  How To Display Phone Number Formatted How To Apply Mask To Phone Number Q: How best to display a ph…

  YSLGuru

  32 replies

  8 years, 8 months ago

  By: Jeff Moden

• Comparing column defaults between 2 databases

  Hi all, got a strange request thrown across my desk. there are 2 databases (lets use db1 and db2) w…

  mark_green

  3 replies

  8 years, 8 months ago

  By: davros30

• Alter Database with variable

  Hello together, I want to use a variable in an ALTER DATABASE command. Example: DECLARE @db varchar…

  baumgaertner

  13 replies

  8 years, 9 months ago

  By: mishradharmesh.2192

• Previous week date range

  Right, this is prooving to be a right headache, as many date related things in SQL seem to be for s…

  Rob-350472

  12 replies

  8 years, 9 months ago

  By: charlene_pottinger

• How to get only the last string before comma

  Hi All, I have a string like below DWDate,Email,UserID,ID,LoanNum,PersonEmail,LoanDate,Paymt I want…

  niladri.primalink

  3 replies

  8 years, 9 months ago

  By: Luis Cazares

• Problems using Bulk insert with a CSV file that has inconsistent quotes

  I have data that looks like this (the first row contain headers): id, company, rep, employees 72921…

  stuehler

  10 replies

  8 years, 9 months ago

  By: Dave PharmD

• Search between source table and lookup table

  I have a table that has a list of category codes and keywords. For example code=1234, keywords=bake…

  Mike Wiz

  1 replies

  8 years, 9 months ago

  By: Phil Parkin

• Returning unique row from multiple in a table variable

  I am building a process where I have a few places that have multiple rows with the same (non-unique…

  jim.snyder

  5 replies

  8 years, 10 months ago

  By: jim.snyder

• Getting Last 12 Month-Year from present date

  I need a query that should return me list of last 12 months from the date and time of running the q…

  gaurav-404321

  11 replies

  8 years, 10 months ago

  By: vbernys

• ROW_NUMBER() function with a difference

  Hi all This one has got me stumped..... I'm trying to track patient movements around our hospital a…

  richardmgreen1

  8 replies

  8 years, 10 months ago

  By: richardmgreen1