T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• datetime to month - year

  How convert to do Datetime to month-year input - 2009-01-23 1:12:52.253 output needed- Jan-2009? I …

  rpatil22

  6 replies

  15 years ago

  By: Jeff Moden

• Tuning slow query

  SELECT DISTINCT A.Status FROM dbo.Test1 A LEFT JOIN dbo.Test2 B ON A.Status= B.Status WHEREB.Statu…

  LOOKUP_BI-756009

  13 replies

  15 years ago

  By: Malcolm Daughtree

• where not exists...

  Hi, I feel like I'm blowing a tire on this one...Shouldn't my results show 'abc'? What is wrong wi…

  Marcus Farrugia

  4 replies

  15 years ago

  By: Marcus Farrugia

• Progress of insert

  Is there any way I can see how far along an insert statement is? We are getting ready to insert 15…

  Meet George Jetson

  1 replies

  15 years ago

  By: Pam Brisjar

• How to sum the result and calculate the average

  Hi Below one is my sample table structure Declare @t table ( id int, name nvarchar(50), counts …

  KMPSSS

  4 replies

  15 years ago

  By: KMPSSS

• Load the data from XML file to Sql Server 2005 database

  hi i hava a problem to load the data from XML file to Sql Server 2005 data base. XML data is prese…

  vkoka

  5 replies

  15 years ago

  By: krishusavalia

• Data in a Tree

  Hi, I have two tables. Table 1 "#tempNodes" which holds a unique list of Nodes. Table 2 "#tempTree…

  Grinja

  4 replies

  15 years ago

  By: Grinja

• convert xml variable data as a table

  Hi all, How to convert a xml file to a table DECLARE @xml AS XML set @xml= N' <books> <ca…

  DURGESH-769360

  1 replies

  15 years ago

  By: VSSGeorge

• Custom Time Function

  Hi, I am trying to create a function which will extract the time element of the getdate function a…

  Abs-225476

  3 replies

  15 years ago

  By: Mike Smith-208409

• Huge TMP2F6.tmp file

  When I run a TSQL query at my desktop machine against a database residing on a remote server the qu…

  SQL33

  2 replies

  15 years ago

  By: SQL33

• Update Issue

  I have Table A ID LNAME RID 1 Mike A 2 Jim B 1 …

  rocky_498

  9 replies

  15 years ago

  By: John Rowan

• default parameter in a function

  I want to create a function that returns all values from a table as at a specific date. ANd if the …

  Paul McCurdy

  3 replies

  15 years ago

  By: Paul McCurdy

• Need help with additional SUM for SQL Pivot

  I currently have a table in this format: DOCDATE | Ship | Vendor | PassengerCount | TrxFullPrice | …

  npeters 86796

  2 replies

  15 years ago

  By: Jeff Moden

• stored procedure results to excel file.

  I have a stored procedure with a simple select statement. How do I export the select results to an …

  mtz676

  7 replies

  15 years ago

  By: pasbanrule

• Running total across specific customers without Loop

  Hello everyone. Got a bit of a challenge. All code for testing is below. What I am looking for i…

  Fraggle-805517

  2 replies

  15 years ago

  By: Fraggle-805517