Viewing 15 posts - 46 through 60 (of 117 total)
Do you mean something like this?
SELECT sno,Ename,DOJ,Datediff(dd,DOJ,Getdate())
FROM tenure;
Go here for more info on datediff.
March 8, 2011 at 3:19 am
Forums work best best on a question response basis. You provide a well formulated question, we try to respond with an answer. Its a simple formula that has been tried...
March 8, 2011 at 3:10 am
Why would you want to do that? Genuine question, as there may be a better way of doing what you are trying to achieve if we have more information.
March 7, 2011 at 8:37 am
Hi
It might be because you are mixing old and new style joins in one statement. Do either of the following two work?
SELECT
invoice.contactid, invoicedetail.invoiceid, RecType=2, DetailID=invoicedetail.id, invoice.trandate, Reference=ISNULL(ItemCode,''), Details=ISNULL(Description,''), ReceiptNotes='',...
March 2, 2011 at 6:08 pm
I find Google quite useful when I can't remember the syntax of a command: http://www.mssqltips.com/tip.asp?tip=1593
March 2, 2011 at 4:51 am
Yes.
March 2, 2011 at 4:06 am
As Jason said, Firebrand courses are very intensive revision courses. If attendees have little or no prior knowledge of the technologies involved in the course, then they are unlikey to...
March 2, 2011 at 3:48 am
MDX is something I have not had the opportunity to delve in, but wanted to know more about. This is a great introduction and I look forward to the rest...
March 2, 2011 at 3:10 am
You might want to look at Patterns of Enterprise Architecture Integration. It covers a lot if the technologies you may come across.
February 24, 2011 at 12:10 pm
You are to undertake this assignment individually, although you may discuss ideas with your fellow
students.
For the purpose of this coursework, the following
definitions apply:
It looks more like...
February 24, 2011 at 6:35 am
Do Table1 and ConfigTable only have 1 row? If not, then this will never work the way I think you want it to.
Whenever you do an insert or an update...
February 23, 2011 at 9:24 am
How about a nicely worded email with the release notes detailing the new or extra functionality. Alternativley a link to a wiki that contains the documentation if there is one.
February 23, 2011 at 5:18 am
Bhuvnesh (2/22/2011)
Thanks Steveb but it means if i have 100 columns i need to do 100 union.That would not be a nice approach
The you would need to normalise your design....
February 22, 2011 at 3:03 am
OK
We have two issues here. First, you can't use TSQL variables in SQL CE. Secondly, SQL CE processes single commands through a connection. So you need to do the following...
February 17, 2011 at 8:41 am
Will you be executing this code from a .Net application?
February 17, 2011 at 4:54 am
Viewing 15 posts - 46 through 60 (of 117 total)