You searched for the word(s): userid:628661

More Search Options

RSS Available

• 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