T-SQL

• Topics

  Started by

  Posts

  Last post

• Incorrect syntax near the keyword 'as'.

  I know its simple but I am not able to understand this error I got this error when I tried creating…

  sql_time

  2 replies

  16 years ago

  By: Steve Jones - SSC Editor

• median

  i am trying to calculate median. I am able to calculate avg, min ,max etc. How can i calculate medi…

  rs-337036

  8 replies

  16 years ago

  By: Jeff Moden

• Null values in a table

  Hi, Have a table with null values. I am doing a SELECT query as follows: SELECT Project_ID + ' ' + …

  inliten

  4 replies

  16 years ago

  By: inliten

• Summing differences between time stamps

  Hi, I'm tracking machine state which can be 0,1 and 2, and storing that data in sql table with tim…

  PLC-Master

  5 replies

  16 years ago

  By: PLC-Master

• More recent rows by user

  So I’m having some issues optimizing a password retention procedure for an application that I am wo…

  Luke L

  9 replies

  16 years ago

  By: Luke L

• update multiple fields using case statement

  Hi, i need to update a table using a case statement. The table being updated is joined to the tabl…

  scottcabral

  1 replies

  16 years ago

  By: Ken McKelvey

• Concatinate a coloum values

  Hi Buddies, I just want to concatinate a column values. For an example, Table A -------- ID Name D…

  sagavb

  2 replies

  16 years ago

  By: Dave Ballantyne

• query remote server WITHOUT using sp_addlinkedserver?

  Is there any way to do this? A developer asked me this today, I was stumped. I know it's an unco…

  Steve Hare

  2 replies

  16 years ago

  By: Steve Hare

• Linked Server MERG data

  How do I insert selected data from a linked server and insert it into the destination server? For e…

  blawrence

  20 replies

  16 years ago

  By: blawrence

• SELECTing values on different records based on rules

  Hey everyone, I've been trying to wrap my mind around a problem lately, and I can't make it. Out of…

  Jonathan Melo

  12 replies

  16 years ago

  By: Jonathan Melo

• Rowcount for subset of data in temp table

  I'm a bit of a newbie and have been tasked with identifying some information which I know will requ…

  tacy.highland

  16 replies

  16 years ago

  By: Garadin

• Is linked server up?

  Hi there, I have a colocated SQL server that I am accessing via our local intranet. Currently, if t…

  Dooza-770962

  2 replies

  16 years ago

  By: Dooza-770962

• Select a Subset of rows and count of all rows in one statement in case of paging

  Hi all it is possible ,we can get a subset of rows according paging condition and total rows in one…

  SQL Editor

  5 replies

  16 years ago

  By: dbo.benyos

• Send e-mail using STMP Relay using cdosysmail

  hi, just wondering if anyone could help me find a sample program that sends e-mail using a STMP Rel…

  fmobcemia

  8 replies

  16 years, 1 months ago

  By: fmobcemia

• Trigger , SET IDENTITY_INSERT ON and OFF Problem

  I created a trigger where if a delete happens in schema1.dimcadr table then data which is deleted s…

  rahulsony111

  30 replies

  16 years, 1 months ago

  By: Greg Snidow