Programming SQL

Bulk Insert Error
I am getting the following error when trying to perform a Bulk Insert: Msg 4864, Level 16, State 1, Line 1 Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 1, column 2 (GROUP_ID) Here is my SQL Code: BULK INSERT DeepDiveGroup8.dbo.atb_tbl FROM 'C:\Test\... 21 Jan 2010 19:13

oracle RowType Issue
Hi All, Im new to Oracle. I have a Rowtype and i want to Loop through that Rowtype without mentioning the Column name. My code as below : declare empRowType Emp%ROWTYPE; begin SELECT * INTO empRowType FROM Emp WHERE Emp_id = 101 ; for x in ( select column_name from user_ta... 20 Jan 2010 10:40

Help with date range.
I need a query to display the date like below. Thank you in advance. 9/1/07 10/1/07 11/1/07 12/1/07 1/1/08 … 12/1/09 1/1/10 ... 20 Jan 2010 05:07

Field with 6 data points seperated by ~
I have a other info field that for one client they pass 6 data points in. It is set up that they always have the same 6 data points. I need to seperate the 6 datapoints into seperate fields. The datapoints can have different amounts of text and numbers so a simple mid statement won't work. Example ex1 Price:... 19 Jan 2010 23:40

Need help with "SUM-IF" query
Hello! I need some help with a Query to solve this requirement: We have one table (Values) containing a list of values with its timestamps, and a second table (Flags) containing flag-values with its timestamps. I need to get a SUM of those values in Values table for which the flag value satisfies for the timestam... 21 Jan 2010 12:21

Trying to setup Trigger to Update Each record
How can I set up a Trigger to Update when I Import data into a table.... I manually Import Data into a Table each month by Right clicking on the Database and Selecting Tasks..Import.. I would like for the Trigger to Execute after the file has been imported... Any help is greatly appreciated.... Brian --... 19 Jan 2010 13:33

Multi-value paramter syntax...help
How do I write the syntax for a stored procedure that has one parameter but accepts multiple values. I am running a report from reporting services that can pass multiple values or pass all values to the stored procedure stored procedure 1: exec getcolor @color = blue....this runs fine. stored procedure 2: ex... 25 Jan 2010 09:26

Fill Factor on a clustered index
Tricky one. Have a database getting alot of locks...Darn sql server and those silly page locks. Anyway had to change the application to use a disconnected methodology and check for changes before doing an update. Love the asp.net alternative. It just clobbers data (unless you write code to check)...record locks... 20 Jan 2010 16:20

SSMS Won't Open Database
I originally posted this thread on January 13th but have not yet gotten resolution. I have a production database on the web which I cannot open using SSMS 2008. The machine I used to develop the database was destroyed by lightning and I was forced to buy a new machine. I can get to the server but cannot expand t... 18 Jan 2010 17:42

Which one uses less memory?
I have two ways to use connection with sqlcommands. here is sample codes in C#: The Way First: DataSet ds = new DataSet(); SqlConnection conn = new SqlConnection(" .... "); conn.Open(); SqlDataAdapter da = new SqlDataAdapter("select * from table1", conn); da.Fill(ds, "table1"); da.SelectCommand.CommantText = "s... 19 Jan 2010 10:10