I want to be able to select all the records from a table (query) and add a column when a certain condition exists eg Table Contents CentreA CentreB QS QSP Op JobNo WS MTN 100 10 1 G123 RT RAT 100 0 1 G45...more >>

Dear sir, Now i have big problem with SQL i lost Log file now i have only master file . i used recovery to find Log file but not found. Please tell me how to rebuild Log file from Master file? Waiting your suport, Bunthach Eng student of Cambodia (My mail bunthachx@yahoo.com, My phone ...more >>

Hello there I have many tables that i would like to kbow on each record who inserted, updated data and when it happend? For this i've learned about function call SUSER_SNAME() that always gives me the current user who is in the system. For insert case i've solved it simply: added two fie...more >>

I am trying to Join 2 tables to get only the last job worked at. If I have the following: DROP TABLE table1 go CREATE TABLE table1 ( Field1 int, FullName varchar(15), Location varChar(15) ) go DROP TABLE table2 go CREATE TABLE Table2 ( Field1 int, Company varChar(15), JobTitle...more >>

Hello all, Thanks in advance to contributions. I would like to be able to manipulate myTSQL in a stored procedure, based on a value in a parameter, using the case statement. I want to avoid Begin..End constructs My code is such... select field1,field2 etc etc from Order o inner join t...more >>

Hi all, As I tried to describe the problem in the subject, an Oracle statement trigger (supposed to run just once) runs for each row affected by the statement which was issued from Query Analyzer or my VB.NET code, via a linked-server definition in SQL Server. This behaviour is very stra...more >>

I am trying to convert a VB6 SQL 2000 created code into VB.NET. Everything complies fine but then I get this error message: An unhandled exception of type 'System.InvalidCastException' occurred in Project1.exe Additional information: QueryInterface for interface DTS.CustomTask failed. ...more >>

Hi, I would like to learn more about SQL 2005 and I would like to buy 2 books. First one should be the book with practical problems and solutions to that problems, so book with examples and not book about introducing the new features and full of documentation. The examples should be mostl...more >>

I have a database here that's 3.3 GB that has a transaction log of 14.8 GB. We want to make the log WAY smaller. like doing a checkpoint or backup with log truncation or something. Got some BOL / code snips for us? -- Peace & happy computing, Mike Labosh, MCSD "When you kill a ma...more >>

I have a process that runs that pulls data from an Oracle database to SQL server, when I encounter an error I'd like to write the error description back to Oracle for the record that failed for reporting purposes. I can get the code using @@ERROR but I'd like to have the message associated wit...more >>

Ent Manager is nice, but I need to make some DDL changes to a database (convert a column from char to varchar, add a new column, etc) with SQL. Is there a good primer for this? I'm sure it is not too hard, I just have not had to do this. Thanks. -John...more >>

This is not a "bug" per se, as I know that the order of rows in SQL Server isn't guaranteed to be consistent unless ORDER BY is specified. Still, this is somewhat odd behavior. This involves paging logic via parameterized queries. Since I can't post my client's DDL, I have used northwind to d...more >>

OK, I've looked thru the BOL so I'm probably just using the wrong terminology, but how do I output a CSV file from a query? Willie ...more >>

I am getting an error for code structure I have used several times before with no hitch. "Procedure or function xxx has too many arguments specified" Here is the code I am executing. sql.CommandText = "sp01_InsertEmployee" sql.Parameters.Add("@emp_name", SqlDbType.VarChar, 50).V...more >>

Is it possible to do a if then else statement in a sql view qry. I am use to Ms Access and using Immediate If (IIF). What Im trying to do is If Left (FieldA,1)=3 Then "xyz' else If Left (FieldA,1)=4 Then "abc' else If Left (FieldA,1)=5 Then '123' ...more >>

I have a situation where we converted over a large database. The database had one table that used autonumber(Access) that we need to preserve the IDs upon conversion for a table that refereneces the field. So during conversion I turned off the identity and it brought over the ID column wit...more >>

Hello! Is that possible to call a job using SELECT CASE statement? I am trying to run some jobs based on some cases in my stored procedure. See below the code: select case RptName when 'A' then [msdb].[dbo].[sp_start_job] @job_name = 'A' when 'B' then [msdb].[dbo].[sp_start_job] @job_n...more >>

Hello I have 2 tables Table1> Table2 (1-* relation) Table1 (ID,Name) Table2 (ID,Table1ID,ImagePath); I need to select from Table2 group by Table1ID and concatenate ImagePath(s) with "," separator. How could i do this?? ...more >>

Hello Need to replace text_A with text_B contained within 2 columns of table., SQL server 2000. table name = stock column names = description and long_description Thanks for any help Regards Maxwell ...more >>

Hi, do u know a good Ebook for sql server 2005? -- Message posted via http://www.sqlmonster.com...more >>

I have a situation where I am using SQL Server 2005 and I need to be able to add a column in a specific ordinal position. I have looked at BOL and I wasn't able to find any mention of being able to specify Ordinal position. Is there a way??? Thanks! Ron ...more >>

i am using sql 2000 and calling a sp from vb.net code. I want when a error occur in sp i want to do some processing in sp and do not want to throw that error to front end. how can i achieve that as after checking @@error and doing processing, still error gets thrown to front end ...more >>

Hi. I have 2 queries that are similiar They involve 2 tables, 1) CDR which has a primary key of cdrid and has half a million rows 2) MODULE which has a primary key of moduleid and has only 240000 rows Neither of the two tables have indexes in it aside from the clustered index produced...more >>

Hello. I using a simply SELECT statement to retrieve some data from a SQL SERVER via an ODBC connection. I had to go from VARCHAR to TEXT because the amount of data. Anyway, my SQL statements worked just fine when I was using VARCHAR, but now since I am using TEXT, I am only receiving part of th...more >>

I need to know the last time each table on my database was accessed or modified. Is that possible? I'm usign SQL Server 2000....more >>

I'd like to expand a coalesce function to account for Case 3, which says that if Date2 is null, then stay with null. As you see the following only satisfies Case 1 and Case 2. Any ideas appreciated. I think that a fancy CASE statement might do it, but I can't figure it out. Thanks, --Bob Sel...more >>

Good Morning, I have the SQL statement below which displays each detail record from a table, using a union for the column total row. My issue is when I try to return records where the sum of service is greater to or less than a value, all detail records are returned. For example, the ye...more >>

Hello, i need to convert this store procedure from Informix to SQL Server and only obtain error's. Can anyone help me? CREATE PROCEDURE atribui_num_carta @dia_env INT, @mes_env INT, @ano_env INT DECLARE @aux_numcarta INT, @aux_nu...more >>

Hi, sorry for the OT question but the readers opinions will matter more to me. I team lead a small development team of .net and sql programmers. There is another team in our group like ours. We are tracking our project requests and statuses in Excel as it is shared with people ourside our te...more >>

Hello Everybody, I have a table which has arround 30 millions rows. Table structure is as following.. CREATE TABLE TestTable (Id INT, --which is PK, EmpId INT, --There is a non cluster index on it. DeptName VARCHAR(50), Hours NUMERIC(5,2), Tdate DATETIME, ProjectNumber smallint, ..and fe...more >>

Is it possible to make Sql Server throw a custom error message when a CHECK Constraint fails please? ...more >>

In a SP I create a global temp table as follows: if not object_id('tempdb..##t') is null drop table ##t create table ##t (a int, b int) Then, only on occasion, I get an "invalid column" error when referring to column b. I think this is due to the fact that I create a table with the same ...more >>

Hello All, I am trying to get started with SQL programming and don't know where to begin. I would like to use Visual Studio.Net and access a "local database". For example, something simple like a "member database" for a volunteer organization. My first concern is how and what to inst...more >>

hey all, I have a main program ('Program1) which calls ('Program2') Program2 creates indices on a staging table to spped up Program1. At the end of Program1, I call program2 to drop the indices. I have noticed that this time when Program2 is called I cannot create the indices as it is atte...more >>

sample function from web; CREATE FUNCTION dbo.DBCreationDate ( @dbname sysname ) RETURNS datetime AS BEGIN DECLARE @crdate datetime SELECT @crdate = crdate FROM master.dbo.sysdatabases WHERE name = @dbname RETURN ( @crdate ) END GO what if the SELECT returns more than o...more >>

Hi There, Can I get the Job ID , Job name and Step ID withing the job itself ? Infact my need is to send a mail with these parameters and some data from user tables. This process I have to do from the different servers and jobs. I would like to impliment this without hardcoding the job nam...more >>

Does anyone know how I can do something like the following:- CREATE PROCEDURE GetClients @deptId as int, @clientGroup as int AS BEGIN SELECT ClientId, Business_Name FROM Clients INNER JOIN ClientStatus ON Clients.CSId = ClientStatus.CSId INNER JOIN Depts ON Clients.DeptId = Depts.DeptI...more >>