Viewing 15 posts - 16 through 30 (of 56 total)
Thank you both for the replies...
And to save on the knuckle beating with a ruler for future post I have reread the best practices on asking questions article.
May 9, 2012 at 8:46 am
Yes that PIT time is generated when the SSIS job runs.
February 1, 2012 at 6:15 am
Hi there again. I hate to bug you but I was hoping to pick your brain again on this topic.
We have an SSIS job that runs and pull data into...
January 31, 2012 at 1:49 pm
You have helped me out so much Thank you... I can see how it all works now.
January 31, 2012 at 12:39 pm
My apologies for not explain it more. This is to pull a TimeCard log that shows what hours have been booked 1 week past and 13 week ahead. Our time...
January 31, 2012 at 12:13 pm
That ROCKS!!! Thank you
One quick question I just found out they want me to pull one week back so for example it I was running this today they want from...
January 31, 2012 at 11:52 am
I'm using SQL server 2008 R2
January 31, 2012 at 11:42 am
Thank you for fast replies...
With the Declare can I create this as a View? I was getting the error message Incorrect syntax near the keyword 'DECLARE'
DECLARE @DateStart DATETIME = CONVERT(CHAR(10),GETDATE(),121);
DECLARE...
January 31, 2012 at 11:37 am
I have a staging table that the users will connect to and pull this data into excel.
Right now it pulls in 52 weeks ahead. So the full year of 2012...
January 31, 2012 at 11:14 am
Hi - It is set to "True"
I attached an image of it.
Thanks,
D-
December 22, 2011 at 6:11 am
ok let me see if I can provide what is needed. Here is the script broken down with no filters added. The new column name is in bold with the...
December 7, 2011 at 6:52 am
Thank you for the tips I was wondering can you suggest how I would or even if I could Inner Join two tables that do not have PK related?
For example...
December 6, 2011 at 12:20 pm
So what's wrong with the results?
Sorry after rereading my post I realized that I put in the wrong Table name I need to add. I need to add a Column...
December 6, 2011 at 11:27 am
Will do the next time I post. I found my answer. Thanks...
December 2, 2011 at 12:01 pm
Thank you for the responses. Looks like we will have to do the
Allow Excel users to access a regularly updated copy of the table
December 2, 2011 at 11:05 am
Viewing 15 posts - 16 through 30 (of 56 total)