Viewing 15 posts - 31,726 through 31,740 (of 59,102 total)
RowanCollum (12/12/2011)
select * from emp where empid in
( select i.value('text()[1]','int')
from (select cast('<i>'+replace(@str,',','</i><i>')+'</i>' as xml) as xlist) s
cross apply s.xlist.nodes('/i')...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 12, 2011 at 5:11 am
Heh... didn't mean to turn it into a "me" post. I actually know quite a few folks that make more than their bosses.
--Jeff Moden
Change is inevitable... Change for the better is not.
December 11, 2011 at 12:40 pm
I've never found a decent use for it before but this sounds like the perfect use for an "INSTEAD OF" trigger against a view. It would guarantee that any...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 11, 2011 at 9:36 am
From the article:
Will the DBA role evolve naturally from being a "caretaker of data", to "interpreter of data", for the good of society?
I believe that anyone who doesn't already think...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 11, 2011 at 9:23 am
Considering that folks in HR, hiring managers, and many direct managers don't actually know what a DBA does (especially a "Hybrid" DBA) or the value they bring to an organization,...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 11, 2011 at 9:06 am
texpic (12/10/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
December 11, 2011 at 8:58 am
1Ankit1 (12/11/2011)
If your requirement is to insert all those rows at a time into the concerned table, you might as well try using the BULK INSERT command.)
Very nice post on...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 11, 2011 at 8:40 am
haivenki3 (12/10/2011)
I would like to scramble two tables( Table A and Table B) for ID columns, which doesn't have any constraints. After scrambling I would...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 11, 2011 at 8:31 am
ALZDBA (12/11/2011)
That's one of the reasons some of us try to stick with ansi sql and never use proprietary language features.But, as Jeff mentioned, excel.
Heh... It's a personal belief, for...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 11, 2011 at 8:25 am
bitbucket-25253 (12/10/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
December 11, 2011 at 8:22 am
You don't really need a function for this although you could certainly put it in a function for programming consistency.
SELECT DATEDIFF(yy,BirthdayColumn,GETDATE())
- CASE
...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 11, 2011 at 8:14 am
PaulB-TheOneAndOnly (12/10/2011)
luis martin ortiz barrutia (12/10/2011)
Is a good practice to put a state field in a table?, so if it is 1 means active, 0 is deleted, so i can...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 11, 2011 at 7:59 am
Marios Philippopoulos (12/9/2011)
Is there an elegant way to find out programmatically which columns have different values in each pair of rows?
1Ankit1 (12/10/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
December 11, 2011 at 7:54 am
As a side bar, storing dates as separate columns for Year, Month, and Day normally creates more problems than it's worth especially when it comes to future aggregations for reporting....
--Jeff Moden
Change is inevitable... Change for the better is not.
December 11, 2011 at 6:54 am
vino5786 (12/9/2011)
In a Blob column we storing mail contents, comments, documents etc.,
That content contains credit card number, While sending it to screen we need to mask that...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 11, 2011 at 6:49 am
Viewing 15 posts - 31,726 through 31,740 (of 59,102 total)