Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
Register
Register | FAQ | Members List | Calendar | 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 22 of 22
Search took 0.02 seconds.
Search: Posts Made By: atulmar
Forum: Reporting Services November 21st, 2006, 09:35 AM
Replies: 0
Views: 1,465
Posted By atulmar
Exporting data into Excel file from SSIS

I am using Office 2007 beta. I have a SSIS package that exports the records from sql server to excel file, when number of records is less than 24000 then it exports well, but if number of records is...
Forum: SQL Server 2005 January 27th, 2006, 07:51 AM
Replies: 3
Views: 1,166
Posted By atulmar
both are same, if you are a beginner, but if you...

both are same, if you are a beginner,
but if you are an expert then difference comes in picture.

SQL Technical Consultant
Forum: SQL Server 2005 December 30th, 2005, 11:22 AM
Replies: 2
Views: 1,948
Posted By atulmar
Hi Pitter, first check what sql server edition u...

Hi Pitter,

first check what sql server edition u have installed.
enterprise edition can be installed on windows 2000 server, data center, 2003 only.
now It depends what configuration u have chosen...
Forum: SQL Server DTS July 13th, 2005, 02:50 AM
Replies: 2
Views: 691
Posted By atulmar
jbenson001 is right, becoz u will have to...

jbenson001 is right, becoz u will have to terminate the string inside exec itself.
Atul
Forum: SQL Server DTS July 13th, 2005, 02:48 AM
Replies: 1
Views: 3,145
Posted By atulmar
bulk insert can be used for only flat files, u...

bulk insert can be used for only flat files, u can do the same by writing DTS package.

Atul
Forum: SQL Server 2000 April 12th, 2005, 03:25 PM
Replies: 2
Views: 1,004
Posted By atulmar
need comma seperated values in select

how can i get the comma seperated values

i have a table like this

ID Value
1 A
1 B
1 C
2 D
3 E
Forum: SQL Server 2000 April 12th, 2005, 03:01 PM
Replies: 5
Views: 1,953
Posted By atulmar
yes that will also work atul

yes

that will also work

atul
Forum: SQL Server 2000 April 12th, 2005, 02:18 PM
Replies: 5
Views: 1,953
Posted By atulmar
hi jim, if you want that table is automatically...

hi jim,

if you want that table is automatically corrected.
then you will have use a cursor for that

simply make a cursor
script shoud be like this

declare @var int
declare @id int
Forum: SQL Server 2000 April 12th, 2005, 02:07 PM
Replies: 5
Views: 1,953
Posted By atulmar
there is command in sql server set...

there is command in sql server

set identity_insert on

you can executing this command
after that u can set the value of ID column in the table

Thanks

Atul
Forum: SQL Server 2000 April 10th, 2005, 03:19 PM
Replies: 3
Views: 929
Posted By atulmar
u can use DTS for this Atul

u can use DTS for this

Atul
Forum: SQL Server 2000 April 10th, 2005, 03:13 PM
Replies: 3
Views: 840
Posted By atulmar
there is no need to use distinct in this...

there is no need to use distinct in this query

select *
from S_POLMAI
where POL_NUM not in (select distinct [id] from #temp1)

atul
Forum: SQL Server 2000 April 10th, 2005, 03:12 PM
Replies: 2
Views: 856
Posted By atulmar
shahchi1 is right, but there is more to say every...

shahchi1 is right,
but there is more to say
every object should be qualified by owner name
atul
Forum: SQL Server 2000 April 10th, 2005, 03:10 PM
Replies: 2
Views: 1,073
Posted By atulmar
combine all the queries in a single SP get the...

combine all the queries in a single SP

get the work done

atul
Forum: SQL Server 2000 April 4th, 2005, 09:42 PM
Replies: 1
Views: 688
Posted By atulmar
yep go with query execution plan in query...

yep

go with query execution plan in query analyzer

atul
Forum: SQL Server 2000 April 4th, 2005, 09:37 PM
Replies: 2
Views: 1,031
Posted By atulmar
yep shahchi1 is right atul

yep
shahchi1 is right

atul
Forum: SQL Server 2000 April 4th, 2005, 07:34 PM
Replies: 1
Views: 2,357
Posted By atulmar
hi, i can help you a little in this matter. you...

hi,

i can help you a little in this matter.
you can write a function which will return the column name
after you find the column name write dynamic SQL for selecting the value for that column and...
Forum: SQL Server 2000 March 28th, 2005, 06:59 PM
Replies: 4
Views: 1,094
Posted By atulmar
set rowcount 10 select top 10 from tablename...

set rowcount 10
select top 10 from tablename order by colname desc



atul
Forum: SQL Server 2000 March 28th, 2005, 06:58 PM
Replies: 2
Views: 2,229
Posted By atulmar
if your comma seperated values are integer type...

if your comma seperated values are integer type then you can use exec command to get your job done

like
exec ('select whatever from Tablename where column in (' + cast(commaseperatedvalue as...
Forum: SQL Server 2000 March 28th, 2005, 06:52 PM
Replies: 4
Views: 505
Posted By atulmar
yes shahchi1 is right. atul

yes
shahchi1 is right.

atul
Forum: ADO.NET March 19th, 2005, 03:28 PM
Replies: 3
Views: 698
Posted By atulmar
In multi tier architecture there should be no...

In multi tier architecture there should be no problem of this kind.

becoz there is less and less data to be transfered from one system (database) to another(client or web server)

Atul Kumar Sharma
Forum: ADO.NET March 19th, 2005, 03:22 PM
Replies: 4
Views: 3,142
Posted By atulmar
WebForms don't support too many events. You...

WebForms don't support too many events.

You should use javascript.

Atul Kumar Sharma
Forum: ADO.NET March 19th, 2005, 03:20 PM
Replies: 3
Views: 19,385
Posted By atulmar
Yes you can fill the Data Adapter from command as...

Yes you can fill the Data Adapter from command
as cmd.ExceuteReader()

then from this you can pull data to dataset from dataadapter

as

da.fill(ds,"somename")

Atul Kumar Sharma
Showing results 1 to 22 of 22

 


All times are GMT -4. The time now is 12:27 AM.


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