I would also recommend you to go through the following article on how to post readily consumable data

CLICK HERE FOR FORUM POSTING ETIQUETTES - JEFF MODEN[/url]

Hope the code above this...

Hi there, here is a piece of code that wll do what you wanted:

As you are first time poster, i took the onus on my side to create DDLs for...

I echo skcadavre here ; Long verbal questions wont attract anyone; but when u post the following, i tell you, you will receicve excellent tested code back:

so, Please post;

1. Table...

You have to change the default keyboard lay-out of SSMS 2008 ; follow thsi path to change it

1. Tools

2. Options

3. Environment -> Keyboard

4. Keyboard Scheme --> SQL Server 2000

Hope...

Hi there, as Gail said, you will have to look up at PIVOT.

For starters, i have coded for your requirement, but this is only w.r.t the sample data you provided!...

Anamika, excellent work done in posting the necessary tables , sample data and an equally good "desired result".. Kudos to you!

Now for your desired result, try this query:

SELECT TT.ID,

...

Oh yeah, arun, sorry for...

Hi Mohan , the following code wil help you out!

--===== Create and populate the Tally table on the fly

SELECT TOP 11000 --equates to more than 30 years of dates

...

You're welcome, sahasam!

Small example depicting the retrieval of a value from the dynamics-sql to the calling code:

The dynamic-sql take a divisor from the outside, calculates the division and returns the quotient to...

Jeff Moden (5/25/2010)

---

ColdCoffee (5/25/2010)

---

WayneS, as a classic question, do u really think ISNUMERIC can be used as an is_all_digits functions? There is nothing that a super fast coder like you...

Sample data and table:

DECLARE @Employees TABLE

(

EMPLID INT,

EMP_STATUS VARCHAR(3),

EMP_IDENTITY VARCHAR(5)

)

INSERT INTO @Employees (EMPLID ,EMP_STATUS ,EMP_IDENTITY)

SELECT 121210,'A','A321' UNION ALL

SELECT 121211,'L','B123'

DECLARE @Tests TABLE

(

EMPLID INT,

TEST_ID VARCHAR(5),

TEST_DT DATETIME

)

INSERT...

WayneS, as a classic question, do u really think ISNUMERIC can be used as an is_all_digits functions? There is nothing that a super fast coder like you don't know and...

You're welcome , desai!

As you are first time poster, you probably wont be aware of how to post the data in ready-to-use format, so i took the onus on my side and created...