Viewing 15 posts - 1,636 through 1,650 (of 2,038 total)
If you are using SQL Server 2005/2008 you should have a look for "CREATE SYNONYM".
Greets
Flo
April 1, 2009 at 4:31 am
Hi
First the answer; yes you can specify the seed within the table creation:
DECLARE @t TABLE (id INT IDENTITY(50, 1), txt VARCHAR(100))
INSERT INTO @t
...
April 1, 2009 at 2:22 am
Hi
Answer to your question:
;WITH t (id, addr) AS
(
SELECT 1, '1_94 SO MATTA REDDY RAJIV CHOWK SAGAR ROAD MIRYALAGUDA'
UNION...
April 1, 2009 at 1:58 am
Hi
Have a look to this article for a fast way to split strings:
http://www.sqlservercentral.com/articles/TSQL/62867/
Greets
Flo
April 1, 2009 at 12:26 am
RBarryYoung (4/1/2009)
As of SQL Server 2005 and later, the only time that you should use Cursors is when you actually want a procedure to run slower.
Hi Barry!
"Run slower" sounds so...
April 1, 2009 at 12:13 am
pandeharsh (3/31/2009)
I want know,when exactly to use cursor,if possible with an example.
Generally,SQL Server cursors can result in some performance degradation in comparison with select statements.
So we should not use...
April 1, 2009 at 12:10 am
Hi Greg
You have to use the SCOPE_IDENTITY() function to get the currently inserted/created CustID. Then you can insert the data into your DID table.
USE tempdb
GO
IF (OBJECT_ID('Did') IS NOT NULL)
...
March 31, 2009 at 11:55 pm
Bob Hovious (3/31/2009)
March 31, 2009 at 11:17 pm
Service pack 1. I removed one unnecessary aggregated sub select to improve the performance:
SELECT m1.acc_no, m1.PatientName, m1.AcLvl, m1.CaseMix, m1.EndDate, m1.RmBed, m1.Shift, m1.BegSta, m1.EndSta, m2.Start_DTime, m2.End_DTime
FROM @mytab m1
...
March 31, 2009 at 11:15 pm
Dang! Sorry... I shouldn't try blind typing...
Thanks for correction Lynn!
Greets
Flo
March 31, 2009 at 2:32 pm
Hi
If your criterion shall be used for the join you have to put it there:
SELECT *
FROM Table1 LEFT OUTER JOIN Table2
ON Table1.GroupID = Table2.GroupID Table2.ProfileID = 'A'
Greets
Flo
March 31, 2009 at 2:08 pm
So there seems to be no beautiful solution on SQL Server 2000 - as I think...
DECLARE @mytab TABLE
(
acc_no VARCHAR(100),
PatientName VARCHAR(100),
AcLvl VARCHAR(100),
...
March 31, 2009 at 2:04 pm
Hi
Maybe this thread is alike your request:
http://www.sqlservercentral.com/Forums/Topic685851-338-1.aspx
Greets
Flo
March 31, 2009 at 1:40 pm
Viewing 15 posts - 1,636 through 1,650 (of 2,038 total)