Viewing 15 posts - 19,906 through 19,920 (of 26,484 total)
Probably not without some convoluted dynamic sql since it looks like you want to exec the query stored in the table as part of selecting data from the table.
July 7, 2009 at 2:04 pm
How big are some of the tables? If you are doing a full scan, it could take awhile on fairly large tables.
July 7, 2009 at 12:56 pm
Sounds like an audit table is needed to capture this info for future analysis. What you are looking for you can find in Books Online, the SQL Servr Help...
July 7, 2009 at 12:53 pm
mpv (7/7/2009)
I don't see what you did, other than adding code to create the tables with data. I assume you are implying that I need to do this whenever I...
July 7, 2009 at 12:47 pm
ramdas.narayanan (7/7/2009)
In the result Ram has one class in feb as per the data...
SELECT teacher,
Jan=SUM(CASE WHEN DATEPART(m,Date)=1 THEN 1 ELSE 0 END),
Feb=SUM(CASE WHEN DATEPART(m,Date)=2 THEN 1 ELSE...
July 7, 2009 at 12:43 pm
I agree with Wayne on both points. I have the same article referenced below in my signature block as well. It is the first one regarding asking for assistance.
July 7, 2009 at 12:35 pm
First question I'd ask is what is the error message? Can't diagnosis a problem from this "returned an error message".
One possiblity, highly fragmented disk and the SQL Server couldn't...
July 7, 2009 at 12:32 pm
How many tables in the database? I have a database with over 50,000 tables and the update stats takes awhile even though many of the tables are empty.
July 7, 2009 at 12:29 pm
I missed too! I knew the correct answer, if I had noticed it was using table variables. Missed that, choose the wrong answer.
July 7, 2009 at 12:23 pm
Perfect, just what I wanted to see. thank you for posting your final code as well for others to view.
July 7, 2009 at 12:07 pm
Upper case reminds me too much of COBOL, plus I don't like having to hold the shift key while typing or using the caps lock.
July 7, 2009 at 12:03 pm
Natural Keys vs Surrogate Keys
Here's a battle. I like the idea of using Natural Keys, but sometimes thoses are the best choice as they can change which affects historical...
July 7, 2009 at 12:00 pm
sqlguru (7/7/2009)
Lynn Pettis (7/7/2009)
This is called the Network Model (CODASYL).
Actually, it's not.
The DB automatically creates the foreign keys between the two tables BUT it is not seen by the...
July 7, 2009 at 9:30 am
I like it because you get in and get out as quickly as possible.
July 7, 2009 at 9:26 am
jordon.shaw (7/7/2009)
It is SQL 2005 and I haven't written anything yet.
Okay, but what edition?
July 7, 2009 at 9:23 am
Viewing 15 posts - 19,906 through 19,920 (of 26,484 total)