T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION

  I executed a script with many commits in in. However, while executing the script together i got a …

  nabajyoti.b

  5 replies

  16 years, 10 months ago

  By: Wesley Norton

• Passing a named instance to a SQL job

  Hey all, I'm hoping someone has dealt with this before. I have a SQL Job that uses a command line t…

  samartel

  1 replies

  16 years, 10 months ago

  By: ps.

• tsql to store converted values

  I have a table of values that I am importing to my database. The data is coming in as: Participant…

  lpatrick

  9 replies

  16 years, 10 months ago

  By: Jeff Moden

• convert varchar to datetime

  Hi, I apologize if someone has asked this again in past, but it is something urgent. I have a varch…

  j.grimanis

  3 replies

  16 years, 10 months ago

  By: allen davidson

• How to call a web service From TSQL?

  I have a project in hand to call a web service and store its results in a table. I am doing a feasi…

  Aparna-1

  2 replies

  16 years, 10 months ago

  By: Aparna-1

• if qty_requested =8 then display the information 8 times.

  I have a table that shows the order information. I want to create a statement that takes the qty_re…

  twdavis-893252

  7 replies

  16 years, 10 months ago

  By: Jeff Moden

• Order by Clause does not work with Select * into #temp statement

  Hi, I have a query as follows, SELECT IDENTITY(int, 1,1) AS RecId, FROMTerm INTO #TempRates FROM Ra…

  sushil.tuladhar

  7 replies

  16 years, 10 months ago

  By: sushil.tuladhar

• Select integer ranges

  Hi there, I have a simple table with 3 columns CREATE TABLE [dbo].[Ranges]( [RangeId] int NOT…

  bmoynihan

  12 replies

  16 years, 10 months ago

  By: Mark Cowne

• INSERT with computed column

  Well, probably many of you won't find it strange, but I was surprised of the behaviour of INSERT wi…

  spaghettidba

  6 replies

  16 years, 10 months ago

  By: spaghettidba

• export resultset to excel

  I have a setup as below: I have a stored proc which pulls data from various tables and returns a re…

  gyessql

  4 replies

  16 years, 10 months ago

  By: Wesley Norton

• Changing the default date format of SQL server 2005

  How to change the default Date format. I have default language set up as Spanish. But it uses the U…

  ss-457805

  13 replies

  16 years, 10 months ago

  By: Lynn Pettis

• How to find a COLUMN name and the Condition Existing...

  Dear Experts, Please help me in fixing this : I Have a database TESTDB ; Contains 800+ tables ; whi…

  - Win.

  4 replies

  16 years, 10 months ago

  By: - Win.

• Need help with SQL statement

  Hi all, First time user of SQL here, not very familiar with SQL statement, need help with this situ…

  tawfey

  1 replies

  16 years, 10 months ago

  By: Lowell

• View based off table Variable?

  Hello everyone. I have a bit of a challenge I am attempting to resolve but keep coming up at dead …

  shannonjk

  2 replies

  16 years, 10 months ago

  By: shannonjk

• How to return result code from VB 6.0 invoked SQL 2005 stored proc

  How do I code a SQL 2005 proc that will deliver an output returncode of 0 (to a VB GUI) if successf…

  Express12

  4 replies

  16 years, 10 months ago

  By: mj12