Viewing 15 posts - 421 through 435 (of 789 total)
Stanley Pagenel (2/28/2009)
Thanks Dugi that help me fix my problem.Have a nice day,
Stan
You are welcome, the credits goes to Kamran Ali!
😎
March 1, 2009 at 11:49 pm
hmmm take a look around some info from here:
http://www.sqlservercentral.com/articles/SQL+Puzzles/eliminatingcursors/2223/%5B/url%5D
:hehe:
February 27, 2009 at 7:40 am
Yea nice question ... also i point for the experience!
😎
February 26, 2009 at 6:29 am
Plz, don't do double posts! All reply should be here
February 20, 2009 at 12:30 am
Plz, don't do double posts! All reply should be here
February 20, 2009 at 12:30 am
sql (2/8/2009)
ok, i fixed it, i was inserting the wrong value. the code was fine, the operator was all jacked up
hehehe you are here sql:
BEGIN problem
....
....
....
COMMIT solution! - sql's position
:hehe::hehe::hehe:...
February 18, 2009 at 1:20 am
Be more specific about your problem ...!? What is that you cannot find with percentage!?
February 13, 2009 at 5:06 am
seem easy or maybe I don't understand very well your question here:
there is one of the solution:
CREATE TABLE TTT
(
ID INT IDENTITY (1,1) NOT NULL,
CHARS varchar(100)
)
INSERT INTO TTT
SELECT 'a;b;cde;f;ghi;d' UNION ALL
SELECT...
February 13, 2009 at 3:41 am
Do you want to generate the ID numbers from 1 to .... in order or you have other values that you should find the MAX value then the new record...
February 13, 2009 at 2:16 am
ayi_102 (2/4/2009)
i am doing my database project using SQL Server 2005
but i made a mistake since i dont use primary key
this is the problem
ID Name...
February 9, 2009 at 5:38 am
jchallett (1/30/2009)
Thanks for the tip!😉
...and final decision is !?
1) form SQL 7 >>> SQL 2000 >>>> SQL 2008
2) from SQL 7 >>>> SQL 2005 >>> SQL 2008
..and the winner...
January 30, 2009 at 6:03 am
Chris Morris (1/30/2009)
DROP TABLE #Temp
CREATE TABLE #Temp (Users VARCHAR(10), [DateTime] DATETIME, Sections VARCHAR(1), Title VARCHAR(1))
INSERT INTO #Temp (Users, [DateTime], Sections, Title)
SELECT 'Client1', '2009-01-30 08:00 AM', 'I', 'A' UNION...
January 30, 2009 at 5:16 am
Just to be sure that this code above is just to find you solution here, as you can see I didn't count nothing just generating the number in order by...
January 30, 2009 at 4:40 am
this is the little code and the situation like yours I didn't have yet and sure that the others can have better idea how to do that but try and...
January 30, 2009 at 3:55 am
Hari.Sharma (1/30/2009)
Keep Smiling...
Anyway, This should work:
EXEC sp_depends @objname = N'TableName'
Now is Ok! :w00t: thnx for the sp info!
January 30, 2009 at 3:21 am
Viewing 15 posts - 421 through 435 (of 789 total)