Viewing 15 posts - 32,776 through 32,790 (of 59,102 total)
What's really spooky to me is how little a lot of job applicants know about the basics and how many of them don't know what they don't know. I...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 23, 2011 at 2:02 pm
I'm talking about the first line of the SELECT list.
--Jeff Moden
Change is inevitable... Change for the better is not.
August 23, 2011 at 1:41 pm
Something's not right here... you should be getting an error about not being able to resolve the Customer_ID column because it lives in both tables and you don't have a...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 23, 2011 at 12:25 pm
The best way, IMHO, is to write a view and create and "External Data Source" on the spreadsheet.
--Jeff Moden
Change is inevitable... Change for the better is not.
August 23, 2011 at 12:04 pm
No... you can't use it in a view as it currently is. A view must be a single query. You'll need to "fold" the dates table in as...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 23, 2011 at 10:24 am
ChrisM@Work (8/22/2011)
Anybody recruiting presently? We've been recruiting a DBA and a TSQL developer (with some role...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 22, 2011 at 11:26 am
lance.kentwell (8/21/2011)
Jeff Moden (8/21/2011)
lance.kentwell (8/21/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
August 22, 2011 at 10:02 am
GilaMonster (8/21/2011)
Jeff Moden (8/20/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
August 21, 2011 at 9:47 am
SQLkiwi (8/20/2011)
Jeff Moden (8/20/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
August 21, 2011 at 9:46 am
Consider the following:
[font="Arial Black"]The answer is always "NO" unless you ask.[/font]
Go for it!
--Jeff Moden
Change is inevitable... Change for the better is not.
August 21, 2011 at 9:44 am
arshad7887 (8/20/2011)
SPLIT Varchar in sql server
User Defined Method
CREATE FUNCTION SplitString
(
--...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 21, 2011 at 9:13 am
lance.kentwell (8/21/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
August 21, 2011 at 9:09 am
Prasanthi Reddy (8/20/2011)
I tried as create procedure GET_HEIRARCHY_CODE(@str varchar(50),@code varchar(30) OUTPUT)
AS
BEGIN
-----statements
RETURN @CODE;
END
but while executing it is asking to pass value for @code also..
can u pls explain how...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 20, 2011 at 9:58 pm
lance.kentwell (8/20/2011)
These two results would be the inserted into a table with columns called "Month" and "Year"Any suggestions?
Yes, but not the one you want (which the others have already covered...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 20, 2011 at 9:50 pm
aaron.reese (8/19/2011)
I have a Coalesce() statement that has three fairly complex queries in it's array. One of these is extremely resource hungry and takes some...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 20, 2011 at 9:46 pm
Viewing 15 posts - 32,776 through 32,790 (of 59,102 total)