T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• replacement of InStr function in SQL

  how do we change IIf(InStr([tblA].col1,"abc")>0,[tblA].col1,"") AS xyz into a sql

  nabajyoti.b

  6 replies

  3 years, 11 months ago

  By: cait5801

• How can I change the current database within a cursor?

  I've run into this issue many times, but never found a solution. If it's obvious, I apologize, but…

  scopeland

  6 replies

  4 years, 3 months ago

  By: mmacharia

• conversion of excel formula to case statement in tsql

  Hi  all, need your help on conversion of excel formula into case statement. i tried but missing onl…

  Abhas

  4 replies

  4 years, 6 months ago

  By: Eirikur Eiriksson

• Challenging query for medical claims analysis

  My problem has three tables which have a common ClaimNumber field. CREATE TABLE InsuranceClaim(Cl…

  ahmet erispaha

  8 replies

  4 years, 8 months ago

  By: arebA

• CONVERT COLUMN VALUES TO COMMA SEPARATED ONE ROW VALUE..

  hi all... I have a query the returns country....state...and cities the cities are creating ore row…

  sql_learner29

  24 replies

  4 years, 9 months ago

  By: Jeff Moden

• Attribute to identify system databases

  I'm embarrassed to say that I can't seem to figure this out. Is there an attribute along the lines…

  Robert Frasca

  26 replies

  5 years ago

  By: zionassedo

• subscriber_id in MSSubscriptions table. Where is it defined?

  Looking in the MSsubscriptions system table i notice there is a subscriber_id. Where is this id com…

  BaldingLoopMan

  2 replies

  5 years, 3 months ago

  By: Tomas Rybnicky

• removing column underlining in database mail attachments

  I have a job set up with the following configration (below) - basically it emails the results of a …

  adam-639168

  4 replies

  5 years, 3 months ago

  By: rvaishnapu

• Epoch to readable format

  Hi all. I need to convert epoch to readable format.I want it in a readable/sql server datetime form…

  prady_1988

  7 replies

  5 years, 3 months ago

  By: Sean Lange

• Is there an equivalent of Excel's NORMDIST function in SQL Server 2005?

  Is there an equivalent of Excel's NORMDIST function in SQL Server 2005?

  L Cerniglia

  7 replies

  5 years, 6 months ago

  By: Sean Lange

• running sum cursor

  Okay, I spent the last 24 hrs looking for a solution...I am totally new to server sql and after 24 …

  sdhanpaul

  34 replies

  5 years, 9 months ago

  By: Sean Lange

• query to get all childs and grand children for a prent

  hi SQL Server: How to get all child records given a parent id in a self referencing table Can any …

  sql_learner29

  14 replies

  5 years, 9 months ago

  By: Jeff Moden

• Increment a date T-SQL Statement

  Hi Can anyone help me write a store procedure to increment a month For example The current month is…

  Jnrstevej

  24 replies

  5 years, 9 months ago

  By: chetan

• Pass variable to Openquery

  Hi I am getting the following error message trying to pass a variable into an openquery, can someon…

  Marcus Farrugia

  8 replies

  5 years, 9 months ago

  By: sagarkondoori

• Using TOP and count in single query

  Hi all, I am trying to use Top and count in 1 query. select top(100) count(1) from table where name…

  AJ07

  9 replies

  5 years, 10 months ago

  By: drew.allen