Evil Kraig F (2/15/2012)

---

SQLKnowItAll (2/15/2012)

---

I would actually structure the application to call separate stored procedures based on the parameters provided. This way you don't have this messy code; i.e....

Ok, try this! 🙂

USE tempdb

CREATE TABLE tableName

(Tif varchar (255),

Type varchar(255),

Code varchar(10),

RC int,

SEQ int,

Descript varchar(30))

go

INSERT INTO tableName (Tif, Type, Code, RC, SEQ, Descript)

Values ('00002667.TIF',102205,NULL,1,1,NULL)

INSERT INTO tableName (Tif, Type, Code, RC, SEQ,...

Ok, here's what I got so far:

USE tempdb

CREATE TABLE tableName

(Tif varchar (255),

Type varchar(255),

Code varchar(10),

RC int,

SEQ int,

Descript varchar(30))

go

INSERT INTO tableName (Tif, Type, Code, RC, SEQ, Descript)

Values ('00002667.TIF',102205,NULL,1,1,NULL)

INSERT INTO tableName (Tif, Type,...

Ok, I guess I was thinking whatever was writing this data should be inserting it with the correct values to begin with. Since it is a one time thing......

You don't have to drop the NCs to rebuild a CI.

R.P.Rozema (2/15/2012)

---

Similar to Paul's suggestion:

SELECT

ItemNum,

ROW_NUMBER() OVER(PARTITION BY Attribute1,Attribute2,Attribute3 ORDER BY (SELECT NULL)) as DupNR

FROM T1;

All rows having a value higher than 1 in...

Ok, I get it now. Can I ask why you are doing this in SQL? Is this a 1 time update? Are you getting data from a file, importing...

Jeff Moden (2/15/2012)

---

adeel.imtiaz (2/15/2012)

---

1. Query Monthly report (A1)[font="Arial Black"] with result in grid[/font], it will take 4minutes and 9 seconds.

2. Query Monthly report(A1)[font="Arial Black"]with result in text[/font], this time it...

Ok, great. So from this sample data, what is supposed to happen?

something like this (Not real SQL, just a kind of pseudocode)?

UPDATE tableName SET a.Code = b.Type WHERE b.lastRC...

Jeff Moden (2/15/2012)

---

ScottPletcher (2/15/2012)

---

I think the order does matter for the clus index and whether it gets fragmented or not. SQL is coded to recognize sequential inserts and not...

Try this link, http://social.msdn.microsoft.com/Forums/en-NZ/sqlsecurity/thread/9e6bb2de-8fd0-45de-ab02-d59bbe05f72e it does a better job at explaining it than I did. Sorry if I have confused you more.

sqlfriends (2/15/2012)

---

SQLKnowItAll (2/15/2012)

---

Let's try this explanation... When you use SQL Server Configuration Manager to change the logon for a service, it does not "add" that domain user to SQL Server....

I would actually structure the application to call separate stored procedures based on the parameters provided. This way you don't have this messy code; i.e. GetResumesByName, GetResumesByNameAndNumber, GetResumesByCity.

More code...

Your DDL should look like this:

CREATE TABLE tableName (Tif varchar (255)

Type varchar(255),

Code varchar(10),

RC int,

SEQ int,

Descript varchar(30))

Is this correct to make...

Let's try this explanation... When you use SQL Server Configuration Manager to change the logon for a service, it does not "add" that domain user to SQL Server. It adds...