Viewing 15 posts - 5,326 through 5,340 (of 13,465 total)
well, BULK INSERT and BCP -IN both have some big assumptions: the file is on/accessible from the server itself, and of course permissions on both the destination table and...
June 25, 2012 at 12:33 pm
I don't think when a statsitic has been updated/created is exposed;
however, you can use a formulat to determine if any existing statistics ned to be updated ro not;
I slapped this...
June 25, 2012 at 11:13 am
this thread is a duplicate of your previous thread here:
http://www.sqlservercentral.com/Forums/Topic1320423-392-1.aspx
both dwain.c and Chris@home, both posters I respect enourmously, gave you a couple of solutions, but you reposted your same question...
June 25, 2012 at 10:49 am
GSquared (6/25/2012)
The most likely problem is that the database is in Compatibility level 80 (or earlier). Check that.
that's what i thought, but when i tested it via TSQL, it...
June 25, 2012 at 8:11 am
What have you tried so far? That reads like a paraphrased homework assignment , so id like to see what youve tried
.
do you have the ddl for the table in...
June 23, 2012 at 3:22 pm
ok i'm not sure how your calendar table is constructed.
my calendar table has a row for each date,a s well as a flag for IsWorkDay or not.
with my version, the...
June 22, 2012 at 3:34 pm
here's a WAG, but it only seems accurate for the the periods that have three months in them
With MyCTE (Date,Employee,Units)
AS
(
SELECT CONVERT(datetime,'2012-05-01'),'Creamcheese,Suzy',4348 UNION ALL
SELECT '2012-04-01','Creamcheese,Suzy',3482 UNION ALL
SELECT '2012-03-01','Creamcheese,Suzy',2743...
June 22, 2012 at 12:32 pm
not sure how many posters here will be familiar enough to debug php and mysql functions;
with luck there might be a few folks out of the huge group of volunteers,...
June 22, 2012 at 12:14 pm
mvillegascuellar (6/22/2012)
Hi thanks for the response,But the distribution listis created in the domain, so it is visible from every other computer. I tested it from other computers and works correctly.
distribution...
June 22, 2012 at 11:24 am
look at the WHERe statement in your query:
where Input_type like 'COLD%'
and Input_type like 'ChartMover%'
it is impossible a string could START with both 'COLD%
and 'ChartMover% at the same time.
it's one...
June 22, 2012 at 10:00 am
As far as I know, TSQL cannot consume Multiple Active Result Sets ;
I've seen multiple posts on the question, but never saw a solution so far.
most posts suggest breaking out...
June 22, 2012 at 8:41 am
my first suggestion is to change the names of the primary keys in the core tables themselves: DoorID, FinishID, and LeafID for example, based on your image you posted.
you (in...
June 22, 2012 at 8:26 am
this one is free, but I don't have any experience with it.:
http://www.architectshack.com/PoorMansTSqlFormatter.ashx
for one that's not too expensive: $50 dollars:, i purchased this one for myself, and i can say i...
June 21, 2012 at 2:59 pm
is it possible that you are using the Express version of SSMS to connect to a full blown Enterprise Instance?
if you do Help...About in SSMS, does yours look like this?
Microsoft...
June 21, 2012 at 2:42 pm
i use a font called "Anonymous", which is a fixed width, sans serif font that looks kind of like verdana, i guess;
i make that my default in a lot...
June 21, 2012 at 2:04 pm
Viewing 15 posts - 5,326 through 5,340 (of 13,465 total)