Questions tagged [t-sql]

21

votes

4

answers

How to select item matching Only IN List in sql server

sql-server t-sql

asked 2012-09-24T11:18:14.203

53

votes

2

answers

row_number() Group by?

sql-server t-sql unique row-number

asked 2012-09-20T18:27:07.087

9

votes

2

answers

How to weekly group if you have daily data

sql sql-server t-sql

asked 2012-09-18T06:17:17.173

26

votes

6

answers

Executing SQL Server Agent Job from a stored procedure and returning job result

sql sql-server sql-server-2008 t-sql jobs

asked 2012-09-03T13:42:10.173

9

votes

2

answers

Exporting binary file data (images) from SQL via a stored procedure

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

asked 2012-08-30T20:00:59.240

16

votes

5

answers

Cannot connect to SQL Server - login failed

sql sql-server t-sql

asked 2012-08-30T06:31:27.300

30

votes

4

answers

IIF(...) not a recognized built-in function

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

asked 2012-08-20T09:18:51.327

98

votes

8

answers

Select a Column in SQL not in Group By

sql sql-server-2008 t-sql greatest-n-per-group

asked 2012-08-16T15:54:38.413

13

votes

4

answers

How to control nullability in SELECT INTO for literal-based columns

sql sql-server-2008 t-sql

asked 2012-08-08T19:50:37.473

22

votes

1

answers

What can I use instead of #Temp table in sql function

sql-server-2008 t-sql temp

asked 2012-08-08T06:04:12.407

28

votes

9

answers

Find Column dependency

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

asked 2012-08-01T23:49:16.517

21

votes

4

answers

T-SQL "Where not in" using two columns

sql t-sql

asked 2012-07-30T07:06:10.257

100

votes

4

answers

Update records in table from CTE

sql sql-server t-sql common-table-expression

asked 2012-07-19T14:01:07.997

11

votes

15

answers

Self Join to get employee manager name

sql sql-server database t-sql

asked 2012-07-11T07:05:30.143

9

votes

2

answers

Stored procedure vs embedded SQL in SSIS performance

sql-server t-sql stored-procedures ssis

asked 2012-07-06T09:10:18.747

14

votes

1

answers

Can I apply a WHERE clause on the target in a MERGE statement?

sql-server t-sql merge

asked 2012-06-27T01:41:27.930

331

votes

4

answers

Is there a performance difference between CTE , Sub-Query, Temporary Table or Table Variable?

sql sql-server t-sql subquery common-table-expression

asked 2012-06-23T12:36:14.007

29

votes

3

answers

Select rows where column value has changed

sql sql-server-2008 t-sql select

asked 2012-06-20T20:14:37.053

9

votes

4

answers

What is scope of temp table when called by nested stored procedure?

sql-server t-sql stored-procedures

asked 2012-06-20T04:28:20.827

39

votes

4

answers

Splitting delimited values in a SQL column into multiple rows

sql sql-server sql-server-2008 t-sql sql-server-2005

asked 2012-06-13T15:17:15.903

78

votes

3

answers

T-SQL How to grant role to user

sql-server sql-server-2008 t-sql

asked 2012-06-13T04:55:05.870

19

votes

1

answers

Full Text Search on SQL Azure

.net t-sql azure full-text-search azure-sql-database

asked 2012-06-11T18:31:18.017

10

votes

4

answers

Linestring to Points

sql-server t-sql geospatial sql-server-2012

asked 2012-05-26T17:33:57.123

11

votes

1

answers

MERGE Violation of PRIMARY KEY constraint

sql sql-server sql-server-2008 t-sql upsert

asked 2012-05-23T16:44:37.530

21

votes

2

answers

When the performance of Distinct and Group By are different?

sql-server t-sql group-by distinct

asked 2012-05-18T10:13:54.827

10

votes

5

answers

Need to start agent job and wait until completes and get success or failure

t-sql sql-server-2005 sql-agent-job

asked 2012-05-18T07:29:55.697

9

votes

1

answers

Casting String to Money Value in SQL Server

sql sql-server t-sql casting ssis

asked 2012-05-14T20:05:06.087

117

votes

8

answers

How do I use the CONCAT function in SQL Server 2008 R2?

sql-server sql-server-2008 t-sql

asked 2012-05-11T11:17:11.787

33

votes

2

answers

How to determine if anything changed in update trigger in t-sql

sql-server t-sql triggers

asked 2012-05-11T11:15:14.020

12

votes

2

answers

Interesting behavior in "NOEXEC ON"

sql-server t-sql

asked 2012-05-10T14:58:25.373

47

votes

2

answers

select count(*) from select

sql sql-server t-sql subquery

asked 2012-05-03T20:50:09.920

8

votes

5

answers

How to list fields from dynamic SQL query in SSRS dataset

sql-server t-sql reporting-services ssrs-2008

asked 2012-05-02T21:20:04.547

86

votes

1

answers

SQL Server Invalid Column name after adding new column

sql sql-server sql-server-2008 t-sql sql-server-2005

asked 2012-04-26T17:43:51.227

8

votes

2

answers

how to use openrowset to execute a stored procedure with parameters

sql-server-2008 t-sql stored-procedures openrowset

asked 2012-04-24T06:25:37.573

8

votes

4

answers

How to find the join path from one table to another in a large database

sql database sql-server-2008 t-sql

asked 2012-04-18T13:00:22.680

39

votes

3

answers

Why are CLR Types derived from generics not supported in SQL Server 2008 and later?

c# sql-server-2008 t-sql generics sql-server-2012

asked 2012-04-13T13:41:04.800

11

votes

2

answers

Query to Select Between Two Times of Day

sql t-sql sql-server-2005

asked 2012-04-05T20:47:04.020

20

votes

2

answers

ALTER TABLE [dbo].[MyTable] CHECK CONSTRAINT [FK_MyTable_SomeCol]

t-sql

asked 2012-04-02T10:11:36.703

10

votes

2

answers

SQL Management Studio 'View Dependencies' Not Listing All Dependencies

sql t-sql ssms

asked 2012-04-02T00:43:17.560

48

votes

4

answers

Counting no of rows returned by a select query

sql-server sql-server-2008 t-sql

asked 2012-03-30T15:15:10.970

22

votes

3

answers

Does INSERT INTO ... SELECT ... always match fields by ordinal position?

sql sql-server t-sql insert-into

asked 2012-03-21T15:30:30.490

19

votes

7

answers

Is there a quick way to check if ANY column is NULL?

sql sql-server sql-server-2005 t-sql

asked 2012-03-14T15:54:06.667

9

votes

4

answers

Paging, sorting and filtering in a stored procedure (SQL Server)

sql-server t-sql stored-procedures

asked 2012-03-13T21:38:45.010

49

votes

4

answers

Multiple Select against one CTE

sql-server t-sql

asked 2012-03-13T10:42:25.783

8

votes

4

answers

SQL Server returns unexpected week number

sql-server-2008 t-sql

asked 2012-03-08T16:16:56.990

42

votes

7

answers

Selecting most recent and specific version in each group of records, for multiple groups

sql sql-server t-sql greatest-n-per-group

asked 2012-02-24T12:25:31.980

83

votes

10

answers

SQL query with NOT LIKE IN

sql sql-server-2008 t-sql

asked 2012-02-22T10:55:33.823

18

votes

7

answers

How to restore a SQL Server database backup without knowing the destination path or filenames?

sql-server sql-server-2008 t-sql database-restore

asked 2012-02-22T02:57:47.310

8

votes

1

answers

Eager loading in EntityFramework with DbContext.Database.SqlQuery

t-sql entity-framework-4.1 eager-loading

asked 2012-02-03T23:35:48.733

47

votes

9

answers

Truncate Datetime to Second (Remove Milliseconds) in T-SQL

t-sql datetime

asked 2012-01-26T13:44:10.493

Questions tagged t-sql