T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• SQL Select Case

  I am trying to replace a value from my select if the value from this column 'date' is equal to '000…

  a_car11

  8 replies

  11 years, 7 months ago

  By: Luis Cazares

• Replacing NULL with 0 when using the Pivot operator

  Is there anyway to replace a NULL with 0 when using the PIVOT operator? Or is there some other way …

  jlp3630

  6 replies

  11 years, 7 months ago

  By: Gail Shaw

• Front End Read and Write

  I use MSAccess as my front end. We may move to VB.Net but that is down the road. When using a tabl…

  Ken at work

  5 replies

  11 years, 8 months ago

  By: yariv 71936

• Need help with Charindex function..

  I am trying to capture an email address from the below message..whats the best possible way to do i…

  Chinna

  7 replies

  11 years, 8 months ago

  By: Jeff Moden

• DATEDIFF in hours and minits In Decimal Format

  Calculating Difference between ClockIn and ClockOut by Job. Table : JobTran Job# ClockIn …

  skb 44459

  1 replies

  11 years, 8 months ago

  By: Sean Pearce

• Advantage of using date and time in 2008 over 2005 datetime

  Hi Everyone, Hope all is well. We can store date and time separately in 2008,but when we are using …

  sharmili.net

  1 replies

  11 years, 8 months ago

  By: Koen Verbeeck

• using case when condition in WHERE in SP

  i have a SP with where condition as where id=@id and month=@month and Eid=@Eid wht i need is if @Ei…

  ssurekha2000

  7 replies

  11 years, 8 months ago

  By: Lynn Pettis

• Dynamic SQL Giving 'Name not a valid identifier error'

  I have some SQL I'm going to put in a stored procedure which will insert records into a temp table.…

  dmounday

  11 replies

  11 years, 8 months ago

  By: iaminyourhead

• Crystal Reports Groups

  I have a crystal report that groups by provider alphabetically. For each provider, we have procedur…

  Vertigo44

  2 replies

  11 years, 8 months ago

  By: Vertigo44

• Where clause - Where "string" in any field in specified table

  I have written a large complex stored procedure which produces a dataset of 39 items or so per reco…

  steve.wolstencroft

  4 replies

  11 years, 8 months ago

  By: Dwain Camps

• Need a sctipt to make a batch change to the same field in several mysql databases

  There may be a function in there already but I use only the barest minimum of the features. So Ple…

  basic 79842

  1 replies

  11 years, 8 months ago

  By: Phil Parkin

• Last value entered based on last modified date

  I need to get the last modified value for each project and each owner -- SAMPLE DATA DECLARE @Audit…

  Adelphi

  2 replies

  11 years, 8 months ago

  By: Phil Parkin

• Using a variable for a linked server name in stored procedures

  Hi, We have a number of SQL db environments for our CRM system, e.g. LIVE, TEST, DEVELOP, etc. and …

  Dizzy-486998

  7 replies

  11 years, 8 months ago

  By: Dave Blount

• request on a query to capture the cell area a given x,y coordinate would be found in?

  Hi, I have a problem I would like to solve that I believe is possible with SQL query although I don…

  haggisns

  7 replies

  11 years, 8 months ago

  By: Sean Pearce

• Pivot Help--I need to Pivot really to just make the rows the column

  SELECT CONVERT(varchar,C.SCHED_DTTM,101) as DATE,C.INV_ITEM_ID ,SUM(C.QTY_REQUESTED) AS QTY FROM PS…

  twdavis-893252

  2 replies

  11 years, 8 months ago

  By: Jack Corbett