Hi everybody, I like to asked anyone who is very good at sql to help me display this data in a table format that duplicate headings, subheadings or other columns won't appear twice or more. Can anyone help me? I need to sort them and load them in a Datatable. Loop thorugh all records and d...more >>

Hi Guys, Is there any way by that we can change default format of date. Thanks...more >>

My below code returns a union fine in northwind. However, I'd like add some FOR LOOP's while building the SELECT statements to cut down on the redundant code. As you can see, each @SQLx statement has a variable from 1 to 3. I created this exmple to get an idea of using a FOR LOOP to cut down o...more >>

Dear All I am getting this error during indexing on the table. What should i do to solve this problem Server: Msg 8946, Level 16, State 12, Line 2 Table error: Allocation page (1:48528) has invalid PFS_PAGE page header values. Type is 0. Check type, object ID and page ID on the page. Ser...more >>

Hi, My problem is as follows: I would like to take the average value of count column grouping by drive letter and date. Sample table DriveLetter Date Count K: 2005-07-05 06:00:00:000 33.555 K: 2005-07-05 06:30:00:000 35.555 K: 2005-07-05 07:00:00:000 48.555 K: 2005-07-05 07:3...more >>

Dear Friends can I write some functions in DLL and use it in msmsql as udf and in sql statements? how? any advice? Thanks Tarvirdi ...more >>

Dear All I have the following SP that creates a temp table T1: CREATE PROCEDURE CreateT1(@Crit varchar(1000)) AS Begin declare @SQL varchar(8000) Set @SQL=3D'SELECT ... INTO ##T1 FROM .... ' if @Crit<>'' SET @SQL=3D@SQL + ' WHERE (' + @Crit1 +')' ...more >>

Hello, I have had the below procedure working and in use for some time now, and suddently i started getting the below error: "Eorror 213: Insert Error: Column name or number of supplied values does not match table definition" Thank you CREATE PROCEDURE bat_LogData ( @ComputerName varchar...more >>

I need to use Group By on a text column that contain numeric data in different format. For example, column "terminalID" can contain "0123" and '123' pointing to the same terminal. Group by treats these as 2 different groups. I used CAST (terminalID as INT) as 'terminalID' in SELECT but sti...more >>

Using SQL Server 2000 Standard --- I need to update the value of a TEXT column. When it's NULL I get the following exception: [NULL textptr (text, ntext, or image pointer) passed to WriteText function.] Okay - good, so I look in BOL to find out what to do. Here's what it says in the ...more >>

Hi, When I use NET PAUSE in cmd mode, the service pauses successfully but when I issue NET START again, the service stays in pause state unless I use service manager to start it. Any help would be greatly appreciated, Leila ...more >>

Hi, I need Adventure Works Database (OLTP) for SQL Server 2000. Are there any links available to download it? Thanks in advance, Leila ...more >>

Greetings, I am having some trouble with a trigger. This is my first attempt at creating a trigger so any help would be great. The function of the trigger is, on the insert of a row to check the value inserted into to column VEH_REPAIR_CODE. If that value is not 19, send an email to the value i...more >>

Hi there, I would be really grateful with some assistance with this, i am 100% new to SQL & Stored Procedures. I'm building an ASP web application, i need to be able to update two fields in two related tables & could really do with some assistance. The tables are tbCompany and tbemployee. t...more >>

Hi, can anyone help me with the following xp_cmdshell/osql problem? To solve a problem with osql I use the two sql test-scripts. Script1 is loaded in Sql Query Analyzer. Executing scripts 1: this calls en execute script2, which prints a message to the output window. Quite simple. My proble...more >>