Viewing 15 posts - 1,471 through 1,485 (of 2,007 total)
Performace Guard (Shehap) (10/12/2011)
SELECT *...
October 12, 2011 at 10:08 am
Teemo (10/12/2011)
i noticed you guys used a different condition statement by using BETWEEN condition and >= <Is there a difference in performance? given the table has the right indexes.
Best...
October 12, 2011 at 3:14 am
engrshafiq4 (10/12/2011)
I have two tables one having company data named COMPANY and other have Landmarks data named LANDMARK.
COMPANY have two fields(name and keywords) and LANDMARK (area,landmarkName)
i want to...
October 12, 2011 at 2:52 am
raphael.kong (10/10/2011)
What I dont understand is why when I write the sql insert from the sql management studio, the trigger runs properly, with every data as...
October 10, 2011 at 9:54 am
I'm guessing here, so you may want to wait for someone with more knowledge on the subject, but I think that what you're describing would use a BULK INSERT instead...
October 10, 2011 at 9:40 am
Jeff Moden (10/10/2011)
Cadavre (10/10/2011)
Rakesh.Chaudhary (10/10/2011)
just for faste performance and for learning purposes
Well, golly gosh! It seems that after you went to all the trouble of reading the link in my...
October 10, 2011 at 5:19 am
Rakesh.Chaudhary (10/10/2011)
just for faste performance and for learning purposes
Well, golly gosh! It seems that after you went to all the trouble of reading the link in my previous post, your...
October 10, 2011 at 4:46 am
sanujss (10/9/2011)
UserId int,
UserName varchar(50),
Password varchar(20),
ValidUpto datetime
This contains approx 50K records. Earlier there was no...
October 10, 2011 at 4:15 am
Rakesh.Chaudhary (10/10/2011)
I want to use while loop for this..............DECLARE Total_salary CURSOR
FOR
SELECT
e.Emp_Id,FirstName,(Basic+HRA+Allowance)AS Total_Salary
from Salary Inner Join Emp_Detail e
on e.Emp_ID=Salary.Emp_Id
OPEN Total_salary
FETCH NEXT FROM Total_salary
WHILE @@FETCH_STATUS=0
BEGIN
FETCH NEXT FROM Total_salary
END
CLOSE Total_salary
DEALLOCATE Total_salary
--EDIT--
After you've thought...
October 10, 2011 at 3:28 am
I've had to make some assumptions due to your lack of DDL in a readily consumable script.
--First, lets create some sample data to play with
IF object_id('tempdb..#OrderItem') IS NOT NULL
BEGIN
DROP TABLE...
October 10, 2011 at 2:24 am
Create a flat file connection with a "fixed width", then specify each column by width. This allows you to mark out where each column is in the file.
October 7, 2011 at 8:28 am
Hello and welcome to SSC!
Well, golly gosh! It seems that not only has your DDL script become detached from your post but also your actual question is missing!!
So, to...
October 7, 2011 at 4:23 am
Michael Valentine Jones (9/30/2011)
No it wouldn't. You could have tested that before you posted. 😉
Yep, or I should've just read the query properly! Didn't see the part of...
September 30, 2011 at 1:02 pm
Michael Valentine Jones (9/30/2011)
select
a.dt,
IsValidDateTime =
case
-- Check that date string is in correct format, mm/dd/yyyy hh:mm:ss
when dt not...
September 30, 2011 at 11:02 am
Carriage returns version: -
DECLARE @MySample AS TABLE (Id Int, Field varchar(50), Contents varchar(500))
INSERT INTO @MySample VALUES (1, 'OS Name','Windows')
INSERT INTO @MySample VALUES (2, 'Processors','Processor1')
INSERT INTO @MySample VALUES (3, 'Processors','Processor2')
INSERT INTO...
September 30, 2011 at 10:13 am
Viewing 15 posts - 1,471 through 1,485 (of 2,007 total)