Programming SQL

.net professional
greate ciupazNoSpamGrazi wrote: Re: Change table schema 21-Feb-08 "Tibor Karaszi" wrote: Yeah Tibor ;-) Thanks a lot you all. -- Luigi http://blogs.dotnethell.it/ciupaz/ Previous Posts In This Thread: On Wednesday, February 20, 2008 10:37 AM ciupazNoSpamGrazi wrote: Change table schema Hi al... 22 Jul 2010 09:13

Plz helpppp
Bob, I tried out your code. I am trying to put a file in my PC to a FTP site. The code creates the file in the FTP with the same name and format but has no content. Please help me. Thanks in advance. Regards, Tom Henrik Staun Poulsen wrote: Hi Bob,I'm glad it worked.Best regards,Henrik Staun Poulsen... 21 Jul 2010 18:03

String quotes and variales
I've got a simple sproc that should add an email address if @iType = 1 or delete an email address if iType = 0. I can't get it work. Since I'm using a string variable @recipEmail in the exists tests, do I need to add quotes around it? I'm not errors, it's just not adding/deleting the email address. I think m... 21 Jul 2010 18:03

Combining TOP with GROUP BY?
I've got a table like this ModelID - int, primary key MakeID - int, foreign key to makes table SalesRank - int higher = better. ..... other fields I want the 4 best selling models (highest sales rank) for each of the 6 best selling makes. The 6 best selling makes rarely change so I could get away with hard c... 21 Jul 2010 13:35

Will this newsgroup be cancelled ?
Hello, will this group on SQL Server Programming be cancelled from newsgroup clients and only be allowed from web interface ? but from this link , there is no (Programming) section , where will we meet again ? http://social.msdn.microsoft.com/Forums/en-US/category/sqlserver/ Thank you Bassam ... 22 Jul 2010 18:02

Combine many to one record
I have a database that keeps up with trip information and who attended the trip, the structure is, CREATE TABLE [dbo].[Trips] ( [TripID] [int] IDENTITY (1, 1) NOT NULL , [TripDate] [datetime] NULL , [StartTime] [datetime] NULL , [EndTime] [datetime] NULL , [RLU] [varchar] (10) COLLATE SQL_Latin1_General_C... 27 Jul 2010 05:10

OPENDATASOURCE reads file even if conditions not met?
> IF (SELECT COUNT(*) FROM ##load WHERE filelist = 'test2.xls') =1 AND (SELECT COUNT(*) FROM ##load WHERE filelist = 'test.xls') = 0 BEGIN       if object_id('tempdb..mytest') is not null             drop table tempdb..mytest       SELECT *       INTO tempdb.dbo.mytest       FROM OPENDATASOURCE(... 21 Jul 2010 18:03

[IF loop] OPENDATASOURCE reads file even if conditions not met?
Here's a puzzler. Not sure why I haven't run into this problem before. I'm loading files that may or may not exist. So I do a directory listing, and if the file exists I import it. However, even if the file doesn't exist, it looks like the OPENDATASOURCE is run, and it fails because there's no file to import.... 20 Jul 2010 15:48

Partitioning - adding data to 1 table grows the NDFs of all other
Hi, I have filegroups called 2006, 2007, 2008 etc. I have files, one for each of our larger tables that belong to each filegroup. E.G. File Name File Group 2006_Transactions 2006 2006_Events 2006 2007_Transactions 2007 2007_Events ... 21 Jul 2010 12:28

reference chain - recursive CTE ?
Hello, I have a table filled with streets from which some were renamed one ore more times. Each street has a scode. If it was renamed is has an entry scodenew and status 'S', otherwise no scodenew and status 'G', this is the valid street name. I want to ask for any old street name, and want tot get the valid nam... 21 Jul 2010 00:32