Viewing 15 posts - 8,041 through 8,055 (of 13,460 total)
a_ud (2/28/2011)
PS: can't you create 3 calculated fields F1, F2, F3 where F1 exists only when ContactType is Phone (and shows Contactinfo), and same for F2 and F3?
yes, you can;...
February 28, 2011 at 10:58 am
http://jobsearch.monsterindia.com/searchresult.html?fts=sql&loc=
yep...monsterindia.com...easy enough to find once you know you want to search fro "sql jobs india"
February 28, 2011 at 8:35 am
what about experience in programming languages?
Most of the people we hire in my shop for example are C# or vb.net developers, and we look for SQL skills in that mix.
Unfortunately,...
February 28, 2011 at 8:27 am
I think you can do what you want as a set of case statements
let me know if this model works for you:
SELECT
OtherFields,
CASE
WHEN...
February 28, 2011 at 6:42 am
I agree With Dave B; bcp, or BULK INSERT, or openquery would all be blazingly fast in comparison;
I've used bulk insert to load files with a million rows in under...
February 28, 2011 at 5:34 am
for the executable and services, you don't have a choice...it must be installed on the same drive as the operating system.
after the install, you can move most of the...
February 26, 2011 at 8:45 pm
Also because mine is purtier!
one of the main reasons i did this was formatting, and removing/pruning items that are optional in a table script, so the don't need to...
February 25, 2011 at 11:15 am
well, i've got two variations of this...one returns the definition as a single varchar(max), and the other splits the same varchar(max) on CrLf so it's multiple rows.
one purpose is standardization...developers...
February 25, 2011 at 10:28 am
the drop of a trigger would be in the default trace, so you might be able to narrow down if it's a person or a process based on teh hostname,...
February 25, 2011 at 8:58 am
Grant said it all; you'll have to provide more details to get more relevant answers.
the only thing i can offer is it is my experience that for some specific...
February 25, 2011 at 7:42 am
chitturiii (2/25/2011)
Thanks Lowell...I think the query goes on as:
Select top 1 sal from employee where sal in (select top 2 sal from employee order by sal desc)
order by sal
that...
February 25, 2011 at 6:34 am
here's an example command for attaching a database; you'd have to do as suggested and script out the dynamic portions...the database name and the file path.
it all starts with the...
February 25, 2011 at 5:43 am
this is a fairly easy question, and it comes up a lot in homework type situations; so I'll give you a hint and information rather than a full answer:
there's two...
February 25, 2011 at 5:33 am
the BULK INSERT command doesn't use xp_cmdshell it basically has the same functionality as bcp(which does require xp_cmdshell);
here's an example of multiple files via BULK INSERT...
this example assumes I had...
February 24, 2011 at 2:39 pm
William this seems to work for me: maybe you missed the double join?
SELECT
c.COLUMN_NAME,
c.ORDINAL_POSITION,
cls.DATA_TYPE
FROM
INFORMATION_SCHEMA.TABLE_CONSTRAINTS p
INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE c
ON c.TABLE_NAME...
February 24, 2011 at 1:42 pm
Viewing 15 posts - 8,041 through 8,055 (of 13,460 total)