Home
Get Started
Learn
Downloads
AJAX
MVC
Community
Wiki
Forums
Sign in
|
Join
Home
›
ASP.NET Forums
›
Search
Search
You searched for the word(s): userid:628661
More Search Options
RSS Available
Matching Posts
Re: complex joining of tables
It is a poor design. Using cata, catb, catc in the item table is wasting space because only one of them is necessary. I would recommend removing them in favor of a more generic catid field. Secondly, using the value of a table to determine which other table contains a value isn't a good idea. There are multiple ways around this like using a compound key (category, catid) or uniquifying the catid's. Those design decisions aside, here is the original query you asked for done multiple ways:
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
Motley
on 3/26/2009
Re: programatically change sqldatasource select statement
Yes, that is exactly what you should do.
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
Motley
on 8/15/2008
Re: Boolean Format String - Yes/No instead of True/False
Sorry, I should have said: <%# CDbl(Eval("field")).ToString("Yes;Yes;No") %> Much simplier I think. You can also eliminate one of the Yes's, if you want to make the assumption on whether field is coming back as a true boolean (True/False) that will get converted to (-1/0) or if it is actually a bit field, which will get converted to (1/0). Putting yes in both parts forces it to work in either case.
Posted to
Feature Requests
(Forum)
by
Motley
on 6/2/2008
Re: Display ROW as a COLUMN
First you will want to rank the rows (row_number OVER (Partition by packageid ORDER BY userid)). Now wrap that into a pivot to convert the rows into columns. A less clean way would be like: SELECT t2.pkgid, (SELECT GrpName FROM t1 WHERE TheRank=1 AND t1.pkgid=t2.pkgid) AS [APPR GRP NAME 1], (SELECT UserID FROM t1 WHERE TheRank=1 AND t1.pkgid=pkgid) AS [USRID OF APPR 1], (SELECT GrpName FROM t1 WHERE TheRank=2 AND t1.pkgid=t2.pkgid) AS [APPR GRP NAME 2], (SELECT UserID FROM t1 WHERE TheRank=2 AND
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
Motley
on 5/3/2008
Re: Need to cache or store these SqlDataSource objects
Yes, this would be a perfect example of what the cascading dropdown was designed for. If that is too much work, as the above poster suggests, you could use an update panel (or two), which would help as well.
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
Motley
on 5/3/2008
Re: Which is better PHP or ASP.NET ??
Using personal attacks really doesn't help "prove" your point. It just shows your evidence is so weak (or wrong) you have to use personal attacks to try and drive your point across. The question was which is better, PHP or ASP.NET. The question wasn't... "Is there a way expand PHP into a full fledged framework capable of handing large projects?" Cosmicgirl if you wish to continue that line of thought on another thread please feel free. But you've proven exactly what
Posted to
Migrating from PHP to ASP.NET
(Forum)
by
Motley
on 5/2/2008
Re: How to use a backslash "\" in a sql statement
First, parameterize your query. Second you'd need to post your code because often the problems involving backslashes are string related, not sql related. EX: Dim conn and new sqlconnection(...) dim cmd as new sqlcommand("SELECT * FROM table1 WHERE id=@id",conn ) cmd.parameters.add("id",sqldbtype.nvarchar).value="DOMAIN\user" conn.open ... conn.close
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
Motley
on 4/14/2008
Re: import\export an SQL db between remote and local machines
At the very top of this forum, there is a sticky that should help you. Aside from that, Visual Studio's Team Suite or Visual Studio for DBAs should be able to generate the script you need to execute on the remote database. There are a lot of other tools as well, like CompareSQL, AdpetSQL, that can do this for you. If you don't mind manually doing it, SQL Server Management Studio can create scripts to recreate most tables, views, indexes, etc, but you'll need to do them one by one, and
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
Motley
on 3/11/2008
Re: Database query won't use current date
That query looks ok to me. I normally try to avoid using reserved words like date, etc for column names though.
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
Motley
on 3/11/2008
Re: Query string field based on text format
WHERE LEN(Field)=15 should get you there quickly. You can add additional constraints if you really need it in only 000 000 000 000 format. Like: WHERE LEN(FIELD)=15 AND SUBSTRING(Field,1,1)>='0' AND SUBSTRING(Field,1,1)<='9' -- Check first char AND .... -- check 2nd AND ... -- check 3rd AND SUBSTRING(Field,4,1)=' ' -- check 4th ...
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
Motley
on 3/7/2008
Page 1 of 230 (2297 items) 1
2
3
4
5
Next >
...
Last »
Channel 9:
C9 Conversations: Brian Beckman on Complexity [C9 Conversations: Brian Beckman on Complexity]
Channel 10:
Black Friday Deals on Windows 7 Machines
Channel 10:
Holiday Shopping on Bing Cashback = Big Online Savings
Channel 10:
Black Friday Deals at the Microsoft Store
Channel 10:
Incredible Black Friday Deal: Windows 7 Notebook for $197
ASP.NET:
Presenting in Europe Next Week
TechNet Edge:
AlignIT IT Manager Podcast #30 - Straight Talk about Windows 7
WindowsClient:
You know your post rate has gone down...
Silverlight:
Geek Profiles – Scott Guthrie
Channel 9:
C9 Lectures: Dr. Erik Meijer - Functional Programming Fundamentals Chapter 9 of 13
TechNet Edge:
Managing Your Virtual World - Tech Focus November 2009 Part 2
ASP.NET:
Silverlight and RIA Services: Implementing Search
Channel 9:
C9 Lectures: Brian Beckman - Covariance and Contravariance in Physics 1 of 1
Channel 9:
Set Your Data Free
Channel 9:
Implementing a Silverlight SharePoint WebPart with Visual Studio 2010
WindowsClient:
New WPF Showcase Addition: Enterprise
Channel 9:
Reactive Extensions API in depth: Contract
WindowsClient:
Concluding "New WPF Features" Series
WindowsClient:
Introduction to TestApi – Part 5: Managed Code Fault Injection APIs
ASP.NET:
T4MVC now has a real home and a dedicated forum!
Microsoft Communities
ASP.NET
Channel 8
Channel 9
Channel 10
IIS.NET
Silverlight
TechNet Edge
WindowsClient
Mix Online