| Welcome, Guest |
You have to register before you can post on our site.
|
| Forum Statistics |
» Members: 190
» Latest member: Lil Wiz
» Forum threads: 14,156
» Forum posts: 221,876
Full Statistics
|
| Online Users |
There are currently 1327 online users. » 0 Member(s) | 1322 Guest(s) Applebot, Baidu, Bing, Google, Yandex
|
| Latest Threads |
Thread of Awesome: THIS! ...
Forum: Other People's Fanfiction
Last Post: Shepherd
2 hours ago
» Replies: 272
» Views: 189,853
|
Fic Updates 61: LuXurIous...
Forum: Other People's Fanfiction
Last Post: Shepherd
2 hours ago
» Replies: 273
» Views: 15,661
|
Video Madness XII
Forum: General Chatter
Last Post: classicdrogn
Yesterday, 05:32 PM
» Replies: 116
» Views: 15,201
|
Meanwhile, in Canada...
Forum: Politics and Other Fun
Last Post: robkelk
Yesterday, 02:37 PM
» Replies: 35
» Views: 4,626
|
The Imperial Presidency, ...
Forum: Politics and Other Fun
Last Post: robkelk
Yesterday, 02:33 PM
» Replies: 162
» Views: 16,250
|
Weird & Interesting scien...
Forum: General Chatter
Last Post: classicdrogn
Yesterday, 12:29 PM
» Replies: 256
» Views: 74,529
|
Dearly Departed of 2026
Forum: General Chatter
Last Post: robkelk
Yesterday, 09:06 AM
» Replies: 36
» Views: 1,779
|
Ya wanna buy a Bunny?
Forum: The Game Everyone Loves To Play
Last Post: classicdrogn
04-03-2026, 10:09 PM
» Replies: 9
» Views: 5,801
|
Crossovers That Should No...
Forum: Other People's Fanfiction
Last Post: classicdrogn
04-03-2026, 07:27 PM
» Replies: 300
» Views: 60,149
|
The Dead Dove Locker -- "...
Forum: Other People's Fanfiction
Last Post: Mamorien
04-03-2026, 04:19 PM
» Replies: 99
» Views: 18,063
|
|
|
| Okay, brain-picking time. |
|
Posted by: Bob Schroeck - 03-25-2010, 05:39 AM - Forum: General Chatter
- Replies (6)
|
 |
I'm cramming for the coding test part of my second interview with the local company. The fellow knows I'm lacking in SQL Server, and he's told me he's looking for more than just coding skill for his hire, but I want to ace this. The actual test as described is pretty simple, even for someone like me who hasn't worked in SQL Server before. But I've been having one persistent problem, and I can't figure out what I'm doing wrong. I'm hoping someone here with SQL Server experience can tell me what it is, and how to correct it.
Setup is this: I've using Microsoft SQL Server Management Studio 2008 Express Edition to set up a stored procedure for a little table -- a simulated customer base with 10 records -- that I created to run a query against. Simple procedure, runs this query with the appropriate parameters:
SELECT firstname, lastname, customernumber, customersince
from dbo.dummydatabase
where customersince between @customerstart and @customerend;
"customersince" is a datetime field, and customerstart/customerend are datetime params. I created the stored procedure with the context menu "New Stored Procedure" option. The little table lives in master and as you can see from the query is called "dbo.dummydatabase". The stored procedure is in master's Stored Procedures under Programmability, and itself is called "dbo.customer_age".
The problem is that when I try to run it from an ASP.NET page I've set up in Visual Web Developer 2008 Express Edition, I get a "procedure not found" error. I also get the same error inside SQL Server Management Studio from the dynamic syntax-checking system, but I can still run the procedure via a separate query despite this. Obviously I did something wrong, but damned if I know what. Can anyone help?
Thank you.
(Edit: Corrected vague/incomplete terminology.)
-- Bob
---------
Then the horns kicked in...
...and my shoes began to squeak.
|
|
|
|