T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Replicate Help

  Hi All, Please read my query: DECLARE @tblRecursosArbol TABLE ( id BIGINT IDENTITY(1, …

  xRafo

  2 replies

  13 years, 3 months ago

  By: Jack Corbett

• How to select values

  Hi, If(@username='Ram') Begin Select Professor,Stu_name,Location,Subject From student where Locatio…

  suresh0534

  13 replies

  13 years, 3 months ago

  By: Jonathan AC Roberts

• Fulltext search like search based on rules. Best Approach

  I have a table called rptOutputTmp Create Table rptOutputTmp ( StockSymbol Varchar(50), Descrip…

  SQL Kidu

  2 replies

  13 years, 3 months ago

  By: Eugene Elutin

• Set fiscal year, have year automatically roll over

  I would like to (1) set the fiscal year as 12/01 - 11/30 and (2) have the data automatically roll o…

  jheltsley

  3 replies

  13 years, 3 months ago

  By: Jeff Moden

• TSQL - Find maximum running date gap in a date range and also date gap ranking

  Hi, I want to find maximum running date gap in a data set and also want to rank the gap days. Follo…

  iBar

  9 replies

  13 years, 3 months ago

  By: Jeff Moden

• Tsql grouping question

  Hello, I have data like below create table #Temp( ID varchar(10), Name varchar(100) ) insert into #…

  work.dev

  6 replies

  13 years, 3 months ago

  By: Jeff Moden

• Problem with update statement

  Please try to run example below to understand the problem. I am trying to update val1 and val2 col…

  CoolDown

  8 replies

  13 years, 3 months ago

  By: CoolDown

• Exporting to Excel via stored procedure

  I apologize in advance if this is answered somewhere already... I've searched, but have not found …

  Cory Huntington

  16 replies

  13 years, 3 months ago

  By: Cory Huntington

• Update a subset of a table

  Hi, I have a problem when implementing an Update statement. I have a table where one of the columns…

  Me68

  2 replies

  13 years, 3 months ago

  By: John Mitchell-245523

• Outputting a word in a procedure

  Hi guys I have a procedure which extracts information to a text file. But one issue I have is, reco…

  ram_kamboz2k7

  4 replies

  13 years, 3 months ago

  By: Jeff Moden

• Adding a Week number in a query.

  Hi, We have a database that shows specific information on employee stats. What I'm doing right no…

  Richard.Westhaver

  4 replies

  13 years, 3 months ago

  By: Richard.Westhaver

• New Version of sqlserver

  Hi, i am working in sqlserver2005 and i want to migrate to the newest version available.is Microsof…

  MuhammadShafiq

  13 replies

  13 years, 3 months ago

  By: Summer90

• Looping through table records and doing a replace

  I am trying to update filename records in a temp table by using the REPLACE function. I can't think…

  TeraByteMe

  5 replies

  13 years, 3 months ago

  By: drew.allen

• Using PCL in Stored Procedure for Barcode

  I am writing a stored procedure that has PCL embedded to print out a report that includes bar codes…

  abrown-998548

  9 replies

  13 years, 3 months ago

  By: Koen Verbeeck

• Left Outer Join on 3 tables - Incorrect Aggregate Results

  I'm not sure if I've made an error or I've found a bug: The following joins 3 tables to return colu…

  david.marron-916288

  2 replies

  13 years, 3 months ago

  By: david.marron-916288