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...

One doubt, will a parent have only 3 childs? If it is, then i have the code for you! Please clarify!

INSERT INTO kurs.utbetalning (personal_id)

SELECT personal_id FROM kurs.personal

GO

and I get the following error message:

Msg 515, Level 16, State 2, Line 2

Cannot insert the value NULL into column 'loneperiod', table 'kursdatabas.kurs.utbetalning'; column...

Rectified the code again with the Vairables yoyu used!

Code:

Select Emp_Name,Emp_Surename,Emp_Shomareshenasname,Edarekol_Id,Vahed_Id

from Employee

where

(Emp_Name=Case when @VarEmp_Name is not null Then @VarEmp_Name Else Emp_Name end)

And

(Emp_Surename=Case when @VarEmp_Surename is not null Then @VarEmp_Surename Else...