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...

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...

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...

that's what i thought, but when i tested it via TSQL, it...

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...

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...

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...

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,...

distribution...

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...

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...

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...

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...

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...

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...