Viewing 15 posts - 271 through 285 (of 500 total)
Your stuff may have posted incorrectly because the message board does stuff with html tags (I always leave a space like that to get it to show). So I'm...
June 25, 2009 at 5:37 am
😀
and another old one, just to illustrate how helpful people in our industry can be.
How many hardware engineers does it take to change a light bulb?
None - they can fix...
June 25, 2009 at 3:30 am
If you look in Machine.config you will find its roleManager provider is most probably pointing to SQLExpress - which means it will look for an ASBNET.mdf in the App_Data directory.
Override...
June 25, 2009 at 3:23 am
It can be a complicated are of asp.net
Yes you will need a different connection string to your app db and aspnetdb.
Do you have SQL Express, or an SQL Server edition...
June 25, 2009 at 2:27 am
Use string manipulation and the built-in date functions
e.g.
SELECT DATENAME(weekday,(GetDate())) + ', ' +
CONVERT(varchar, GETDATE(), 109)
SEE CONVERT in BOL for a full list of date conversion options.
June 24, 2009 at 7:47 am
In Report Designer, can you set a default value in the report parameters box (default values tab) of '=Nothing' (the VB way of specifying null), then omit the parameter on...
June 24, 2009 at 7:37 am
OK That makes it a little easier than I first thought. I prefer the temp table solution.
I've run this test example, and it seems to work, you should be...
June 24, 2009 at 1:28 am
Adam Bean (6/23/2009)
Response after mine was better 🙂
And mine was really lazy - just a hint at what might get the OPs problem solved.
But I'll leave it there. ...
June 23, 2009 at 8:12 am
I think you need to clarify this a little.
Post the existing table def, and what you want the table def to be after the alteration.
If lots of foreign keys link...
June 23, 2009 at 8:02 am
You could use something like
SELECT
COUNT(ITEM) OVER (PARTITION by Date) AS Count, Date
FROM Table
See the OVER() clause in BOL
you can probably use an expression like DATEPART(YEAR,Date) in the PARTITION...
June 23, 2009 at 7:52 am
What I was trying to find out is how Jeff does it
e.g. this from another thread (which pastes into SSMS well, preserving line breaks and blank lines)
Jeff Moden (6/20/2009)
June 23, 2009 at 7:04 am
Gail: Done - it was annoying I agree.
June 23, 2009 at 6:33 am
I don;t know of any in SQL 2005. - did you try Googling? Otherwise I think you can download a trial version of visual studio 2005 and get 90...
June 23, 2009 at 5:15 am
Its certainly not as easy as it was in SQL2000
In theory, Open SQL Server Business Intelligence Studio (aka Visual Studio .NET 2005) Create a database connection, right-click on the stored...
June 23, 2009 at 3:15 am
Viewing 15 posts - 271 through 285 (of 500 total)