Programming SQL

sql query
select * from table1 where field1 not in (select field1 from table2 where clause) use these query which giveall the results from table1 which are not in table 2 ... 28 Jul 2008 17:13

Easy columns indexing
Hi Is there an option or script that will automatically/easily index all/most columns of a table or better still all tables in a database? Thanks Regards ... 28 Jul 2008 12:04

Getting error on INSERT.. SELECT using table valued function
Getting: Msg 4104, Level 16, State 1, Procedure ESIMonthlyNC, Line 207 The multi-part identifier "P.ParentId" could not be bound. (note it says BOUND and not FOUND) on this line in SQL below: LEFT JOIN dbo.GetParentsBankAccount(P.ParentId,@RunDate) As BA This is a function that returns a single row table of data ... 25 Jul 2008 19:42

Guru needed for help with cte
Hello - I have the following cte in which I am attempting to take two tables, combine them and FOR EACH distinct date that is listed, return only one date, the amount of only the last AdminAdjustment for that date, only the last DateAdjusted date, etc. I included the data it is returning and for example, i... 26 Jul 2008 10:58

@@ROWCOUNT and @@ERR !?!?!
OK, SO, I want to get BOTH the any error codes that might have been thrown AND if the statement is successful, how many records were updated. Sounds like a simple request but it seems like I can only get one or the other. Example DECLARE @ERRCODE DECLARE @NUM_ROWS UPDATE sometable SET field=x SET... 25 Jul 2008 18:40

BIT data type confusion
According to help this can have value of 0, 1 or null Why then when I display the select results do I see value of -1? And in Management Studio table display I see True or False Also, help says I can refer to 0 or 1 as FALSE or TRUE yet I dont see these values in the reserved words. Can I say Declare MyBit B... 25 Jul 2008 20:43

Date Function Question
Good afternoon, I am attempting to carry over the below function which works in access to be used in visual studio, would someone be so kind as to offer a translation of sorts? This was used in a criteia line in access, and established the year we are in and the year we are in plus one...Thank you! (Format(Da... 30 Jul 2008 19:59

SMO SetDefaultInitFields is confusing
SetDefaultInitFields is confusing, and poorly documented. I'm on SQL 2005 and Visual Studio 2005, and .NET 2.0. I am trying to tell SMO to fetch a bunch of table properties in one call, since the server I am reading from is remote (through a VPN). The code looks like this in VB. Things are actually in Try/C... 28 Jul 2008 12:04

Long time for DTS package
I know this is probably not the most efficient way to do this, but it's the only way I know how I created a DTS package throught the SQL 2000 Import Data wizard - - unfortunately, there were around 30 million records that are being copied from one server to another. Anyway - what I'm asking about is this - ... 28 Jul 2008 15:09

Delete records
Hello All, I have three tables which are joined by a common field CS_Survey_rec ID. How do I delete records from all tables where cs_Survey_RecID >17. This is the first time I am deleting, so please help I don't want to delete the wrong records Thank You Shri ... 28 Jul 2008 04:52