| Welcome, Guest |
You have to register before you can post on our site.
|
| Forum Statistics |
» Members: 192
» Latest member: St103966
» Forum threads: 14,195
» Forum posts: 223,535
Full Statistics
|
| Online Users |
There are currently 617 online users. » 0 Member(s) | 614 Guest(s) Applebot, Bing, Google
|
| Latest Threads |
My Stepfather Is Dead
Forum: General Chatter
Last Post: Labster
1 hour ago
» Replies: 2
» Views: 58
|
Political Images thread t...
Forum: Politics and Other Fun
Last Post: Norgarth
10 hours ago
» Replies: 229
» Views: 32,494
|
Image dump thread XXXII
Forum: General Chatter
Last Post: Norgarth
10 hours ago
» Replies: 65
» Views: 4,086
|
Politics of the Moon King...
Forum: My Apartment Manager is not an Isekai Character
Last Post: Labster
10 hours ago
» Replies: 26
» Views: 11,779
|
Fourth Oddities Spotted i...
Forum: General Chatter
Last Post: robkelk
Yesterday, 04:46 PM
» Replies: 53
» Views: 5,794
|
Fic Update Thread 63: Th...
Forum: Other People's Fanfiction
Last Post: Shepherd
Yesterday, 03:05 PM
» Replies: 131
» Views: 8,296
|
Completed Fanfiction Reco...
Forum: Other People's Fanfiction
Last Post: classicdrogn
08-12-2026, 09:03 PM
» Replies: 262
» Views: 232,531
|
All The Tropes Wiki Proje...
Forum: General Chatter
Last Post: Bob Schroeck
08-12-2026, 08:21 AM
» Replies: 99
» Views: 4,587
|
2016-10-22: Fuku'ing With...
Forum: Stories
Last Post: Bob Schroeck
08-12-2026, 08:16 AM
» Replies: 1
» Views: 889
|
Stupid dialog, free to a ...
Forum: Other People's Fanfiction
Last Post: classicdrogn
08-11-2026, 04:58 PM
» Replies: 224
» Views: 113,301
|
|
|
| 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.
|
|
|
| In honor of Saint Patrick's Day... |
|
Posted by: ECSNorway - 03-22-2010, 10:52 PM - Forum: The Game Everyone Loves To Play
- Replies (1)
|
 |
Up the Republic, they raise their battle cry,
Pearse and McDermott will pray for you on high,
Eager and ready, for love of you they die
Proud march the soldiers of the Rearguard.
(chorus) Legion of the Rearguard, answering Ireland's call,
Hark their martial tramp is heard from Cork to Donegal,
Wolfe Tone and Emmett guide you, though your task be hard,
De Valera leads you, soldiers of the Legion of the Rearguard. (/chorus)
Glorious the morning, through flame and shot and shell,
Now rally Ireland, your sons who love you well
Pledged, they'll defend you, through death or prison cell
Wait for the soldiers of the Rearguard.
Crimson the roadside, the prison wall, the cave,
Proof of their valour, go sleep in peace ye brave,
Comrade tread lightly, you're near a hero's grave,
Proud die the soldiers of the Rearguard.
--
Sucrose Octanitrate.
Proof positive that with sufficient motivation, you can make anything explode.
|
|
|
|