SQL Server Forums - Active Topics

Home | Weblogs | Forums | SQL Server Links

Active Forum Topics | Popular Articles | All Articles by Tag | SQL Server Books | About

SQL Server Forums

Profile | Register | Active Topics | Members | Search | Forum FAQ

Register Now and get your question answered!

Username:	Password:
Save Password
Forgot your Password?

All Forums

Active Topics Since

Topic

Author

Replies

Read

Last Post

General SQL Server Forums / New to SQL Server Programming

Hiding Query after building

4

32

02/11/2012 08:00:23
by: visakh16

Sql server 2005 certification

2

14

02/11/2012 07:49:27
by: robvolk

diagramming a db

9

41

02/11/2012 03:04:59
by: Transact Charlie

How to learn running stored pocedure

4

66

02/11/2012 02:08:50
by: kcanakli

NEW TO SQL

H

15

133

02/10/2012 18:32:23
by: visakh16

Query to pull certain row

13

89

02/10/2012 18:31:49
by: visakh16

sql server date info help

2

13

02/10/2012 18:00:37
by: tinamiller1

Where In statement in SQL Server

6

61

02/10/2012 17:55:47
by: tinamiller1

Variables and nested query returning 0

1

14

02/10/2012 17:45:55
by: sunitabeck

LEFT JOIN Multiple Tables Bad Data

6

56

02/10/2012 16:44:32
by: visakh16

Merging non Null values

3

23

02/10/2012 16:03:41
by: visakh16

top (100) percent

1

16

02/10/2012 16:03:29
by: visakh16

sql server agent jobs

1

23

02/10/2012 15:59:25
by: russell

Pivot

5

55

02/10/2012 15:46:35
by: visakh16

Multiple SQL Left Joins COUNT

2

26

02/10/2012 15:46:00
by: visakh16

Converting varchar to money

5

47

02/10/2012 15:34:12
by: russell

update with case and some nulls

3

15

02/10/2012 15:24:34
by: webfred

Need Datetime Format

2

23

02/10/2012 13:41:59
by: Lamprey

Need help with statement

8

45

02/10/2012 11:54:42
by: visakh16

Query Statement..

9

72

02/10/2012 11:18:59
by: visakh16

Table Search Slow

4

47

02/10/2012 11:17:21
by: yaman

pull numbers from column

3

24

02/10/2012 11:09:44
by: visakh16

How to limit data when grouping

2

20

02/10/2012 10:54:55
by: LOLCatLady

Three Table Join

1

18

02/10/2012 10:07:42
by: visakh16

UPDATE IF NOT NULL

7

67

02/10/2012 09:59:22
by: hutty

Looking for help

Jason Carlton Aguilar

3

35

02/10/2012 09:23:21
by: visakh16

SQL Query Issue

Sushil.SHARMA75

4

48

02/10/2012 09:21:42
by: visakh16

SELECT Statement - duplicates

1

2

27

300

02/10/2012 09:15:15
by: visakh16

query

16

120

02/10/2012 07:38:55
by: csteve274

Export Data from SQL to .PDF format

10

626

02/10/2012 07:37:28
by: csteve274

convert crystal report to pdf

3

591

02/10/2012 07:35:41
by: csteve274

is there way to return data type of a column.

NagaVardhanReddy

1

26

02/10/2012 07:01:03
by: DonAtWork

Join 3 tables and get the data base on recent date

2

43

02/10/2012 04:58:06
by: webfred

Add column

8

70

02/10/2012 02:38:02
by: vyvanand

Simple Select not returning any results

18

129

02/09/2012 19:23:19
by: soulchyld21

doubled data

1

31

02/09/2012 18:06:38
by: visakh16

Extracting data from tables

5

51

02/09/2012 17:49:07
by: visakh16

SQL LDAP querry

1

20

02/09/2012 17:47:15
by: visakh16

Record duplication

3

25

02/09/2012 17:44:54
by: visakh16

Average of an average

7

44

02/09/2012 14:17:52
by: visakh16

Problems with Iterating through Data

2

27

02/09/2012 14:10:19
by: visakh16

select multiple entries based on same value?

3

38

02/09/2012 14:02:00
by: visakh16

Saving a result set as a table

2

34

02/09/2012 13:06:29
by: pwebley

Parameters not working....

8

45

02/09/2012 13:03:09
by: werhardt

How to increment Row value(Running Number) in sql

2

49

02/09/2012 12:49:09
by: visakh16

Special Select Statement with comparison

6

78

02/09/2012 12:43:27
by: visakh16

Query Troubles

towardabettercountry

1

29

02/09/2012 12:42:23
by: visakh16

after update , insert

6

44

02/09/2012 12:39:47
by: Kristen

UPDATE Trigger is updating all the table!

5

72

02/09/2012 11:55:47
by: amarundo

Charindex

4

43

02/09/2012 10:40:37
by: Petronas

Which is fastest?

1

2

3

48

823

02/09/2012 09:20:22
by: rmg1

Using SQLCMD to export data from the past x days

8

45

02/09/2012 06:30:24
by: webfred

Final Count on query

9

75

02/09/2012 05:57:36
by: rcp

Finding records that don't match

2

41

02/08/2012 19:28:54
by: pwebley

how to change log file's settings

14

77

02/08/2012 15:59:01
by: tkizer

Compare cells in a row in two tables

2

43

02/08/2012 14:13:49
by: visakh16

Finding Stored Procedures

2

32

02/08/2012 14:07:23
by: visakh16

Sql tricky query

8

126

02/08/2012 13:57:59
by: visakh16

My database is being used by another process.

5

61

02/08/2012 13:44:18
by: vodkasoda

Getting create index statement from execution plan

3

33

02/08/2012 13:13:32
by: b11091019

Keybinding reference poster

0

17

02/08/2012 12:42:22
by: b11091019

Update a column if the case has a parent_id

2

45

02/08/2012 11:06:00
by: carau2007

Collect data from database

0

37

02/08/2012 09:50:10
by: siner82

How to find a row id of selected column fields.

NagaVardhanReddy

5

46

02/08/2012 08:49:40
by: webfred

Select statement with TOP 1.

3

50

02/08/2012 05:32:55
by: hspatil31

option to not split stored procedure

2

40

02/08/2012 03:33:24
by: Kristen

count

5

43

02/08/2012 02:08:52
by: khtan

454 calendar script

3

36

02/08/2012 02:06:35
by: khtan

not null query failing when include other clauses

2

36

02/07/2012 20:35:03
by: pavlos

SQL In and Not In

2

44

02/07/2012 17:21:36
by: Kristen

Help Writing query

1

39

02/07/2012 17:19:46
by: X002548

UNION ALL FOR 2 CTEs

1

33

02/07/2012 16:54:40
by: X002548

Error Handling

9

77

02/07/2012 16:45:39
by: X002548

Count() Help.

12

71

02/07/2012 16:21:15
by: visakh16

Hospital Ward Occupancy - Grouped DateDiff?

12

125

02/07/2012 15:44:10
by: sqlnovice1

Syntax error?

15

67

02/07/2012 15:16:05
by: visakh16

sting parse

10

92

02/07/2012 14:06:38
by: GilaMonster

Management System

4

38

02/07/2012 14:04:01
by: visakh16

Parameter not being seen in my query. Please help

6

86

02/07/2012 13:54:49
by: Kristen

Stuck on basic queries

4

47

02/07/2012 13:40:02
by: visakh16

Splitting a string function?

8

73

02/07/2012 13:00:34
by: X002548

Select Statement

2

36

02/07/2012 12:32:57
by: X002548

Multiple rows in one field

12

141

02/07/2012 12:25:24
by: visakh16

Query - Change

3

42

02/07/2012 12:18:18
by: X002548

tracing disease infections

1

47

02/07/2012 11:28:29
by: dr223

Hierarchy Question

2

33

02/07/2012 10:56:19
by: chill_uk

UPDATE statement not functioning

2

41

02/07/2012 08:11:39
by: tariq2

year date cast

2

54

02/07/2012 07:19:52
by: sunitabeck

Output in Decimal.

1

41

02/07/2012 07:13:01
by: sunitabeck

Eliminate warning due to aggregate functions

2

54

02/07/2012 04:58:55
by: webfred

Double values id

4

60

02/07/2012 02:38:43
by: Myclos81

use parameter to sum column

2

50

02/07/2012 01:10:51
by: pamyral_279

help on substring (getting last 4 digits)

15

151

02/06/2012 22:04:45
by: nasman

Formula to compare data in view between 2 tables

5

61

02/06/2012 20:14:14
by: visakh16

Temp table SUM invalid column error

10

73

02/06/2012 16:01:04
by: visakh16

Need help with Week # of #

1

50

02/06/2012 14:50:49
by: sunitabeck

Delete all versions except Max 2 versions

1

37

02/06/2012 14:47:18
by: sunitabeck

JS to SQL Function

6

52

02/06/2012 14:02:52
by: visakh16

Select from my results

2

46

02/06/2012 12:50:40
by: rcp

watch variable value at debugging

1

42

02/06/2012 11:55:01
by: visakh16

i need help with sql exercise.. pls help!

3

52

02/06/2012 11:38:04
by: visakh16

Compound Conditions

Jason Carlton Aguilar

1

51

02/06/2012 11:35:27
by: visakh16

Date wise transaction

1

53

02/06/2012 09:28:31
by: visakh16

Empty date values

4

111

02/06/2012 09:28:00
by: visakh16

select data from 4 tables not linked to each other

4

51

02/06/2012 09:21:45
by: visakh16

Existing data missing in result set

1

43

02/06/2012 08:09:48
by: sunitabeck

How to processing 1000000 records

1

58

02/06/2012 08:06:57
by: sunitabeck

Please help with Query

3

79

02/06/2012 06:59:42
by: barnabeck

Simple encryption problem re-password

15

111

02/06/2012 03:10:12
by: Kristen

Conversion from PL/SQL to T-SQL

0

42

02/06/2012 02:08:28
by: sachinj

Copy tables from one db to another

9

117

02/05/2012 19:25:47
by: visakh16

15 minute count query

4

80

02/05/2012 19:24:19
by: visakh16

Copy tables from one db to another

1

44

02/05/2012 19:18:13
by: robvolk

How to get aggregate data on a join

4

148

02/05/2012 12:51:22
by: visakh16

Filter by top 2 values AND one other

2

46

02/05/2012 10:39:37
by: visakh16

Text mining

2

66

02/05/2012 10:37:36
by: visakh16

Create 5000 unique alphanumeric character

3

92

02/05/2012 07:26:44
by: sunitabeck

The name "''" is not permitted in this context

4

66

02/05/2012 03:22:26
by: Kristen

SQL aggregate query

3

76

02/04/2012 15:13:13
by: visakh16

SSMS question

5

62

02/04/2012 14:32:42
by: GilaMonster

Can this be improved ?

4

66

02/04/2012 05:04:22
by: Kristen

Query Help

6

76

02/03/2012 18:46:30
by: caravanpunk

Insert data into the entire table

1

57

02/03/2012 17:10:37
by: Lamprey

sql count function

4

76

02/03/2012 16:55:27
by: tkizer

How can I reference a value I calculated?

1

54

02/03/2012 15:56:40
by: visakh16

update data by condition

17

98

02/03/2012 15:55:35
by: visakh16

query help

2

58

02/03/2012 15:53:59
by: visakh16

dynamic SQL

2

105

02/03/2012 14:32:25
by: bluemagic74

SET IMPLICIT_TRANSACTIONS

9

120

02/03/2012 13:33:18
by: visakh16

Using CASE - WHEN to create new column

4

69

02/03/2012 12:51:20
by: Tomb

Stuff a char(10) into a text string

4

34

02/03/2012 12:31:51
by: visakh16

cast date as DD in my sp

8

53

02/03/2012 12:24:03
by: kshitizgp

Difficult rolling average

15

129

02/03/2012 12:05:56
by: visakh16

sql server trigger to save all user's actions

2

59

02/03/2012 11:42:01
by: Kristen

Where clause and singularing out the Word N

10

67

02/03/2012 11:06:05
by: visakh16

i need help with sql exercise.. pls help!

1

40

02/03/2012 10:54:45
by: visakh16

Composite Index vs Non Clustered Index

7

80

02/03/2012 09:46:25
by: sixsigma1978

Case expression

4

68

02/03/2012 09:17:25
by: visakh16

Future in SQL Development

2

70

02/03/2012 07:49:21
by: Transact Charlie

How to get the occurence (Count)

3

62

02/03/2012 04:15:19
by: Villanuev

SQL table sync

0

34

02/03/2012 00:35:54
by: ranjithedl

Eliminating Single Entries

3

57

02/02/2012 21:25:44
by: khtan

Divide 2 column in SQL

1

66

02/02/2012 19:39:44
by: visakh16

Making a Cell uneditable

3

46

02/02/2012 18:21:00
by: visakh16

Pull in data from other tables

13

85

02/02/2012 18:18:03
by: visakh16

Getting Percentage

1

51

02/02/2012 16:21:37
by: Petronas

SA login

1

174

02/02/2012 15:17:20
by: russell

Any value query

11

159

02/02/2012 14:54:15
by: visakh16

Need help transferring and modifying database

5

58

02/02/2012 14:25:53
by: Lamprey

Linked Server to Oracle

3

39

02/02/2012 13:50:29
by: visakh16

encryption

4

79

02/02/2012 13:22:03
by: tkizer

Importing Data

4

54

02/02/2012 12:19:56
by: ccdavies

Key Lookup(Clustered)

5

74

02/02/2012 12:15:29
by: visakh16

simple query err for out parameter

3

48

02/02/2012 12:09:39
by: visakh16

Aggregate SQL

4

58

02/02/2012 12:09:15
by: visakh16

Alias in SELECT statement

1

65

02/02/2012 11:32:00
by: Transact Charlie

Max or Top or Something else?

7

121

02/02/2012 10:22:33
by: visakh16

* in where clause.

4

85

02/02/2012 10:10:15
by: visakh16

Challenge with a 3 three table view

2

56

02/02/2012 10:09:11
by: visakh16

total

1

60

02/02/2012 10:05:47
by: visakh16

Querying Wildcards from a File

3

146

02/02/2012 09:16:01
by: cgrego

Databse is showing in Suspect.

2

54

02/02/2012 08:21:28
by: GilaMonster

Current Date - 30

8

114

02/02/2012 04:31:53
by: GilaMonster

SQL Server Unable to Open Table or Rename

5

272

02/02/2012 02:47:32
by: mr_abuzer

sum multi column

4

96

02/01/2012 21:38:59
by: pamyral_279

creating new column based on where statement

3

66

02/01/2012 15:13:30
by: visakh16

Subtract 30 Days

2

80

02/01/2012 15:05:46
by: visakh16

Formatting this crazy SQL with Group By?

4

86

02/01/2012 14:22:10
by: monaya

Expressions Anyone?

12

96

02/01/2012 12:57:38
by: visakh16

Inner Join

2

61

02/01/2012 11:40:33
by: InNomina

Conditional select

6

96

02/01/2012 11:01:12
by: Lamprey

lookup tables

5

84

02/01/2012 09:56:42
by: visakh16

replace space with underscore

3

81

02/01/2012 09:29:49
by: visakh16

Tabular function in a join

3

108

02/01/2012 09:28:45
by: visakh16

Possibly simple

1

68

02/01/2012 09:26:18
by: visakh16

SQLdataadapter - what is it (in C#) ?

1

73

02/01/2012 07:59:46
by: sunitabeck

General SQL Server Forums / New to SQL Server Administration

Full Recovery Model and Logs

6

34

02/10/2012 18:50:08
by: Kristen

Backup Trick

6

56

02/10/2012 18:04:42
by: robvolk

Concept of creating or attachind DB to the instanc

1

24

02/10/2012 11:09:28
by: visakh16

Options for Database that will no longer be used

6

47

02/09/2012 16:41:48
by: Michael Valentine Jones

How safe/dangerous is this?

8

133

02/08/2012 06:50:25
by: sunitabeck

what role should be added for accessing sp?

3

43

02/07/2012 20:33:57
by: visakh16

Adding cluster index to pk had non cluster

0

24

02/07/2012 09:12:31
by: sarahmfr

Transfer large file from coast to coast

basicconfiguration

2

138

02/06/2012 17:14:50
by: dsf74

User Security settings Excel Connection

2

49

02/06/2012 16:39:47
by: blund

Using SQL Management Studio for Excel export

2

87

02/06/2012 15:16:54
by: visakh16

logging into SQL Server 2008 management studio

8

55

02/06/2012 14:29:36
by: tkizer

restoring databases and recreating user and roles

1

72

02/02/2012 13:23:51
by: tkizer

How to launch database copy wizard?

2

67

02/02/2012 10:09:28
by: Eagle_f90

Permissions

1

126

02/01/2012 20:47:39
by: namman

General SQL Server Forums / Script Library

Date Table Function F_TABLE_DATE

1

2

3

4

Michael Valentine Jones

76

64829

02/08/2012 15:45:12
by: MorrisK

Pl/sql procedure to check data

2

94

02/06/2012 12:33:00
by: zaheer.mic

Check string for number of errors

1

53

02/03/2012 17:25:15
by: noobapap

ISO Year Week Day of Week Function

Michael Valentine Jones

2

10643

02/03/2012 07:53:31
by: Lxocram

General SQL Server Forums / Data Corruption Issues

Please help me out

2

221

02/02/2012 23:36:51
by: belial66

Unexpectedly MS SQL Services Stops

0

41

02/02/2012 04:13:37
by: imughal

General SQL Server Forums / Database Design and Application Architecture

any reason to choose columns for byte alignment?

12

51

02/10/2012 20:06:59
by: jezemine

One to Many relationshup implementation

6

39

02/10/2012 14:59:43
by: ramindya

One to many Relationship table design.

0

10

02/10/2012 14:25:58
by: ramindya

Duplicate Composite

3

35

02/08/2012 11:34:30
by: cardullo4321

Data Replication

2

39

02/07/2012 12:53:53
by: X002548

Recomendations for column type.

0

41

02/06/2012 20:42:08
by: Eagle_f90

Table Designs for saved search criteria

0

36

02/06/2012 17:21:10
by: nothingSpecial

deriving table relationship from sprocs

3

70

02/06/2012 03:35:17
by: Kristen

SQL INSERT - DATABASE CREATION

4

74

02/05/2012 14:30:53
by: Kristen

SQL Server 2008 Forums / Transact-SQL (2008)

Difference Between 2 Columns and Running Total

11

67

02/11/2012 08:01:52
by: visakh16

SQL time difference query problem

3

23

02/11/2012 07:52:18
by: khtan

datetime convert to date

7

51

02/11/2012 04:59:24
by: farrukh635

SQL Ranking Rows

3

28

02/10/2012 21:33:21
by: khtan

selective delete

6

31

02/10/2012 16:50:57
by: Lamprey

SQL Server/Sybase questions?

4

29

02/10/2012 12:45:25
by: yosiasz

Sending Email

11

61

02/10/2012 11:52:58
by: visakh16

QUERY

10

46

02/10/2012 11:25:44
by: visakh16

Computed Column Formula

9

56

02/10/2012 10:25:43
by: visakh16

Complex Order By

9

78

02/10/2012 10:19:09
by: DonAtWork

joining 2 queris

1

27

02/10/2012 09:43:55
by: visakh16

Update Help Required to Fix Duplicate Data Issues

12

80

02/10/2012 09:38:57
by: visakh16

Density Query Help

5

42

02/10/2012 09:27:32
by: visakh16

insert table from one to another

2

27

02/10/2012 07:07:58
by: teamjai

AFTER UPDATE, INSERT

6

74

02/10/2012 03:42:57
by: Kristen

Need help calling a function from a SQL Server 200

4

32

02/09/2012 17:42:24
by: visakh16

Speed Up Trigger Insert Query

16

95

02/09/2012 17:41:26
by: Kristen

Datetime to varchar

2

22

02/09/2012 17:39:40
by: visakh16

find out if a job is running or when it last ran

1

33

02/09/2012 14:22:11
by: visakh16

Decode oracle function equivalent in sql server

2

24

02/09/2012 13:58:37
by: visakh16

join tables problem?

13

160

02/09/2012 11:53:39
by: streetWinner

group date

2

21

02/09/2012 11:42:24
by: mike13

Data Usage Per Row

2

37

02/09/2012 10:31:58
by: martind1

need help to calculate age

3

33

02/09/2012 09:09:09
by: DonAtWork

Need to place <BR> in my resultset

8

72

02/09/2012 07:07:04
by: Kristen

SELECT, JOIN or WHERE

2

51

02/09/2012 03:58:46
by: GilaMonster

Optimized Query

GiorgiZautashvili

4

77

02/09/2012 01:35:20
by: GiorgiZautashvili

Each GROUP BY expression must contain at least one

3

38

02/08/2012 17:38:20
by: sunitabeck

fill missing days and grouped by totals

4

66

02/08/2012 14:14:13
by: visakh16

Best way to get last ID?

19

143

02/08/2012 14:10:42
by: visakh16

CSV list and count the elements?

2

25

02/08/2012 11:51:44
by: learntsql

Returning one set of results

4

44

02/08/2012 11:31:45
by: martind1

XML Data

9

175

02/08/2012 03:22:30
by: djcarpen11

Access MYSQL database from Microsoft Sql ?

2

55

02/07/2012 22:44:44
by: damon88

How to calculate business hours from log table

8

179

02/07/2012 19:27:17
by: yosiasz

Question about sp_executesql

3

35

02/07/2012 14:10:01
by: BruceT

T-SQL Group By question

6

72

02/07/2012 13:33:39
by: Ifor

Group By with Subquery

3

44

02/07/2012 13:03:33
by: X002548

ROW_NUMBER with UNION ALL SELECT statements

1

64

02/07/2012 12:34:30
by: visakh16

Crosstab pivot problem with multiple tables

0

33

02/07/2012 10:11:50
by: MrOnion

Stored Procedure update variable tablename

5

41

02/07/2012 10:08:21
by: spinningtop

SQL recurring job

6

102

02/07/2012 09:53:09
by: rusmanicai

MOD %

2

41

02/07/2012 09:33:04
by: webfred

Query Required

1

38

02/07/2012 06:51:50
by: sunitabeck

Bulk instert into MS SQL 2008R2 from XML RAW data

4

73

02/07/2012 03:24:12
by: dkekesi

select rows by adding to datetime

3

57

02/06/2012 20:26:18
by: visakh16

Seleting prev. N rows from current row (ad-hoc)

9

95

02/06/2012 18:25:19
by: visakh16

Conditional where clause

2

53

02/06/2012 16:58:46
by: visakh16

Changing select variable based on if statement

4

47

02/06/2012 16:03:54
by: visakh16

convert to datetime

5

80

02/06/2012 14:56:54
by: visakh16

change field name dynamically

6

96

02/06/2012 13:19:57
by: robvolk

Large dynamic Query.

10

70

02/06/2012 11:01:47
by: Kristen

order by with union statement

7

80

02/06/2012 10:07:22
by: visakh16

Trouble with a CTE Hierarchy

1

49

02/06/2012 09:32:14
by: visakh16

Get percent of query in database

3

63

02/06/2012 09:08:50
by: tungdt

Case

8

70

02/06/2012 04:41:41
by: Rheinhardt

subquery vs declare @mytable as table

13

98

02/05/2012 11:44:08
by: sarahmfr

query taking over 11 seconds to run

11

140

02/04/2012 17:31:00
by: jackv

Replacing nested views with stored procs

17

160

02/04/2012 13:45:48
by: cornall

alternative to declare @xx as table

3

84

02/04/2012 11:32:53
by: GilaMonster

kill history

1

39

02/03/2012 22:35:32
by: russell

Return a hierarchy: CTE or not

6

86

02/03/2012 19:42:05
by: sunitabeck

Selecting specific Row_Number using Where clause?

2

77

02/03/2012 17:06:36
by: SQLIsTheDevil

building dynamic sql

4

87

02/03/2012 16:33:00
by: arkiboys

Indexing Views Derived from 3 Tables

9

77

02/03/2012 13:10:48
by: Kristen

Help with Pivot

1

53

02/03/2012 09:41:13
by: visakh16

Way to read more records from sql server

2

58

02/02/2012 23:30:48
by: visakh16

Need help changing SQL Server Collation.

2

69

02/02/2012 19:41:51
by: visakh16

RESOLVED: Select based on count

3

58

02/02/2012 18:21:26
by: visakh16

Update column on all rows by multiplying cur value

2

67

02/02/2012 16:15:17
by: jwigg5pt0

How to determine how many combinations!?

9

112

02/02/2012 14:34:43
by: mmiller18

Query performance issue

7

93

02/02/2012 11:54:55
by: Kristen

Select and Varbinary

3

76

02/02/2012 10:31:33
by: visakh16

bcp export data from global temp table

3

69

02/02/2012 10:24:51
by: visakh16

Columns to rows query help

5

72

02/02/2012 10:24:33
by: visakh16

To find Circular dependency in a table

1

49

02/02/2012 10:07:33
by: visakh16

displaye data

7

58

02/02/2012 09:09:12
by: sunitabeck

variable on where clause

6

96

02/01/2012 16:08:13
by: visakh16

Replace a field with data from other fields

2

53

02/01/2012 15:08:15
by: visakh16

Optimization

3

111

02/01/2012 12:38:22
by: Kristen

Text In Row values with Removing Next Line image

1

61

02/01/2012 09:33:11
by: visakh16

Help me with this single table

4

128

02/01/2012 09:30:31
by: visakh16

Save result set to a text file

5

90

02/01/2012 09:30:15
by: visakh16

SQL Server 2008 Forums / SQL Server Administration (2008)

Database Mirroring Configuration

0

10

02/11/2012 03:28:55
by: naresh_337

Schemas

7

87

02/10/2012 23:12:00
by: X002548

Script to drop fk in all tables linked to a pk

4

52

02/10/2012 21:19:46
by: sarahmfr

SQL monitoring third party tools

1

20

02/10/2012 18:48:19
by: patshaw

Messaging User of time out

1

15

02/10/2012 18:06:34
by: russell

Need help with SQL Server 2008 R2

7

35

02/10/2012 16:15:01
by: learningsql00

Deny 'sa' from acessing a DB

5

54

02/10/2012 12:49:43
by: Sachin.Nand

Need help with SQL Server 2008 SQL_Latin1_General_

2

25

02/10/2012 11:38:21
by: learningsql00

The WITH MOVE clause can be used to relocate one o

7

1294

02/10/2012 10:16:38
by: ngenoh

Scripting an existing install

0

17

02/10/2012 09:26:35
by: pareshmotiwala

create trigger hangs Resolved

4

28

02/10/2012 07:13:34
by: lappin

User inactivity time out

2

38

02/09/2012 17:22:45
by: MarkLandau

[130] SQLSERVERAGENT stopping because of Windows s

3

56

02/09/2012 13:41:01
by: jeffw8713

Connection Error

2

48

02/09/2012 07:35:05
by: miguelaup

Index Fragmentation Problem

4

73

02/09/2012 05:04:18
by: DaleTurley

Errors in the metadata manager, event ID 19

0

26

02/09/2012 01:32:44
by: imughal

add FILE to a filgroup erroring out

1

33

02/08/2012 17:08:42
by: tkizer

Controlling backup and log size

3

80

02/08/2012 03:49:59
by: PerS

changing a pk set as noncluster to cluster

7

84

02/07/2012 12:55:20
by: sarahmfr

Crystal Report Viewer

0

22

02/07/2012 09:58:36
by: rusmanicai

rebuilding indexes

8

101

02/06/2012 03:13:07
by: Kristen

stopping MSSQLFDLauncher

3

61

02/04/2012 17:16:19
by: tkizer

connect to different instance (HELP!)

6

102

02/03/2012 23:40:21
by: tkizer

Grant permissions to certain object types at once

1

61

02/02/2012 15:14:54
by: russell

Slow performing query

8

100

02/02/2012 13:26:30
by: tkizer

Add note to cluster

1

71

02/01/2012 13:24:37
by: dinakar

Linked Server

1

70

02/01/2012 13:00:03
by: visakh16

Database log backup of large file

1

95

02/01/2012 08:07:46
by: GilaMonster

SQL Server 2008 Forums / SSIS and Import/Export (2008)

parametr into job

1

18

02/10/2012 10:39:27
by: visakh16

Running multiple CREATE..DROP statements in EST

7

42

02/09/2012 14:17:40
by: rockstar283

ssis for advanced

0

24

02/09/2012 03:12:55
by: inbs

Import/Export skipping last row

5

42

02/08/2012 18:57:26
by: tkizer

Problem with Dynamic Excel Destination

17

65

02/08/2012 16:29:15
by: visakh16

Package not executing properly through SQL Agent

3

55

02/08/2012 14:16:40
by: visakh16

Batch process in ssis package

3

126

02/07/2012 23:35:58
by: avlakshmi77

SQL Server 2005 Export to excel 2007

1

31

02/07/2012 14:41:39
by: visakh16

Command text was not set for the command object

8

59

02/07/2012 13:49:23
by: visakh16

SSIS debug

0

31

02/07/2012 06:44:44
by: Oliver wang

incremetal loading slow

5

59

02/07/2012 03:46:02
by: Kristen

if...then in loop

1

41

02/06/2012 17:01:18
by: visakh16

load excel files

1

43

02/06/2012 09:33:16
by: visakh16

Error importing from Access '97

8

105

02/04/2012 04:27:31
by: Jake Shelton

Import/Export From database to another Automated?

1

2

31

618

02/03/2012 14:33:36
by: yosiasz

Capture when Execute Package Task passed/failed

3

51

02/03/2012 11:57:45
by: visakh16

SSIS package fails as SQL Agent Job

6

58

02/03/2012 11:57:27
by: visakh16

get latest file by ssis

12

103

02/03/2012 07:11:48
by: inbs

I'm sure there is an easy answer to this but...

3

91

02/03/2012 06:18:29
by: elwoos

SQL works in Management Studio but not in SSIS

11

132

02/01/2012 12:18:41
by: visakh16

Slowly changing dimesnion Type 2 chnage

7

132

02/01/2012 09:49:43
by: visakh16

SQL Server 2008 Forums / High Availability (2008)

Recommended Cluster Disk Setup

11

254

02/03/2012 00:19:21
by: dinakar

SQL Server 2008 Forums / Replication (2008)

Snapshot Agent Schedule

1

18

02/10/2012 15:43:44
by: russell

Transactional Replication SQL 2000 -SQL 2008

1

2

30

195

02/09/2012 14:30:28
by: ssunny

SQL Server 2008 Forums / Analysis Server and Reporting Services (2008)

Adding row count to grouped details

5

33

02/10/2012 12:33:59
by: visakh16

SSRS - format date with null entries

5

55

02/08/2012 21:34:56
by: visakh16

Output max date from a query

5

43

02/08/2012 21:32:32
by: visakh16

SSRS Report

1

33

02/08/2012 14:22:36
by: visakh16

Configuring for windows auth

1

62

02/06/2012 16:28:24
by: tvanman

Dynamic legend in bubble chart (SSRS 2008 R2)

0

37

02/03/2012 08:40:32
by: apocalyptica

Multi value parameter passing to child report?

3

68

02/02/2012 23:56:11
by: visakh16

comparing this period to last QTD, YTD, MTD, etc..

3

118

02/02/2012 10:27:15
by: rpatel18

Set Excel Sheet Names in SSRS

0

49

02/01/2012 09:53:35
by: sandesh.ravi

SQL Server 2008 Forums / Other SQL Server 2008 Topics

A view excuted when open design times out

1

29

02/09/2012 13:38:12
by: russell

Question about Kindle books...

0

39

02/08/2012 10:54:34
by: malachi151

Migrate from SAP BO to SSIS/Pentaho PDI

1

68

02/06/2012 09:56:21
by: matthewspare

Track orders from commission junction login

1

81

02/06/2012 01:56:58
by: khtan

Money datatype

6

80

02/03/2012 17:47:28
by: Kristen

Not getting refreshed

3

58

02/03/2012 12:16:10
by: visakh16

SQL Server 2005 Forums / Transact-SQL (2005)

Finding turnover time between records

6

35

02/10/2012 18:07:38
by: SwePeso

YTD Query Issue

4

32

02/10/2012 17:00:57
by: robvolk

error in case statement

13

53

02/10/2012 16:05:02
by: visakh16

What happens to CLR UDF's on backup/restore

R

2

44

02/10/2012 12:28:30
by: robvolk

SELECT IN misses NULLs; efficiently finding them

R

8

54

02/10/2012 08:10:49
by: R

Join and retrieve records

5

62

02/09/2012 12:44:51
by: Lamprey

Noob help with syntax linking in a CLR function

1

2

R

21

225

02/08/2012 18:28:32
by: robvolk

SQL query help

2

45

02/08/2012 17:01:59
by: Makaio780

Need @@RowCount from a select query

2

40

02/08/2012 09:49:45
by: Kristen

Can any body help me

2

47

02/08/2012 03:49:30
by: Sycopons

Problem in SQL query

12

692

02/08/2012 02:09:39
by: khtan

Update trigger fails on count condition

6

83

02/07/2012 13:36:24
by: Kristen

SSRS 2008 R2 custom DLLSecurityPermission error

0

27

02/07/2012 08:50:04
by: rajarajan

HTML inside a mail

2

89

02/07/2012 07:47:54
by: skybvi

Long running Insert query

0

38

02/07/2012 06:05:21
by: ceescap

Join on null or a value - one row return only

3

62

02/06/2012 11:51:51
by: visakh16

Linked Server Stored Procedure

5

109

02/06/2012 10:06:56
by: duncanwill

Please help me about sql error !

13

96

02/06/2012 07:08:10
by: khtan

Syntax error

5

66

02/03/2012 14:14:05
by: visakh16

how to use count with joint talbe

5

67

02/02/2012 22:22:43
by: rudba

select distinct and grouping

15

145

02/02/2012 18:21:52
by: visakh16

Selecting data part of time

2

71

02/02/2012 16:06:52
by: skybvi

Improving the following update

3

96

02/02/2012 11:48:41
by: visakh16

SQL LOG FILE

6

82

02/02/2012 11:44:17
by: wided

Pivot on multiple columns

1

75

02/02/2012 11:42:29
by: visakh16

how to select lower case letters

7

88

02/02/2012 11:10:54
by: skybvi

Binary to base64 for xml explicit truncation

0

38

02/02/2012 09:46:59
by: ftsoft

how to count

11

175

02/01/2012 17:46:00
by: sunitabeck

Invalid column name

3

75

02/01/2012 13:11:14
by: visakh16

Fastest method of parsing csv string into table?

R

12

131

02/01/2012 12:52:57
by: R

Help on Pivot Query

0

44

02/01/2012 10:07:27
by: sridhar3004

SQL Server 2005 Forums / SQL Server Administration (2005)

Using variable in a select statement

12

97

02/10/2012 07:38:21
by: Kristen

how to script a schedule

5

65

02/09/2012 19:06:35
by: Bustaz Kool

Database backup Error

3

63

02/07/2012 04:01:26
by: GilaMonster

How to disable Export for Db_Datareader Users?

1

54

02/07/2012 03:54:43
by: GilaMonster

resolve collation conflict in sql 2005

2

41

02/06/2012 13:35:13
by: visakh16

sql mail

1

108

02/03/2012 12:07:26
by: Bustaz Kool

Maintenance Plan

7

104

02/01/2012 13:04:50
by: ksr39

SQL Server 2005 Forums / SSIS and Import/Export (2005)

Script file

7

31

02/11/2012 08:02:24
by: visakh16

BCP from SQL to TXT file

7

43

02/10/2012 15:36:21
by: justjohno

Calling Asp page in SSIS Packages

4

418

02/08/2012 16:17:54
by: visakh16

which source/destination to use

3

67

02/05/2012 15:53:22
by: visakh16

SQL Server 2005 Forums / Replication (2005)

Replicating Tables?

3

87

02/02/2012 17:05:37
by: tkizer

SQL Server 2005 Forums / High Availability (2005)

Log Shipping

7

90

02/01/2012 23:35:38
by: tkizer

SQL Server 2005 Forums / Analysis Server and Reporting Services (2005)

Sub Report or Expand/Collapse Single Cell

0

9

02/10/2012 08:54:04
by: mcfly1204

How to pass parameters to OLAP based SSRS report f

3

56

02/08/2012 07:39:44
by: shah36

Non Mandatory Queried Report Parameters

1

2

22

750

02/07/2012 02:13:20
by: cirajc

Cannot change server properties

0

37

02/03/2012 12:51:40
by: Peter99

Reporting Services Error

3

86

02/01/2012 09:50:41
by: visakh16

SQL Server 2005 Forums / Express Edition and Compact Edition (2005)

logging SQL Query execution fail results

0

20

02/10/2012 04:29:39
by: Reddappa

Callback after UPDATE querry

9

108

02/06/2012 09:47:06
by: simsekm

SQL Server 2005 Forums / Other SQL Server Topics (2005)

Error 126

9

16292

02/11/2012 01:37:26
by: sqlg27

solving query

1

63

02/03/2012 10:08:26
by: SwePeso

SQL Server 2000 Forums / SQL Server Development (2000)

cast & convert failure varchar to decimal

2

40

02/09/2012 14:28:12
by: visakh16

conversion failure varchar to decimal

2

27

02/09/2012 04:15:02
by: webfred

BCP tab issues

0

22

02/08/2012 20:27:45
by: SkinniPM

SQL 2000 USER DEFINED FUNCTION

2

47

02/08/2012 03:54:01
by: noblemfd

FUNCTION

1

35

02/07/2012 17:37:07
by: tkizer

confused

0

37

02/07/2012 04:58:17
by: kshitizgp

How to do this Query

5

96

02/02/2012 04:29:31
by: khtan

SQL Server 2000 Forums / Transact-SQL (2000)

Union with NEWID()

4

84

02/03/2012 16:52:04
by: webfred

get first and last day of a week

1

2

27

96304

02/02/2012 15:22:07
by: Fromper

SQLServer JOBS RANDOM BEHAVIOUR

1

77

02/01/2012 09:55:13
by: visakh16

Query Time Out

indraneelkurane

1

66

02/01/2012 08:25:06
by: GilaMonster

SQL Server 2000 Forums / Analysis Services (2000)

Saving setting in SSAS Cube reprot

0

20

02/08/2012 08:18:53
by: rajkadam

Modifying query of dimensions in SSAS 2000 cubes

0

16

02/08/2012 08:13:22
by: rajkadam

Development Tools / Reporting Services Development

Report Manager

0

25

02/06/2012 22:59:24
by: raaj

DateFormat in SSRS Parameter

1

56

02/02/2012 11:47:47
by: visakh16

Site Related Forums / Site Related Discussions

Report spam here

	1	2	3	4	5	6	7	8	9	10
	11	12	13	14	15	16	17	18	19	20
	21	22	23	24	25	26	27	28	29	30
	31

606

43794

02/10/2012 09:33:47
by: robvolk

Jiggling ads

9

106

02/06/2012 09:29:48
by: Kristen

Site Related Forums / Article Discussion

Article: Custom Auto-Generated Sequences with SQL Server

1

2

25

6663

02/08/2012 07:49:02
by: Jeff Moden

Site Related Forums / The Yak Corral

someone open a window

1

2

21

555

02/10/2012 11:57:13
by: Kristen

Twit List

	1	2	3	4	5	6	7	8	9	10
	11	12	13	14	15	16	17	18	19	20
	21	22	23	24	25	26	27	28	29	30
	31	32	33	34	35	36	37	38	39	40
	41	42	43	44	45	46	47	48	49	50
	51	52	53	54	55	56	57	58	59	60
	61	62	63	64	65	66	67	68	69	70
	71	72	73	74	75	76	77	78	79	80
	81	82

1628

202927

02/07/2012 13:46:10
by: Kristen

A little something to cheer you up ...

3

100

02/07/2012 13:43:30
by: JimL

Bada$$ server!

14

767

02/06/2012 18:01:36
by: X002548

Bluuuuuuuuuuuuuuue

0

44

02/06/2012 18:00:31
by: X002548

Couldn't be further from the survey

1

2

3

48

647

02/03/2012 07:10:16
by: RickD

Other Forums / Other Topics

Issues With Import and Export

2

50

02/07/2012 10:54:21
by: JayPrakashSharma

Export to Excel Question

1

33

02/06/2012 20:26:08
by: visakh16

New posts since last logon.
Old Posts. ( 20 replies or more.)
Locked topic.

Jump To:

SQL Server Forums

© 2000-2009 SQLTeam Publishing, LLC

This page was generated in 0.34 seconds.

Powered By: Snitz Forums 2000