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

Questions in topic: t-sql

votes

answers

views

Updating SQL Tables with Data from a Txt FIle

1 hour ago ajallow 0

t-sql

votes

answers

981

views

how to create order with multiple order lines with xml path?

3 days ago letter1 (suspended)

votes

answers

1.4k

views

Are you adding decent comments to your views, stored procedures and scripts?

3 days ago letter1 (suspended)

t-sql best-practice comments

votes

answers

325

views

XML output for same child node

3 days ago letter1 (suspended)

t-sql xml

votes

answers

views

need to SUM from various dynamic tables

6 days ago ccmalls36 (suspended)

t-sql dynamic-sql count sum

votes

answers

views

count based on two @table variables

May 13 at 05:06 AM Mandar Alawani 346

t-sql dynamic-sql count table-variable

votes

answers

views

T-SQL And Statement

May 12 at 03:53 PM ccmalls32 (suspended)

t-sql query sql-server sql server 2008 r2

votes

answers

views

How to identify the no. of transactions

May 10 at 07:53 AM Kev Riley ♦♦ 46.1k

t-sql sql-script-file transact

votes

answers

views

Build history table based on two tables

May 09 at 11:38 AM ccmalls26 (suspended)

t-sql merge data compare

votes

answers

views

Get column names appended to results

May 07 at 01:48 AM ccmalls21 (suspended)

t-sql

votes

answers

views

Problems with Insert Statements

May 07 at 01:47 AM ccmalls21 (suspended)

t-sql

votes

answers

views

Help with unpivoting data

May 05 at 12:51 PM Dave_Green 1.7k

t-sql

votes

answers

views

logic required

May 04 at 04:16 PM ccmalls16 (suspended)

t-sql

votes

answers

views

SQL extended proeprties?

Apr 29 at 02:05 AM ccmalls11 (suspended)

sql-server-2005 t-sql query database script

votes

answers

views

sqlserver logic

Apr 15 at 04:34 PM mjharper 768

t-sql

votes

answers

views

SQL convert ddmmyyyy to dd-mm-yyyy date format help

Apr 15 at 12:04 PM Kev Riley ♦♦ 46.1k

sql-server-2008 t-sql sql-server-2008-r2

votes

answers

116

views

Join tables based on similar terms

Apr 15 at 08:08 AM GPO 1.7k

sql-server-2005 t-sql joins

votes

answers

views

Insert rows with max(value)+1

Apr 11 at 08:21 AM Cyborg 10.1k

t-sql sql-server-2008-r2 insert

votes

answers

views

please me to better up this query

Apr 09 at 12:59 PM Cyborg 10.1k

sql-server-2008 t-sql

votes

answers

2.3k

views

decrypt views & store procedure

Apr 04 at 09:26 AM walllerry (suspended)

t-sql encryption

votes

answers

213

views

T-sql restore and transactions

Apr 01 at 11:42 AM Grant Fritchey ♦♦ 62.1k

sql-server-2008 t-sql database restore transaction

votes

answers

views

how to do like this....?any one please help me....

Apr 01 at 10:24 AM Grant Fritchey ♦♦ 62.1k

t-sql

votes

answers

194

views

Common Stored proc- usage related

Apr 01 at 09:29 AM Grant Fritchey ♦♦ 62.1k

t-sql stored-procedures database-design restore

votes

answers

138

views

How do you force columns into a particular order?

Mar 21 at 04:38 PM g003p 110

t-sql columns sorting ordering

votes

answers

108

views

How to write errorlog to the SQL errorlog file from stored proc

Mar 20 at 12:06 PM Grant Fritchey ♦♦ 62.1k

sql-server-2005 t-sql stored-procedures database

votes

answers

287

views

How to create a query which kill CPU?

Mar 14 at 01:03 AM Scot Hauder 5.7k

t-sql testing cpu utilization

votes

answers

143

views

Null Value?

Mar 13 at 04:37 PM raadee 1.1k

t-sql null terminology language

votes

answers

125

views

How does Count Function Works?

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

t-sql sql

votes

answers

1.5k

views

Count(*) Vs Count(Clustered Index Key Column)

Mar 12 at 06:25 PM ThomasRushton ♦ 29.3k

t-sql performance-tuning

votes

answers

1.1k

views

Best Practices - TSQL

Mar 11 at 07:57 PM JBrian99 10

t-sql best-practice

votes

answers

1.2k

views

PDF file stored procedure

Mar 08 at 05:08 PM KenJ 12.4k

t-sql stored-procedures

votes

answers

157

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

148

views

logic needed

Feb 14 at 12:37 PM Valentino Vranken 1.4k

t-sql

votes

answers

278

views

query issue

Feb 14 at 11:10 AM Grant Fritchey ♦♦ 62.1k

t-sql

votes

answers

8.3k

views

How to get the 3 rd highest salary without using any SQL keyword?

Feb 14 at 10:50 AM askmlx121 2.4k

t-sql

votes

answers

177

views

Find word count in the database or tables?

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

sql-server-2008 t-sql sql

votes

answers

128

views

query logic required

Feb 07 at 06:58 PM Grant Fritchey ♦♦ 62.1k

t-sql

votes

answers

140

views

MATRIX TYPE QUARY

Feb 03 at 12:49 PM Grant Fritchey ♦♦ 62.1k

t-sql microsoft-access report-viewer vb2005

votes

answers

290

views

Moving multiple values from one column into multiple columns in a single row

Jan 31 at 10:42 PM sunil2711 196

sql-server-2008 t-sql

votes

answers

views

Help in replacing the deprecated SP_MAKEWEBTASK

Jan 31 at 08:59 AM Kev Riley ♦♦ 46.1k

sql-server-2005 sql-server-2008 t-sql ssis deprecated

votes

answers

13.6k

views

The 'Subscription List' SQL Problem

Jan 28 at 01:34 AM clothesbiz24 (suspended)

t-sql sql-server puzzle speed-phreak competition

votes

answers

21.4k

views

how to select Bottom( N) rows in a table through single query.

Jan 24 at 09:40 PM Kev Riley ♦♦ 46.1k

t-sql sql-server

votes

answers

10.9k

views

Entity RelationShip Diagram

Jan 22 at 11:50 AM clothesbiz15 (suspended)

sql-server-2008 t-sql database-design existing-table erd

votes

answers

125

views

Exec query which is returned by another quer?y

Jan 19 at 05:09 PM Fatherjack ♦♦ 38.8k

t-sql dynamic-sql

votes

answers

131

views

Creating a pivot table?

Jan 15 at 08:25 AM Kev Riley ♦♦ 46.1k

t-sql joins pivot

votes

answers

810

views

Error Occurred in Bulk inserting Excel to Database Table

Jan 10 at 04:05 PM rikky48 0

sql-server-2005 t-sql excel sql-server-express

votes

answers

375

views

find out which login last accessed db

Jan 07 at 10:56 AM Grant Fritchey ♦♦ 62.1k

t-sql sql-server-2008-r2 query sql-server performance

votes

answers

5.5k

views

Obtaining the Number of working days in a month

Jan 02 at 02:55 PM buyme95 (suspended)

t-sql sql-server calendar

votes

answers

278

views

Recursive Query Optimization

Jan 02 at 02:55 PM buyme95 (suspended)

t-sql cte query-optimisation

votes

answers

278

views

sqlserver dateadd function

Dec 31 '12 at 02:51 PM ecomma 420

t-sql

913 questions

2185answers

Follow @Ask_SSC

Follow Ask SSC on Facebook

Find Ask SSC on Google+

Find us on LinkedIn

Tags