T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Job step not failing when timing out

  I have a job with about 15 steps. One step occasionally times out. I get this error message: OLE …

  Daniel Bowlin

  3 replies

  15 years ago

  By: Daniel Bowlin

• Sumof previous columns (in pivot table)

  I need to determine the weekly stock amounts. I know the weekly inputs and outputs. I made a pivot …

  aykut canturk

  10 replies

  15 years ago

  By: aykut canturk

• SET NOCOUNT

  For the longest time I been creating SP's with the SET NOCOUNT ON option but from the beginning I n…

  smallmoney

  1 replies

  15 years ago

  By: Nevyn

• Where clause with nested loop join

  Hi everybody, I have a SQL SELECT query which has more than 200 line. Due to performance issue, I w…

  arup chakraborty

  3 replies

  15 years ago

  By: Gail Shaw

• sum into new row

  After doing all the joins my final result set is something like this This has records description, …

  cpinky01

  4 replies

  15 years ago

  By: cpinky01

• ASCII function returns NULL ??

  i have a CLR UDF that validates email addresses but i just had a problem where i got the following …

  dant12

  2 replies

  15 years ago

  By: dant12

• Need a count by date including dates with a zero count

  The powers that be have requested a report that essentially shows each support rep and the number o…

  jerry-621596

  7 replies

  15 years ago

  By: WayneS

• SSIS Package Connections

  Hi, I need a help from you guys regarding modifying connections in SSIS Package as m new to these c…

  tripri

  4 replies

  15 years ago

  By: J-F Bergeron

• recursive joins w/o using dynamic sql

  --drop table #Category CREATE TABLE #Category( [CategoryID] [int] IDENTITY(1,1) , [ParentID] [int…

  madsnooka

  4 replies

  15 years ago

  By: madsnooka

• Drop Table On Linked Server

  Is there a way to do a drop table on a linked server? I tried : DROP TABLE LinkedSrvrName.Database.…

  TcW_1978

  6 replies

  15 years ago

  By: TcW_1978

• Select Columns based on input

  I am creating a stored procedure that produces a fee forecast. The figures in the table are based o…

  erniemadden

  6 replies

  15 years ago

  By: erniemadden

• Pass A Variable to a USE Statment

  I'm trying to pass a variable into the use database statment but can't get it to work. My code is…

  Djcarpen11

  1 replies

  15 years ago

  By: Djcarpen11

• Un able to see the user define Data type Definitions

  Some previous DB guy added the new UD Datype using sp_addtype, he used that in one procedures , Bu …

  Saravanan_tvr

  2 replies

  15 years ago

  By: Johan Bijnens

• how to retrieve complete data from text field

  Hi Gurus, I've a text field. I need to just retrieve complete data of that field. When I use select…

  venkat2ramarao

  2 replies

  15 years ago

  By: krushna_deb

• No Sub Query

  How do you find the second largest value in a column of table without using any sub queries??:excla…

  susindar

  4 replies

  15 years ago

  By: Quatrei.X