T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• There is a way to send an email file that is stored in a column 'binary' through 'msdb.dbo.sp_send_dbmail'?

  There is a way to send an email file that is stored in a column 'binary' through 'msdb.dbo.sp_send_…

  barrantesrob

  1 replies

  13 years, 11 months ago

  By: Lynn Pettis

• Filtering the data generated by the DENSE_RANK() function

  I haad written a query using dense_rank() it returns the following table HotelID RoomID Age…

  SQL006

  10 replies

  13 years, 11 months ago

  By: SQL006

• How do I get the all columns of a row for the row with the highest value of a column

  I have a table that has many columns. I want to return all the columns of the rows with the greate…

  groads2

  6 replies

  13 years, 11 months ago

  By: Jeff Moden

• What is the equivalent of ORACLE “MONTH_between “ in SQL ?

  Hi, What is the equivalent of ORACLE “MONTH_between “ in SQL ? I want in months…. I tried the Dat…

  VGish

  3 replies

  13 years, 11 months ago

  By: ScottPletcher

• No Cursors.....

  Hi All I'm trying to get out of using cursors to solve my T-SQL problems Without using a cursor, I …

  SQLSACT

  13 replies

  13 years, 11 months ago

  By: SQLSACT

• Scalar user defined execution fails - Invalid object name 'fnContactFullName'.

  Have created Scalar User Defined Function and when i try to execute the function it fails.What coul…

  Smash125

  4 replies

  13 years, 11 months ago

  By: TheSQLGuru

• Can you please help me to get the median using the cursor

  Can you please help me to get the median using the cursor How I wrote the following code using the …

  hoseini_akram

  1 replies

  13 years, 11 months ago

  By: Luis Cazares

• update statment help

  CREATE TABLE #Contact ( ContactID INT, FirstName NVARCHAR(100), MiddleName NVARCHAR(100), LastName …

  Smash125

  8 replies

  13 years, 11 months ago

  By: Jeff Moden

• eliminating 'reflections' from a query result

  I have a table of ItemID's associated with OrderID's and I would like to query the table to find al…

  aostanley

  4 replies

  13 years, 11 months ago

  By: aostanley

• Ambiguous Column name'MedianCo' pleas help me

  update TblGas set MedianCo= (SELECT MedianCo FROM TblGas INNER JOIN Total ON TblGas.ID_NO= Total…

  hoseini_akram

  4 replies

  13 years, 11 months ago

  By: kupy

• Can you please help me to get the median using the cursor

  Can you please help me to get the median using the cursor How I wrote the following code using the …

  hoseini_akram

  5 replies

  13 years, 11 months ago

  By: Ron McCullough

• Derterministic & non-deterministic result

  Can any one describe that what exactly is a Deterministic & non-deterministic result?

  ankit.singh484

  3 replies

  13 years, 11 months ago

  By: ankit.singh484

• comparing string column with GetDate()

  Hi, I have following table: USE [Test_Shamshad] GO /****** Object: Table [dbo].[mTable1] Scrip…

  shamshad.ali

  2 replies

  13 years, 11 months ago

  By: rhythmk

• Need help in a query which return a field base on calculation

  Hi All, I need write a query that will return a filed which base on the calculation of the data. He…

  kate8tt

  4 replies

  13 years, 11 months ago

  By: kate8tt

• FROM clause challenge

  Is the statement below correct? I.SKU will be used to retrieve a record from from ITEMMAST when eit…

  JayWinter

  9 replies

  13 years, 11 months ago

  By: ScottPletcher