Viewing 15 posts - 1,471 through 1,485 (of 1,920 total)
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
Jeff Moden (5/21/2010)
May 21, 2010 at 12:29 am
Don't use INSERT INTO, rather use SELECT * INTO for the new 7 column temp table. Like:
SELECT COL1, COL2, COL2 , COL4, COL5, COL6, NULL COL7
INTO #TEMP
FROM REALTABLE
And then...
May 20, 2010 at 10:24 am
Kannbiran, when u change the dateformat to DMY, the insert statement must also follow suite and contain rows like '01-Mar-2010' or '30-03-2010' etc..
May 20, 2010 at 3:31 am
Viewing 15 posts - 1,471 through 1,485 (of 1,920 total)