I think BT is a web hosting provider: http://business.bt.com/domains-and-hosting/web-hosting/

Leave it to the bloody pommies (did I get that right?) to put...

Sorry but I have one other small, nit-picking question.

Why are you using SMALLDATETIME datatype for DOB and DOJ (date of job start?)? Why not use instead the SQL 2008...

Assuming you're working in SQL 2008 (because this is the SQL 2008 forum), the following should be a good example to work from:

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROCEDURE dbo.UpdateE_TABLEs

@eidINT=...

This is actually going to be a bit easier than I initially thought because I thought you only wanted to update one (of many) tables based on conditions being set...

I still need the DDL for E_TABLE1 and E_TABLE2 plus the sample data.

I also now need to know how you plan to pass in the values you're updating from (XML...

Knowing that it probably wouldn't work, I was playing around with this anyway and of course it didn't work.

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROCEDURE dbo.Test AS

BEGIN

DECLARE @sql NVARCHAR(100)

PRINT 'Entering SP'

SET...

Probably but first I'd ask you to provide me with:

1. DDL for two sample tables and...

I'm guessing from past experience that the rowset will return much faster than the XML because I've found that using SQL to construct the XML isn't particularly fast.

I would suggest...

SQL Kiwi (5/16/2012)

Thank...

Thanks. I'm always looking to expand my knowledge in this area.

BTW. Someone recently linked...

Or you can do this:

IF (@lused = '') SELECT @lused = '0', @balleave = 0

ssurekha2000 (5/16/2012)

currently in my front end all this sql statements gets executed on a single button click where in i have begin trans & end trans so that either all...

Three or four choices:

1. Create separate SPs and call the correct one from the front end depending on the table.

2. Create separate SPs and a master SP that gets passed...

Is this something like what you're after?

DECLARE @members TABLE (memberid INT, membername VARCHAR(20), groupid INT)

DECLARE @bills TABLE (billid INT, memberid INT, billamount MONEY)

INSERT INTO @members

SELECT 1, 'Dwain', NULL

UNION ALL SELECT...

Assuming Jeff's assumptions are correct (except that the first blob is always 2 alpha characters), you can construct an ugly, nasty ORDER BY clause:

DECLARE @t TABLE ([name] VARCHAR(100))

INSERT INTO @t

SELECT...