Viewing 15 posts - 11,431 through 11,445 (of 26,486 total)
krypto69 (6/8/2012)
It's a long ugly story, but I'm stuck with creating a report w/SSRS 2005. Those two queries are each used to populate a table on the report. Two...
June 8, 2012 at 1:39 pm
Talking with students at ERAU, their internships are also paid.
June 8, 2012 at 12:24 pm
Beginner2012 (6/8/2012)
I want to save a table from a sql server on my local pc..
Still not sure what you mean. You could export the data to a file and...
June 8, 2012 at 10:34 am
TravisDBA (6/8/2012)
Most people today can't afford to work without pay, but if your situation (living at home,etc.) allows it, then I say go for it.:-D
Depending on the company and/or industry,...
June 8, 2012 at 10:31 am
Beginner2012 (6/8/2012)
Hello,can we create a SQL server table on a PC based on a query on the sql server ?
Thank you
What? Can you explain in greater detail what you...
June 8, 2012 at 10:29 am
michael vessey (6/8/2012)
declare @mydate datetime
set @mydate=GETDATE()
SELECT dateadd(dd,4,CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(DATEADD(mm,1,@mydate))-1),DATEADD(mm,1,@mydate)),101) )
see Pinal Dave's blog post on these
edit: the other suggestions are better than mine - i did a cut an...
June 8, 2012 at 10:28 am
Not enough information to really provide an answer. Please read the first article I reference below in my signature block, it will walk you through the what we need...
June 8, 2012 at 10:04 am
ScottPletcher (6/8/2012)
Might not be a good idea if inserts are expected while also doing the deletes.
Perhaps, if you really normally do INSERTs that would violate the constraint. Hopefully that's...
June 8, 2012 at 10:02 am
SSIS allows you to define fixed format inputs. Had to do this with DTS (SQL Server 7/2000) packages at a previous employer many years ago.
June 8, 2012 at 9:59 am
ScottPletcher (6/8/2012)
I think the point sturner was making was that your order of deletion would violate the foreign key constraint.
That's a good point; yes, I wasn't sure if indeed such...
June 8, 2012 at 9:35 am
You will need to do this a stored procedure.
June 8, 2012 at 9:33 am
Depending on how many rows are returned, you may want to use a temporary table instead of a table variable. Other than that, it sounds like you are on...
June 8, 2012 at 9:30 am
ChrisM@Work (6/8/2012)
Nidhi G (6/8/2012)
but coming back to my...
June 8, 2012 at 9:28 am
michael vessey (6/8/2012)
June 8, 2012 at 9:24 am
dwilliscp (6/8/2012)
" and it does return the 5th of next month.
However I do not understand how it is...
June 8, 2012 at 9:19 am
Viewing 15 posts - 11,431 through 11,445 (of 26,486 total)