T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Showing Backup compression one record per Database

  I have a query from msdb..backupset that displays Database Name and Compression Ratio, but it displ…

  BikeDude

  3 replies

  13 years, 10 months ago

  By: ScottPletcher

• Query help

  Hello all, CREATE TABLE #pyft001 ( py_fl BIT , fy INT , p_nm VARCH…

  ssc_san

  8 replies

  13 years, 10 months ago

  By: ssc_san

• Optional Parameters in Stored Procedures

  Hi, I was wondering if anyone has a solution for me. I am writing SEVERAL sprocs to update differe…

  takilroy

  10 replies

  13 years, 10 months ago

  By: ScottPletcher

• can anyone help improve the performance of this query?

  it is quite slow as you will see from the execution plan it should be returning just over 1.5 mill…

  jfriedl

  8 replies

  13 years, 10 months ago

  By: TheSQLGuru

• restricting values a variable can be assigned

  Hey guys, how can I declare a variable of datatype int that only can be assigned the values 1,2,3,4…

  dndaughtery

  8 replies

  13 years, 10 months ago

  By: Alan Burstein

• 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, 10 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, 10 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, 10 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, 10 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, 10 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, 10 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, 10 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, 10 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, 10 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, 10 months ago

  By: kupy