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

Questions in topic: sql

votes

answers

3.6k

views

Using CTE Common table expressions with SELECT CASE statement

Mar 27 at 07:00 AM cybarcom 0

votes

answers

162

views

SQLDMO not working in SQL Server 2008

Mar 26 at 03:58 PM buyme207 (suspended)

sql

votes

answers

278

views

I do not know how to write this query.

Mar 19 at 07:16 AM eghetto 1.5k

sql homework subquery

votes

answers

1.4k

views

Restore a corrupted database

Mar 14 at 11:21 AM ThomasRushton ♦ 30.2k

sql sql-server-2000

votes

answers

555

views

How to fix this SQL Query ?

Mar 12 at 08:18 PM KenJ 12.4k

sql-server-2008 sql

votes

answers

156

views

How does Count Function Works?

Mar 12 at 06:28 PM Kev Riley ♦♦ 46.1k

t-sql sql

votes

answers

views

Re-writing a Cursor into a set-based Query

Mar 12 at 09:42 AM Fatherjack ♦♦ 38.8k

sql cursor loop looping cursors

votes

answers

136

views

What skills are required for this SQL developer job

Mar 05 at 10:02 AM raadee 1.3k

sql career

votes

answers

173

views

Netapp filer was going to be replaced in clustering environment

Feb 22 at 11:34 PM KenJ 12.4k

sql-server-2005 sql cluster clustering clusters

votes

answers

259

views

find in time and out time in swipe card using query

Feb 22 at 10:06 AM ramesh 1 1.8k

sql

votes

answers

210

views

Why does this subquery need an inner join?

Feb 21 at 06:04 PM Dang 50

t-sql sql tsql sub-query aggregates

votes

answers

202

views

alternative to sql cursor

Feb 18 at 10:49 PM Grant Fritchey ♦♦ 64.9k

sql cursor

votes

answers

109

views

Separate instance installation of SQL server 2012

Feb 16 at 11:47 AM raadee 1.3k

sql

votes

answers

237

views

Find word count in the database or tables?

Feb 11 at 03:43 PM Grant Fritchey ♦♦ 64.9k

sql-server-2008 t-sql sql

votes

answers

246

views

SQL function to change the last digit of a number to a letter

Feb 07 at 07:08 PM Grant Fritchey ♦♦ 64.9k

sql

votes

answers

327

views

How to extact XML data from XML stored in NTEXT data type field in a SQL Server table?

Feb 05 at 08:48 AM Kev Riley ♦♦ 46.1k

sql xml ntext

votes

answers

173

views

Algorithm to return all combinations of k elements from n

Feb 01 at 05:36 PM ThomasRushton ♦ 30.2k

sql algorithm

votes

answers

279

views

Creating a view containing a join, I'd like to avoid naming all fieldnames

Jan 29 at 03:30 PM edmonddesavorninlohman 20

sql view

votes

answers

485

views

SSRS pass multiple valued parameter as varchar instead of nvarchar

Jan 28 at 01:34 AM clothesbiz24 (suspended)

sql ssrs

votes

answers

254

views

Calculations using information from the previous row

Jan 24 at 04:03 PM swizanson 50

sql sql-server-2008-r2 sql-server

votes

answers

183

views

Need help with a SQL query

Jan 22 at 04:03 PM ThomasRushton ♦ 30.2k

sql

votes

answers

152

views

sql query

Jan 20 at 11:12 PM ThomasRushton ♦ 30.2k

sql

votes

answers

212

views

If sql server is taken down while a backup with differentials is running, will a recovery be done on startup?

Jan 07 at 06:09 PM Grant Fritchey ♦♦ 64.9k

sql backup

votes

answers

184

views

Connection info dev vs deploy

Jan 04 at 07:33 AM Valentino Vranken 1.5k

ssis sql

votes

answers

218

views

SQL replication from DB1 to DB2->indexes process

Jan 02 at 05:12 PM Cyborg 10.2k

sql replication indexes

votes

answers

217

views

I am trying to 2. Create a query that produces a list of employee names and address in the following form

Dec 31 '12 at 01:34 PM buyme76 (suspended)

sql null

votes

answers

203

views

for loop in sp

Dec 27 '12 at 09:42 AM buyme22 (suspended)

sql

votes

answers

497

views

How to use row_number with over partition by to return a row count?

Dec 19 '12 at 11:12 PM Oleg 15.4k

sql

votes

answers

242

views

SQL, Can't figure out what formula to use.

Dec 17 '12 at 12:39 PM anthony.green 1.2k

sql-server-2008 sql

votes

answers

218

views

Trying to join three tables in sql

Dec 16 '12 at 08:56 PM GPO 1.8k

sql-server-2008 sql

608 questions

1201answers

Follow @Ask_SSC

Follow Ask SSC on Facebook

Find Ask SSC on Google+

Find us on LinkedIn

Tags