Viewing 15 posts - 2,551 through 2,565 (of 3,221 total)
Whoops did not realize this was SQL 2000 - sorry Thanks Sergiy
Have you looked at ROW_NUMBER (Transact-SQL) in BOL? It is very useful and quite fast for...
April 21, 2009 at 4:32 pm
yulichka
SELECT COUNT(*) AS 'Staff Count'
FROM #Table GROUP BY DATEPART(m, SignIn),DATEPART(d, SignIn),DATEPART(yy, SignIn),DATEPART(hh, SignIn)
for your use just substitute the fully qualified table name as your schema name your tables name...
April 21, 2009 at 3:51 pm
John_Chrome
but the data to be validated is such that it isnt just nulls to be checked a lot more needs to be checked
and
check for valid data in the table...
April 21, 2009 at 3:32 pm
Using T-SQL and a temporary table for illustration
CREATE TABLE #Table
(SignIn DATETIME)
INSERT INTO #Table
SELECT '4/6/2009 6:10:17 AM' UNION ALL
SELECT '4/6/2009 6:10:51 AM' UNION ALL
SELECT '4/6/2009 6:11:22 AM' UNION ALL
SELECT...
April 21, 2009 at 9:10 am
john_chrome
Step 1. Import all the data without any additional processing this is what I imitated in creating the temporary table #Table1.
Step 2. Identify all rows in #Table1 that...
April 20, 2009 at 3:19 pm
Assuming I read your post correctly and more importantly what the Cursor was utilized for, you might want to try the following to eliminate the Row by Row cursor processing
CREATE...
April 19, 2009 at 6:23 pm
From Dataphor SQL RAC
Dataphor - Sql: what does Update..From mean?
What is really wrong with the "UPDATE.. FROM.." syntax?
This example uses MS Sql Server 2005
and
the D4 language of...
April 19, 2009 at 2:00 pm
Paul White
The answer is..."it depends!"
Sometimes, a cursor *is* the optimal solution. Not often, but it does happen.
Paul care to post some code that shows an example of where a cursor...
April 19, 2009 at 9:45 am
I highly recommend an article by Jeff Moden
http://www.sqlservercentral.com/articles/TSQL/62867/
If you really want to get into the depths of replacing a cursor follow this forum here on SSC
http://www.sqlservercentral.com/Forums/Topic695508-338-1.aspx
April 19, 2009 at 6:52 am
In the msdb database check the following stored procedure:
sp_sqlagent_log_jobhistory - I believe it is what you are looking for. It is a long proc so read it all.
April 16, 2009 at 8:20 am
I am going to guess the answer is Yes. But with the data you have given, it is difficult if not impossible to assist you. Please read the...
April 13, 2009 at 8:10 pm
Are you sure you are passing in a value - paraphrasing your procedure
CREATE PROC dbo.myproc
@Exists INT
AS
IF @EXISTS = 1
BEGIN
PRINT 'UPDATE METHOD HERE'
END
IF @EXISTS =0
BEGIN
PRINT 'INSERT METHOD HERE'
END
dbo.myproc NULL -- imitating...
April 7, 2009 at 3:24 pm
Suggest that you view this School Video by Randy Warren
http://www.sqlservercentral.com/articles/Video/65076/. It appears to fit perfectly as a answer to your problem
April 7, 2009 at 9:12 am
I know that this will not be the real answer to your final deployment on a hosted server, but have you examined the availability of SQL Server 2008 DEVELOPER EDITION....
April 5, 2009 at 8:51 am
Viewing 15 posts - 2,551 through 2,565 (of 3,221 total)