Viewing 15 posts - 2,476 through 2,490 (of 9,643 total)
You can get the list of database users from sys.database_principals.
April 13, 2011 at 10:39 am
You can also use CHARINDEX();
IF OBJECT_ID(N'tempdb..#test', N'U') IS NOT NULL DROP TABLE #test;
CREATE TABLE #test(val VARCHAR(10));
INSERT INTO #test
(
...
April 13, 2011 at 10:37 am
In the Flat File Connection manager you can tell it to skip the first row ("Proprietary") by setting Header Rows to Skip to 1 and that the second row is...
April 13, 2011 at 10:26 am
APPLY was added in 2005 so that wouldn't work in 2000.
If SchedName is unique then I see no reason why a simple UNION wouldn't work. Like this:
SELECT
...
April 13, 2011 at 10:06 am
CirquedeSQLeil (4/13/2011)
GilaMonster (4/13/2011)
CirquedeSQLeil (4/13/2011)
Leave the contract early without notice and prior to completing the stated work.What does his contract require? Solo or contracting house?
Solo contract and it required him to...
April 13, 2011 at 9:59 am
CirquedeSQLeil (4/13/2011)
Leave the contract early without notice and prior to completing the stated work.
I wouldn't do it unless there were major extenuating circumstances.
What's the wording of the contract? Is...
April 13, 2011 at 9:54 am
I'm sure y'all already know, but today is the last day of $299 price for SQLRally. Goes up to $349 tomorrow and then $399 May 1st. Also if...
April 12, 2011 at 11:01 am
GilaMonster (4/11/2011)
Jack Corbett (4/11/2011)
GilaMonster (4/11/2011)
GSquared (4/11/2011)
GilaMonster (4/11/2011)
Ok, had enough complaints about the lizard. Let's see if this is better.What/who is it?
And what was wrong with the lizard?
Can't recall, I deleted...
April 11, 2011 at 7:52 pm
GilaMonster (4/11/2011)
GSquared (4/11/2011)
GilaMonster (4/11/2011)
Ok, had enough complaints about the lizard. Let's see if this is better.What/who is it?
And what was wrong with the lizard?
Can't recall, I deleted the PMs. Complaining...
April 11, 2011 at 2:04 pm
Stefan Krzywicki (4/11/2011)
GilaMonster (4/11/2011)
Stefan Krzywicki (4/11/2011)
April 11, 2011 at 1:58 pm
bitbucket-25253 (4/9/2011)
April 9, 2011 at 8:17 pm
I definitely think there is enough material on SQL Agent to fill an hour. The only way to be sure is to write the presentation and then practice it....
April 9, 2011 at 8:17 pm
Stefan Krzywicki (4/8/2011)
It was very nice to meet you. Did you want my agency contacts so you can call them?
I certainly won't turn any down.
April 8, 2011 at 8:14 pm
CirquedeSQLeil (4/6/2011)
GSquared (4/6/2011)
Lynn Pettis (4/6/2011)
Stefan Krzywicki (4/6/2011)
CirquedeSQLeil (4/6/2011)
Roy Ernest (4/6/2011)
GilaMonster (4/6/2011)
Lynn Pettis (4/6/2011)
Star Trek (the Original)My mother loves both that and Thunderbirds.
Gail, Low blow aimed at Lynn... 🙂
I remember...
April 8, 2011 at 8:07 pm
Grant Fritchey (4/5/2011)
Brandie Tarvin (4/5/2011)
Grant Fritchey (4/5/2011)
April 8, 2011 at 8:00 pm
Viewing 15 posts - 2,476 through 2,490 (of 9,643 total)