I am trying to do bulk insert 5000 rows into a simple table that has: id pk identity, col_text nvarchar(500) How do i do bulk insert but to only insert data that is not duplicated eg. if i have already in table 'some_text' and bulk inserting 'some_text' that the text is not inserted and al...more >>

Hi all, How can I omit the redundance in the query bellow? --------------------------------------------------------------------------------- SELECT dbo.StockTbl.GoodSyscode, nassa_1.InvoiceDate AS LDate, nassa_1.LFee FROM dbo.StockTbl INNER JOIN dbo.nassa() ...more >>

I have a table that has a datetime field with values like 2006-12-16 01:44:07.787. I want to run a query that returns the date without the time (e.g. 2006-12-16). I would also like to know how to get back the date with a default time (e.g. 2006-12-16 00:00:00.000). How could I accomplish these t...more >>

I have two servers on my machine MDsync3 MDsync3\OFFICEMEDIC Select * from OfficeMedic.officeMedicData.patientInfo The statement above give me the correct Select Data. I'm trying to do a select statement from the MDsync3 instance I tried the following to create a linked server Execu...more >>

I would like to create t-sql statement from the Drives table listed below, if the Disk_Space_Low field is equal 1 then send alert message with Drives table data listed below. Please help me with this task. Table Drives Drive FreeSpace TotalSize Percentage Disk_Space_Low C 10000 19...more >>

Hello there I have some performance problem. therefore i've run the profiler for time to time on database which isn't activated i got two messages at all times: SELECT N'Testing Connection...' go EXECUTE msdb.dbo.sp_sqlagent_get_perf_counters go what is that means? ...more >>

Does Shrinking of a Log file when the DB is used by the users ..... cause a problem to the users in the availablity to the DB ... I mean lets says of the user issues a select query & I run the DBCC Shrink file ... would the user get an erorr or some message .... I mean would he have to wait ti...more >>

I need help on VB Script or better way, what i am trying to do. I have more than 75 TXT files & this all 75 TXT files consists & follows naming convention like AAAAANames.txt, BBBBBAddress.txt, CCCCCTellno.txt, DDDDDProduct.txt. I want to IMPORT DATA from this files to SQL Server 2000 Data...more >>

Hi,In SQL 2005, I'm doing a "select into" to create a table. In the original table, there are two fields that are being checked with the Replace function. When I execute the SQL below, the destination table creates fields of Varchar(8000) for any field which uses the replace function. Has any...more >>

Suppose I have the following data: student quarter grade ------- ------- ----- Jones 1 A Jones 2 B+ Jones 3 A Jones 4 B- Smith 1 B+ Smith 2 B Smith 3 B Smith ...more >>

Hello there I've create function that should return more then one value. there fore i used function that returns table. When i placed the function in a form close with another table that one of the fields in the table is the function parameter i got this error: Server: Msg 155, Level 15...more >>

How is it possible to select rows where the content of a column has an uppercase character? I have a table with a single column and three rows. The column content of one of the rows has an uppercase character that I want to convert to lowercase....more >>

Hello there One of the users has run query that delete some records in one of the tables. Is there a way to know how many records has been deleted? ...more >>

Hi Folks, What is the command (sp) to show the table definition. something like this structure: table_MyTable MyName (varchar(30)) MyID (INT) THANKS ...more >>

Hi all, The following code is a simplified subset of an operation I'm working on. The SELECT statement puts out incorrect data. I need to modify this query to return : PartNumber Customer -------------------------------------- B 2 D 4 ...more >>

Given the below tables (simplified for example), what would be the best way to remove the ambiguous foreign key relationships from dataSecurity? This structure saves space since the security descriptor is the same for all data items, but since the data_id can refer to an item in a number of ...more >>

I have two tables ARSIA and ARSIAO. The simplified tables are shown here. ARSIA: GROUPID IDCUST AMTDUE RENT 340943 120 PARKING 340943 30 RENT 450001 175 RENT 841190 290 PARKING 841190 40 RENT 950100 500 ARSIAO GROUPID IDCUST O...more >>

Hi, I have the following Tables: Table: MachineModels PK PK version color comments 1.01 brown -- 1.34 brown -- 1.34 black Table: Machines PK ID model 1 2 3 I would like to somehow define a relationship bet...more >>

I am trying to create a job in ssis for a package I created. I able to execute the package, but get the following error when I run the job [298] SQLServer Error: 22046, Encryption error using CryptProtectData. [SQLSTATE 42000] Anybody have any idea how to get around this? ...more >>