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

x

login about faq Site discussion (meta-askssc)

Questions in topic: t-sql

0

votes

2

answers

310

views

query cancellation

May 03 '12 at 08:46 AM ThomasRushton ♦ 29.3k

t-sql

0

votes

4

answers

1.6k

views

Pass report paramter to dynamic sql

May 01 '12 at 06:38 AM marlen 0

sql-server-2005 t-sql query

1

votes

1

answers

417

views

multiple stored procedures

Apr 25 '12 at 11:31 AM Håkan Winther 15k

sql-server-2008 t-sql stored-procedures

2

votes

2

answers

3.3k

views

How to get the getdate with time part as 00:00:00.000 ?

Apr 24 '12 at 12:18 PM Pavel Pawlowski 20.3k

t-sql

1

votes

1

answers

279

views

find maximum value

Apr 09 '12 at 09:37 PM ThomasRushton ♦ 29.3k

t-sql

0

votes

1

answers

215

views

duplicate row need to insert for the table

Mar 30 '12 at 02:11 PM Blackhawk-17 10.5k

t-sql

0

votes

2

answers

1.2k

views

Select data using join across 3 tables.

Mar 22 '12 at 02:42 PM Oleg 15.4k

t-sql

0

votes

1

answers

337

views

isnull conversion fail

Mar 20 '12 at 10:22 AM Kev Riley ♦♦ 46.1k

t-sql isnull

1

votes

1

answers

1.1k

views

Replace IN clause with JOIN to @Table variable

Mar 08 '12 at 01:30 PM Usman Butt 13.8k

t-sql

0

votes

1

answers

290

views

Conversion Problem in data

Mar 07 '12 at 05:19 PM dvroman 500

t-sql

0

votes

2

answers

1.4k

views

which one runs first in query execution WHERE CLAUSE orJOIN CLAUSE ?

Feb 29 '12 at 02:14 PM Usman Butt 13.8k

t-sql joins

1

votes

1

answers

383

views

dates issue

Feb 24 '12 at 02:17 PM Fatherjack ♦♦ 38.8k

t-sql

0

votes

2

answers

851

views

Use a pivot in a UNION

Feb 21 '12 at 10:17 PM Kev Riley ♦♦ 46.1k

sql-server-2008 t-sql pivot union-all

0

votes

3

answers

1.2k

views

how to calculate running balance like entries of bank passbook

Feb 21 '12 at 04:42 AM Amardeep 1.3k

t-sql running-total

0

votes

1

answers

522

views

Invalid Column Name error

Feb 13 '12 at 08:50 PM Pavel Pawlowski 20.3k

t-sql

0

votes

2

answers

640

views

SQL SCRIPT FORMATTER

Feb 09 '12 at 07:43 PM Grant Fritchey ♦♦ 62.1k

t-sql sql c#

1

votes

2

answers

682

views

unable to create temp table

Feb 08 '12 at 06:10 AM Usman Butt 13.8k

t-sql

1

votes

3

answers

452

views

execute SQL problem

Feb 03 '12 at 03:34 PM binodbabu 290

t-sql

9

votes

2

answers

1.9k

views

What algorithm does RAND() in SQL Server use?

Feb 02 '12 at 10:29 AM SQL Kiwi 1k

t-sql algorithm

0

votes

2

answers

424

views

Assistance in understanding Substring

Feb 01 '12 at 10:02 AM Usman Butt 13.8k

t-sql

0

votes

2

answers

600

views

How to show the % participation

Jan 23 '12 at 12:06 AM Shawn_Melton 4.7k

t-sql sql-server-2008-r2

2

votes

2

answers

662

views

Syntax error with Table Valued UDF when called from another DB

Jan 19 '12 at 07:36 AM Bill 105

sql-server-2005 t-sql user-defined-function

0

votes

1

answers

372

views

conversion issue

Jan 16 '12 at 11:34 PM Magnus Ahlkvist 13.7k

t-sql

6

votes

1

answers

373

views

Combine two queries

Jan 13 '12 at 05:58 AM sqlnewb 216

sql-server-2008 t-sql count

0

votes

1

answers

233

views

Address Concatenation

Jan 12 '12 at 07:58 AM Kev Riley ♦♦ 46.1k

t-sql

0

votes

3

answers

708

views

Extract part of a string

Jan 06 '12 at 06:30 AM Shawn_Melton 4.7k

t-sql

1

votes

2

answers

597

views

convert long integer to datetime

Jan 05 '12 at 05:40 AM Murali 896

t-sql

1

votes

3

answers

1.1k

views

Its intersting try tis Problem in bulk insert using a stored procedure need to pass sinqle quote

Jan 04 '12 at 03:27 AM ThomasRushton ♦ 29.3k

sql-server-2005 t-sql bulk-insert

0

votes

2

answers

311

views

Temp Table

Jan 02 '12 at 02:44 AM Karthik M 20

t-sql

0

votes

1

answers

454

views

what is the advantage of giving null value to unique constrain

Jan 01 '12 at 09:47 PM Usman Butt 13.8k

t-sql sql-server unique-constraint

913 questions

2187answers

Follow @Ask_SSC

Follow Ask SSC on Facebook

Find Ask SSC on Google+

Find us on LinkedIn

Tags

sql-server-2005 × 1834
sql-server-2008 × 1601
t-sql × 913
sql × 599
sql-server-2008-r2 × 394
stored-procedures × 340
query × 321
sql-server × 272
joins × 100
pivot × 65
user-defined-function × 27
bulk-insert × 25
count × 21
c# × 13
union-all × 5
algorithm × 4
unique-constraint × 4
isnull × 3
running-total × 2

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.