Viewing 15 posts - 7,111 through 7,125 (of 15,381 total)
stevenplee (8/16/2013)
I have a query as SELECT DISTINCT Field FROM Table...
August 16, 2013 at 10:41 am
Oh good grief. I misread that query. I thought the second query was a cross join. I read it as this:
select a.col1,a.col2
from Table1 A, Table2 B
August 16, 2013 at 10:20 am
scott.kitson (8/16/2013)
the customer wants to see the values of "lookup tables" (values in drop-down select boxes) in the application in one ...
August 16, 2013 at 10:17 am
stevenplee (8/16/2013)
I have a query that will return only one...
August 16, 2013 at 10:15 am
What a completely bizarre requirement. You are literally mixing values between rows. This will work for the sample data.
select program, market_segment, Approval
from
(
select program, ROW_NUMBER() over(order by PROGRAM) as RowNum
from...
August 16, 2013 at 10:10 am
curious_sqldba (8/16/2013)
select a.col1,a.col2
from Table1 A
left join Table2 B
select a.col1,a.col2
from Table1 A
Would these two queries return same result set?
They would if either of the tables has only 1 row. The reality...
August 16, 2013 at 9:44 am
scott.kitson (8/16/2013)
August 16, 2013 at 9:37 am
yi.wang 12733 (8/16/2013)
For example, I have a comment like 'Work (210) 401-6838 for debtor(1) 'Guzman,...
August 16, 2013 at 8:02 am
As a follow up to Jason's excellent advice, when you chat with those developers you need to slap them around if they are using queries like that in production. What...
August 16, 2013 at 7:25 am
adonetok (8/16/2013)
This will delete entire row.What I need is to delete data in [ORDERDATE] cell and keep bbb in [NAME] field.
That isn't a delete. It is an update.
Update table set...
August 16, 2013 at 7:15 am
pwalter83 (8/16/2013)
I wish to track the changes in table1 if the row is updated on table2 based on the condition that both tables are linked through primary-foreign key (VENDOR_ID). In...
August 16, 2013 at 6:52 am
raghavender.2369 (8/15/2013)
10
20
30
40
50
table has a...
August 15, 2013 at 12:03 pm
MSSQL_NOOB (8/15/2013)
Is there a cause for concern if one of the tables in SQL2008 has a VARCHAR field. And in that field, the "data" stored is HTML tags?
I guess that...
August 15, 2013 at 12:02 pm
Jeff Moden (8/14/2013)
Sean Lange (8/14/2013)
August 15, 2013 at 7:20 am
Sean Lange (8/14/2013)
Mark Gorelik (8/14/2013)
I tested your solution on real data and for some reason it does not work . ID incremented for field1 value='H' .The rest...
August 14, 2013 at 3:43 pm
Viewing 15 posts - 7,111 through 7,125 (of 15,381 total)