Hi, I noticed that if I do insert into table (num, name) values ('1', 'john') the result is the same as (1,'name') where num is int field and name is varchar(50) So does sql server convert string value to number if it can? And last question, how with datetime field, how to set default valu...more >>

I know there's someone who knows the answer to this question, but I can't seem to figure it out - forgive me! I want to query SQL Server and set up a query so that yesterday is always returned. SELECT AL1.TDate, SUM ( AL1.NBR ) FROM dbo.Table AL1 WHERE AL1.TDate = _____________? How do ...more >>

Hi every one, Is there a way to search for a particular character in the TEXT data type of SQL 2005. I have tried CHARINDEX() function but it was said this function doesn't work for TEXT or NTEXT data types. The data I have in the TEXT field I'm searching for is really huge. Thanks in advan...more >>

Hello - I am getting a message to the effect that my evaluation copy of Sql Server 2005 has expired. A few months ago (probably more than 180 days), I installed an evaluation Enterprise Edition copy that came with Microsoft's book. I have a real registered copy of the Standard Edition i...more >>

Is it possible to query Jobs for Step Number and Step Name? tia Bob....more >>

Hello everyone, i have a quite large application that has shown some problems when dealing with Unicode chars. I have learnt (as I didn't know) that I should always use the N operator before strings in order to use the Unicode characters in INSERTs, UPDATEs and SELECTs. Like: INSERT I...more >>

Hello, What is a sequential Guid in SQL 2005. I am using the following code to create a table: -- Users ... create table dbo.Users ( UserID uniqueidentifier not null constraint PK_User primary key clustered, [Name] nvarchar(200) not null, Email nvarchar(200) null, UpdatedDate d...more >>

Hi, Current SQL Server 2000 database is going to stop getting its feed from an earlier Java web based application and will instead information from Oracle HRMS. In the old database EU, there is a field called LawsonID, ADUserName In the new databaseEUHRMS, there is a field called LegacyID...more >>

Hi! I have sql 2000 and sql2005 in 2 diff boxes. I want to compare 2 temp tables created in each of them. I tried the following: select * from server1.dbname1.dbo.temp_table1 where hashcode not in (select hashcode from server2.dbname2.dbo.temp_table2) I am getting the error M...more >>

I'm trying to match contacts and accounts in SQL for an import in CRM 3.0 but I keep running into msg 512 errors. I have placed a new column on both the accountbase and contactbase tables that have the address line 1 that I was going to use to match the contacts and accounts. Here is an example ...more >>

How would I find the most commonly occurring value in an integer column? ...more >>

Hello, I am trying to follow the "Project Server 2007 Report Pack" demo. In the project data source.rds. In the project properties. there is a target server URL. with http://epm2007demo:90/reportserver I am guessing I change this to <my server>reportserver? Do I have to create a new web site ...more >>

Hello! Here is the statement in question: --STATEMENT A SELECT * FROM dbo.myTable WHERE colX in (SELECT colX FROM dbo.sourceTable) The problem with Statement A is that 'colX' does not exist in 'dbo.sourceTable'. It does, however, certainly exist in 'dbo.myTable'. Breaking the sta...more >>

Hi, I have been struggling for a couple of days to write the correct SQL 2005 query to find the bearing (based on 360 degrees, 0-N,90-E,180-S, 270-W) between two points given as Lat1 Lon1 to Lat2 Lon2. Below is the Excel formula. =(MOD(ATAN2(COS((LAT1*PI()/180))*SIN((LAT2*PI()/180))-SIN...more >>

I am currently using SQL Server Management Studio Express and want to schedule a job. Is this possible? Thanks....more >>

Hi, I have a table with a recursive relationship: Sections ======= id - primary key parentID - Foreign key name A section can be a parent to another section. What I need to do is return a recordset containing all the descendant sections of a given section. Is there a way to do this...more >>

This is a simplifed query but the one I actually need to incorporate contains multiple subqueries which I then reference in my select statement. How do I acheive this as the following produces an error. select sub1.company_name from OPENQUERY ( LinkedServer, '(SELECT TOP 1 * FROM ...more >>

I have two tables (that are related) in a database where the isolation level is READ COMMITTED SNAPSHOT. As I understand it the SNAPSHOT isolation level does row versioning and when a row is finally updated it updates that row successfully provided no other transaction has modified that row in...more >>

I've added an INSERT trigger (to send an email) and am having problems with other triggers. My sense is that if we moved the trigger to run after all other triggers, we wouldn't have this issue. How can I move the trigger to run after all other triggers have run? Thanks. G...more >>

I created a stored proc to send mail. The mail content is a NVARCHAR(2000) data type variable. The value is build based on certain criteria I would like to leave some lines for my mail content (for readability purpose) using the SET statement. How could I do that? Thanks! -- Regards, ...more >>

Hi all, I have a question reguarding if type casting is now transparent in MS SQL 2005 when inserting data. Below I describe the scenario at hand. ** 1. Consider the following two tables CREATE TABLE [dbo].[test_varchar]( [name] [varchar](50) NULL, [age] [varchar](50) NULL, [numbe...more >>

Hi, (Using Visual Studio 2005 and Sql server 2005.) I have a sql server employee table with a uniqueidentifier (rowguidcol) as PK. The default value for this column is (newid()). Here's the create table script (not all fields included): CREATE TABLE [dbo].[Employee] ([EmployeeId] [uniqueid...more >>

I did a thread search, and while there are many threads that have these words, they didn't seem to address my question. Basically, I have data coming in from an instrument in 4 columns; a timestamp, a group, a tag and a value. (I'll post the DDL at the end) I want to create a procedure that...more >>

I need to do an UPDATE on two very large tables, 20+ million rows. I need to check the tables to see if any old values exist, then update the table. I'm using normal READ COMMITTED isolation with TABLOCKX, to avoid lock escalation, but, can anyone see any problems with this: IF EXISTS ( ...more >>

Hi, Is there a way to list all computed columns from a specified table by use of Information_schema and not syscolumns? Many Thanks, Jaco...more >>

I'm having some puzzling performance problems. Any help would be gratefully received. I have a SQL 2000 database and a set of stored procedures, tables and user-defined functions which "do some calculations". I've been careful to make these entirely set-based, avoiding cursors. The calculation...more >>

Hi, Not sure I'm posting in the correct group. My apologies if not. I'm facing a problem when some users are uploading data to our SQL 2005 database. A sp is creating a temp table. Data (a flat file) is just bulk loaded into that temp table. An update is then performed by executing an upda...more >>

Is it possible to pull the data from Lotus Notes to SQL Server 2000/05. And if yes then how? Thnx in advance Amit Arora ...more >>

I need to change a text column to varchar 8000. I don't mind truncating the text where necessary. My attempt failed as below. Can anyone suggest a solution? Thanks Soc. SET ANSI_WARNINGS OFF update story set s_body=short_body SET ANSI_WARNINGS ON Server: Msg 511, Level 16, State 1, L...more >>

If I'm not mistaken, there's a function in T-SQL to generate blank spaces. What is that function and how to use already? Thanks... -- Regards, Pedestrian, Penang. Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-programming/200710/1 ...more >>

hello, i ve a big sql request and from it i need TO count the rows and do a pagening. so, count the row, no problem. pagening, no problem. but do both... in one procedure ... ! (???) //Simulation : 1) @cursor = select * from table 2) SET @nbr = @@rowcount 3) select top(20) from @cursor...more >>

Hi I am getting following error, during login with sql server authentication. (SQL Server 2005) Lastly i have window authentication, Now I have change it with mixed server auth. Login failed for user 'mylogin'. The user is not associated with a trusted SQL Server connection.(Microsoft Sql Se...more >>