Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
Register
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Showing results 1 to 15 of 15
Search took 0.01 seconds.
Search: Posts Made By: Preethi
Forum: SQL Server 2000 April 9th, 2008, 08:17 AM
Replies: 10
Views: 3,083
Posted By Preethi
I am afraid the only option (Other than format &...

I am afraid the only option (Other than format & re-install all) is the remove all the files in the SQL folder and remove the registry entries too.
(This is where you need to use a third party...
Forum: SQL Server 2005 April 9th, 2008, 05:51 AM
Replies: 15
Views: 1,774
Posted By Preethi
I am not writing the entire code here.. My only...

I am not writing the entire code here.. My only concern is your sub queries.

You need to re-write them
This could be a way of writing. Please go and add additional columns to like to other...
Forum: SQL Server 2000 April 9th, 2008, 05:02 AM
Replies: 10
Views: 3,083
Posted By Preethi
Try installing again as a named instance. You...

Try installing again as a named instance.
You may have to clean the registry and delete the files. There are third party products which clean the rgistry. Keep a backup of the registry first....
Forum: SQL Server 2005 April 7th, 2008, 03:41 AM
Replies: 2
Views: 1,644
Posted By Preethi
To Get the value back to a variable you should...

To Get the value back to a variable you should use sp_ExecuteSQL
Here is an example of what I tried against AdventureWorks

DECLARE @SQL nvarchar(2000), @Rows int
SET @SQL =N'SELECT @RowCount...
Forum: SQL Server 2005 April 4th, 2008, 07:53 AM
Replies: 2
Views: 930
Posted By Preethi
Try this: SELECT MIN(Station) Station, Lat, Lon...

Try this:
SELECT MIN(Station) Station, Lat, Lon
FROM <Table name>
GROUP BY Lat, Lon


G.R.Preethiviraj Kulasingham
Forum: SQL Server 2005 April 1st, 2008, 10:54 AM
Replies: 15
Views: 1,774
Posted By Preethi
I am not sure what client tool/application you...

I am not sure what client tool/application you are using. If you are using SSMS, click on options and goto connection properties. Change the value of Execution timeout.

However this option may...
Forum: SQL Server 2005 April 1st, 2008, 10:44 AM
Replies: 2
Views: 1,872
Posted By Preethi
I remmeber creating linked servers in SQL server...

I remmeber creating linked servers in SQL server 2005 pointing to SQL Server 2000. So I belive that it is possible to create a conenction in SSIS too. But you can't use Copy database here. You may...
Forum: SQL Server 2005 April 1st, 2008, 04:15 AM
Replies: 15
Views: 1,774
Posted By Preethi
You may have a couple of options 1. Do you...

You may have a couple of options
1. Do you need all the data at once? If not, divide the data into multiple chunks and receive them one by one. One possible option (I don't know your data but...
Forum: SQL Server 2005 March 11th, 2008, 08:01 AM
Replies: 8
Views: 1,335
Posted By Preethi
Try this option ...

Try this option
http://www.sqlservercentral.com/articles/Miscellaneous/paramterizingviews/1178/

I have used something similar.. but using my own table :)

G.R.Preethiviraj Kulasingham
Forum: SQL Server 2000 March 9th, 2008, 11:04 PM
Replies: 4
Views: 1,118
Posted By Preethi
In SQL 2000, you don't have the built in feature...

In SQL 2000, you don't have the built in feature of encryption. You can still encrypt using your own method, which may cause not only performance issues but also manageability issues and I will...
Forum: SQL Server 2005 March 7th, 2008, 08:08 AM
Replies: 4
Views: 1,633
Posted By Preethi
It looks like you have solved the problem. If...

It looks like you have solved the problem. If not and your tables are really big and you need to find only the different rows you can use scripts which do that.
It is completely SQL, ...
Forum: SQL Language February 29th, 2008, 03:08 AM
Replies: 2
Views: 1,257
Posted By Preethi
I assume that you have the default setting on the...

I assume that you have the default setting on the first day of the week. :)
This Piece of code Gets the Previous Saturday and the sunday before that day irrespective of the current day.
I have...
Forum: SQL Server 2005 February 29th, 2008, 02:02 AM
Replies: 6
Views: 842
Posted By Preethi
IF you want to display only once in a while, You...

IF you want to display only once in a while, You can use it like this
SELECT RIGHT('000000'+CONVERT(varchar, pk_PRODUCTID), 6) AS ProductCode
Otherwise add an additional (Computed) column using...
Forum: SQL Server 2000 June 9th, 2003, 01:00 PM
Replies: 3
Views: 2,341
Posted By Preethi
Sorry to give this answer: Some time back I...

Sorry to give this answer:

Some time back I checked this Q with Kalen Delaney the author of Iside SQL Server 2000. (One of the Hardcore SQL Server Books) This is what his response is:


Thanks...
Forum: SQL Server 2000 June 9th, 2003, 12:47 PM
Replies: 6
Views: 2,524
Posted By Preethi
You can use select rows from sysindexes where...

You can use
select rows from sysindexes where id = object_id('TableA') and indid<2


Note that TableA is enclosed within quotation marks ('TableA')


Preethi
(G.R.Preethiviraj Kualsingham)
Showing results 1 to 15 of 15

 


All times are GMT -4. The time now is 09:33 PM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.