Viewing 15 posts - 1,471 through 1,485 (of 1,923 total)
One doubt, will a parent have only 3 childs? If it is, then i have the code for you! Please clarify!
May 25, 2010 at 5:49 am
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...
May 25, 2010 at 3:11 am
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...
May 25, 2010 at 2:35 am
The problem was a missing "(" and "end"
Rectified code:
Select Emp_Name,Emp_Surename,Emp_Shomareshenasname,Edarekol_Id,Vahed_Id
from Employee
where
(Emp_Name=Case when 'a' is not null Then 'a' Else Emp_Name end)
And
(Emp_Surename=Case when 'b' is not null Then 'a' Else...
May 25, 2010 at 2:33 am
This wil help you out!
Select personal_id
INTO <Some_Table_Name>
FROM <Existing_Table>
May 25, 2010 at 2:21 am
Wow, it is so nice and warm when people appreciate! Thanks Hoss! 🙂
May 24, 2010 at 11:17 pm
Hi there, try something like this:
-- The message that will be dispayed in the <BODY> element of the Mail
-- Please note taht explicit typing of <BODY> is not required as...
May 24, 2010 at 11:00 pm
Probably, you wil lhave to take a look at the following article on Dynamic Cross Tabs , written very well one of the SQL gurus , Jeff Moden;
Click this to...
May 24, 2010 at 5:05 am
florim As i see from yours solutions i see that if ID jumps (is not sequence) than that query will not work.
Hi florim, the following is the OP's requirement:
The issue...
May 24, 2010 at 2:20 am
Malavika, you have to PIVOT Products for Products in this case. so your code must look like this:
First, lets set up the test environment:
declare @table table (Product varchar(20), [year] int)
insert...
May 24, 2010 at 12:48 am
Deepak, am not being rude here or harsh here buddy, but did u understand what i had coded? Did u understand the logic behind my code? Hmmm, you dint...
May 23, 2010 at 11:20 pm
Assuming that the ID column will be an INTEGER column, then this one will help you!
Thanks to Jeff for setting up the test environment!
Here is another version of the...
May 23, 2010 at 10:40 pm
NO.. it wont give compile time errors..
May 21, 2010 at 4:48 am
Paul, I guess he is asking "how to permanently change dateformat of the server until his unit tests are over and then change back to original"..:-)
May 21, 2010 at 4:47 am
Viewing 15 posts - 1,471 through 1,485 (of 1,923 total)