T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Trying to convert number range (1-5) to numerical progression (1,2,3,4,5)

  I have downloaded an array from the us postal service for zipcodes and where the first 3 digits are…

  tony.hayes

  17 replies

  17 years ago

  By: Jeff Moden

• Reducing common data into fewer rows.

  I have a set of data, approximately 15,000 lines which contains information about products and thei…

  macwiz

  6 replies

  17 years ago

  By: macwiz

• Loop Stored Proc

  Hi all, Can anyone advise how I would go about putting a stored procedure which returns an integer …

  dt293

  2 replies

  17 years ago

  By: Tomm Carr

• How to send an email alert if the update process to a database fails?

  Hi, Is there any means by which we can identify whether an update has been made to a database. Thi…

  donnelcyril

  2 replies

  17 years ago

  By: Luke L

• generating records from a single record

  So I have two tables with similar structures CREATE TABLE [dbo].[ABC]( [COLL] [char](6) NOT NULL, …

  sqlstar2011

  2 replies

  17 years ago

  By: sqlstar2011

• get hourly combine data

  I have data like this in one column and want to get the data by hour for 24 hours. how can i get it…

  pat-261672

  4 replies

  17 years ago

  By: Lowell

• Passing number of rows to be returned as a SP parameter

  Hi all. I have a stored proc which currently return the top 4 rows from a view. What im looking to …

  gavin.duncan-770062

  12 replies

  17 years ago

  By: Michelle Ufford-459603

• [newbie][error] Cannot insert NULL values to identity column

  I'm trying to pass values within an insert statement, however, I'm not sure what is the best way to…

  Jon80

  1 replies

  17 years ago

  By: noeld

• Date stored as a Decimal

  Hello, I am querying a table and can get the required results all ok, however all of the date field…

  nathan.kennedy

  2 replies

  17 years ago

  By: Maxim Picard

• Inner and Outer Loop to add count to existing table data

  It seems the more I get into SQL the more it appears I am also getting into Programming! Being "old…

  DB_Newbie2007

  8 replies

  17 years ago

  By: Jeff Moden

• Very Simple User Define Function Returning Zero

  Hi folks Here's the UDF: CREATE FUNCTION [dbo].[GET_EMA_Multiplier](@Period INT) RETURNS FLOAT AS B…

  Wayne-950947

  4 replies

  17 years ago

  By: Wayne-950947

• Date stored as a Decimal

  Hello, I am querying a table and can get the required results all ok, however all of the date field…

  nathan.kennedy

  1 replies

  17 years ago

  By: Gail Shaw

• Calling VBScript or command file from within T-SQL without xp_cmdshell??

  Hi Can someone give me a hint if it's, in any way, possible to call up a vbscript without using xp_…

  Helmut Nielsen

  2 replies

  17 years ago

  By: Jeff Moden

• fixed length format file

  How can I create a fixed length file using SSMS? I assume .. i have to select 'result to file' and …

  MuditGupta

  4 replies

  17 years ago

  By: Jeff Moden

• How to delimit ‘-’ string?

  Hi all: Given: ‘111111-0000-9999’ Return: SeqResult 1111111 20000 39999 Do we have a function …

  jan michael woo cerna-336610

  9 replies

  17 years ago

  By: jan michael woo cerna-336610