T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Generated Sequences with SQL Server

  Does SQL Server Express support all programmability features? Is a sequence a function or DDL trigg…

  sasansamani

  12 replies

  12 years, 6 months ago

  By: sasansamani

• Arithmetic overflow error converting numeric data to data type numeric

  Dear Sir, I am in great trouble, I have a table which contain two fields my table structure is Col…

  deba_20032004

  2 replies

  12 years, 6 months ago

  By: Cadavre

• append sp

  Hi, not quite sure if this is info info...but i wanna convert this sp to an append sp. with rows a…

  sdhanpaul

  5 replies

  12 years, 6 months ago

  By: sdhanpaul

• datetime stored as integer, please help!

  Using SQL2005, I'm importing call data from my Cisco Communications Manager. The data is a text fi…

  ericb1

  18 replies

  12 years, 6 months ago

  By: devilsid

• Concatenating Rows to create WHERE clause.

  Hi, Im creating a dynamic where clause where the operators and conditions are stored in a table: c…

  DiegoPeña

  2 replies

  12 years, 6 months ago

  By: DiegoPeña

• Computed column for a date

  I currently have a table that contains patient information. There is a trigger on this table for e…

  pamozer

  4 replies

  12 years, 6 months ago

  By: GSquared

• Update Table with Join NOT RBAR

  Hello, My problem today is that when this company started they had no standards for data entry. So …

  nfs_john

  3 replies

  12 years, 6 months ago

  By: Sean Lange

• Stored Proc - Nullable Parameters for optional filtering - handling LinkTable LEFT JOINs

  Hey all, Pretty long title, but the problem itself is fairly simple to explain. Suppose I have the …

  kramaswamy

  9 replies

  12 years, 6 months ago

  By: Steven Willis

• Linked Server Problem

  I'm having a problem selecting from an Excel linked server... 1. Create a new simple Excel file at …

  darren_w99

  6 replies

  12 years, 6 months ago

  By: rakeshsqltips

• Create A stored proc template that checks if exists then Alter otherwise create

  I am trying to create a template for our developers for stored procedures. I want the logic to be …

  pamozer

  10 replies

  12 years, 6 months ago

  By: Eugene Elutin

• transpose rows into columns

  hello all, i have to transpose rows into columns. it goes like this. i have a column say for eg: NA…

  sriharivittal1

  12 replies

  12 years, 6 months ago

  By: Jeff Moden

• Concurrent access to duplicate records

  Hi all, Got a situation I haven't had to deal with before. Basically, I have a table which stores p…

  kramaswamy

  5 replies

  12 years, 6 months ago

  By: kramaswamy

• automate t-sql

  I'm not an expert at T-SQL, so I hope someone can help me automate this. Currently, I'm doing this …

  tai985

  8 replies

  12 years, 6 months ago

  By: Lowell

• SSIS Script Task

  Can anyone help me with adding log in information to a script task which goes to a webpage? The cu…

  kwyman

  1 replies

  12 years, 6 months ago

  By: kramaswamy

• Alternate way for SELF JOIN

  Hi All, I have a table like below. create table fund( fund_id integer primary key not null, …

  karthik M

  1 replies

  12 years, 6 months ago

  By: kramaswamy