Questions in topic: select - SQL Server Q&A from the SQL Server Central community

x

login about faq Site discussion (meta-askssc)

Questions in topic: select

1

votes

1

answers

54

views

How to retrieve data value from a previous row with select statement

May 12 at 03:54 PM ccmalls32 (suspended)

sql-server-2000 tsql select

1

votes

1

answers

78

views

Problem using joins when use multiple tables

Apr 25 at 10:52 AM Grant Fritchey ♦♦ 62.1k

sql-server-2008 joins select

2

votes

1

answers

111

views

Convert Password nvarchar() to binary datatype in sql

Apr 24 at 11:57 AM buyme154 (suspended)

sql-server-2008 sql-server select hash

1

votes

3

answers

144

views

Create select query how to convert varchar to int by using cast

Apr 16 at 10:20 AM udhaya 80

sql-server-2008 select substring cast

2

votes

1

answers

131

views

dynamic sql to retrieve tablenames

Mar 04 at 01:36 AM Mandar Alawani 346

insert select meta-data tablenames dynamic sql

1

votes

4

answers

290

views

Help - Need a better way to create Query. Select within a Select

Feb 24 at 07:23 PM whitter 40

select

2

votes

3

answers

190

views

How to select decimal record in a table

Feb 19 at 08:16 PM ThomasRushton ♦ 29.2k

sql-server-2008 query select

1

votes

1

answers

179

views

Top 10 records in one row

Jan 30 at 03:25 PM liton 570

select top

1

votes

1

answers

111

views

CASE WHEN FIELD IN(..) SELECT Statement

Jan 23 at 07:41 AM ThomasRushton ♦ 29.2k

select case in

4

votes

2

answers

195

views

Select * and column in different tables.

Jan 21 at 01:11 PM Fatherjack ♦♦ 38.8k

joins select columns

1

votes

1

answers

111

views

I am getting this error " 10:30:26 [SELECT - 0 row(s), 0.000 secs] [Error Code: 156, SQL State: S1000] Incorrect syntax near the keyword 'FROM"

Jan 17 at 10:36 AM clothesbiz11 (suspended)

select

1

votes

1

answers

269

views

Difference between SELECT Alias = ColumnName and SELECT ColumnName AS

Jan 10 at 11:51 AM Grant Fritchey ♦♦ 62.1k

sql-server-2008 select

1

votes

9

answers

4k

views

Departmentwise 2nd highest salary

Dec 08 '12 at 12:45 PM gloing59 (suspended)

t-sql select

0

votes

1

answers

153

views

How to select in a n-n ids structure with multiple AND?

Nov 13 '12 at 11:37 AM Kev Riley ♦♦ 46k

select mysql

2

votes

3

answers

1k

views

How to Select unmatched data from two column in two table

Oct 17 '12 at 03:50 PM Fatherjack ♦♦ 38.8k

select

87 questions

176answers

Follow @Ask_SSC

Follow Ask SSC on Facebook

Find Ask SSC on Google+

Find us on LinkedIn

Tags

sql-server-2008 × 1601
t-sql × 912
sql-server-2000 × 454
query × 321
sql-server × 272
tsql × 224
joins × 100
insert × 91
select × 87
mysql × 52
columns × 13
meta-data × 12
case × 11
substring × 10
top × 9
cast × 6
tablenames × 6
hash × 5
dynamic sql × 3
in × 3

posts per page 15 30 50

Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.
Ask SQL Server Central is a community service provided by Red Gate.