T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Keep SQL Script Running

  in sql server 2005 how can i keep running series of sql statements when there is an error. I have …

  jmcgarvey

  2 replies

  13 years, 9 months ago

  By: kramaswamy

• Char to PLU_NUM(float)

  Hi, I have 2 tables to join on a common field(column) having char and PLU_NUM(float) values..They h…

  SkyBVI

  4 replies

  13 years, 9 months ago

  By: SkyBVI

• return xml data type as columns

  I'm just researching a project as this point. It sounds like it could be very fluid and have chang…

  dough-378918

  2 replies

  13 years, 9 months ago

  By: dough-378918

• What's wrong with my view?! ORDER BY problem.

  So I create a view with this SELECT: SELECT TOP (100) PERCENT DBName, MetricDate, NumPages, Ori…

  FreeHansje

  9 replies

  13 years, 9 months ago

  By: Matt Miller (4)

• Fulltext not working while i removed all words from noiseenu.txt

  Hello, I have following data in "title" column. The column "title" is included in my FullText searc…

  Shamshad Ali

  7 replies

  13 years, 9 months ago

  By: patrik.nilsson

• Use a cursor to Insert data from one table to the other

  Hi Folks, How can I achive this. I have a table A (AcctID bigint not null, ContactId,Amount,TransDa…

  LOOKUP_BI-756009

  8 replies

  13 years, 9 months ago

  By: ColdCoffee

• Solving SUDOKU thru SQL Code

  Recently i cross through one article where it says the following SQL Code used in oracle to solve S…

  Jus

  27 replies

  13 years, 9 months ago

  By: Cadavre

• COALESCE() - Does it calculate every value or does it stop when it gets a not NULL

  title says it all really. I have a Coalesce() statement that has three fairly complex queries in it…

  aaron.reese

  10 replies

  13 years, 9 months ago

  By: Bruce W Cassidy

• "Select Where In" using a parameter?

  Hi there, this seems like it should be simple, but is a little frustrating! I have an sp which take…

  Joe90-646727

  20 replies

  13 years, 9 months ago

  By: tfifield

• i want out of sp_helplogin sp into table

  Hi All, Please anybody provide me a script which gives the output of sp_helplogins in the table.

  shilpa.shankar87

  5 replies

  13 years, 9 months ago

  By: Lowell

• Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing"

  Hi, I got the error "Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSAC…

  kuppurajm

  4 replies

  13 years, 9 months ago

  By: Adi Cohn-120898

• Stored Procedure with Totals

  Hey Everyone! I need help with a stored procedure that I am trying to formulate, I have two stored …

  staindshady_03

  4 replies

  13 years, 9 months ago

  By: Jeff Moden

• Convert column results to coloumn headings

  create table #temptable(Name varchar(25)) GO insert into #temptable values('Larry'); insert into #t…

  lcarrethers

  5 replies

  13 years, 9 months ago

  By: Eugene Elutin

• ALOHA!!! I need to convert a datetime field to Hawaiian time zone for the T-SQL herein.

  The "FlightDate" (e.g. CONVERT(VARCHAR(10), f.FlightDate, 101)) in the T-SQL below and needs to be …

  davidsalazar01

  6 replies

  13 years, 9 months ago

  By: davidsalazar01

• merging values and nulls

  Hi All, I have two tables of this structure: MonthYear, Location, Metric 1, Metric 2 In table 1, as…

  greg.bull

  12 replies

  13 years, 9 months ago

  By: greg.bull