T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• sp_sproc_columns

  Trying to return sproc metadata (only input paramaters) by using sp_sproc_columns. So I tried modi…

  dr43058

  1 replies

  13 years, 1 month ago

  By: Eddie Wuerch

• TRimming of data froma record

  I have records for few columns which have data suffixed with _Error . I am trying to trim the _Erro…

  ishaan99

  13 replies

  13 years, 1 month ago

  By: Lynn Pettis

• fn_trace_gettable error if rollover trace file is empty

  Select * FROM :: FN_TRACE_GETTABLE('D:\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\log.trc', …

  Pam Brisjar

  6 replies

  13 years, 1 month ago

  By: Tom257

• Query Help

  How to Create a stored procedure to find the following output. [Q1 = Jan + Feb + Mar ][ Q3 = July +…

  suresh0534

  2 replies

  13 years, 1 month ago

  By: Dwain Camps

• Stored Procedure 100% CPU During Data Insert, Manually Processing OK

  I have a very perplexing problem. There is a stored procedure that creates 5 temp tables (to de-no…

  DB_Newbie2007

  6 replies

  13 years, 2 months ago

  By: Orlando Colamatteo

• sql 2k script issue

  im having some issues with the scipt below. i would like for it to cycle through every table in eac…

  ceso

  3 replies

  13 years, 2 months ago

  By: Steve Jones - SSC Editor

• View to show calculated column

  I'm trying to create a view but I'm struggling, here is my scenario. The first table has a list of …

  mark 44367

  8 replies

  13 years, 2 months ago

  By: Andre Guerreiro

• Selecting records issue

  hi all, i have a table like this table1(Id,username,DateOfBirth) i have alot of data in this table …

  MuhammadShafiq

  1 replies

  13 years, 2 months ago

  By: LutzM

• Joining datetime dates to calendar table

  I'm looking for some input and comments/ideas. I've got a transaction table (orders) which contains…

  Phil Parkin

  7 replies

  13 years, 2 months ago

  By: Jeff Moden

• Query taking long time when using parameter

  I have a query which takes a parameter. If a parameter is passed. the query takes 11 minutes to com…

  Sanz

  4 replies

  13 years, 2 months ago

  By: SQLRNNR

• Data Extract

  I have a table witha column as clientid. the client id datais as follows '55566', '00055566' 'abcd…

  ishaan99

  7 replies

  13 years, 2 months ago

  By: Dwain Camps

• Variable based JOIN

  I am working on a SQL query that takes a variable to base the join on. The same variable is used fo…

  rjv_rnjn

  3 replies

  13 years, 2 months ago

  By: rjv_rnjn

• convert datetime to integer

  hello what would be the easiest way to convert a datetime column into an integer column?

  DBA-640728

  18 replies

  13 years, 2 months ago

  By: john.arnott

• Can I ignore a specific index in a query?

  I am an app developer who writes queries. My DBA has added an index to a table and I want to compa…

  MonkeyK

  7 replies

  13 years, 2 months ago

  By: Orlando Colamatteo

• Grouping based on contiguous dates

  Hello All Not sure this doesn't qualify as a 'newbie' question, but it certainly is beyond my capab…

  philippe-546556

  17 replies

  13 years, 2 months ago

  By: Eugene Elutin