Viewing 15 posts - 286 through 300 (of 583 total)
Thought I would try it in the query window first to see if this approach will work. The only way I can work with it in the query window is...
July 24, 2005 at 2:54 pm
Finally got this one working, use Parameter0 and Parameter1 in the statement instead of the "?".
July 24, 2005 at 1:31 pm
I have another idea to try, throw the XML into an XML field and query it in an execute SQL task. Wish I had thought of this sooner. I'll post...
July 24, 2005 at 1:24 pm
I installed the April CTP Hands On Labs VPC from the DVD and have it working with one parameter.
I have submitted a bug report about the June CTP. In the...
July 23, 2005 at 10:40 am
DBO is a database user. There are no special rights on the server and it isn't a login. There is also a role called db_owner that DBO is a member...
July 18, 2005 at 12:28 pm
The key to Remi's query is the "Left Outer Join". This causes all rows to be returned even if there is no matching row in resumes. Actually, the query you...
July 3, 2005 at 10:38 pm
Once you have created a proper stored procedure, you can run it several ways. Here are a few of the most common:
1. In Query Analyzer, type in the name of...
July 2, 2005 at 6:07 am
Remove result_by from your group by and order by clauses.
July 2, 2005 at 5:56 am
Here is a link that talks about the error: http://support.microsoft.com/default.aspx?scid=kb;en-us;218172 and the workaround.
Hope this helps,
Kathi
July 1, 2005 at 7:35 pm
Your program (webpage, Visual Basic or whatever) should prompt the user. Then your program will call the stored procedure with the the 4 letters as a parameter.
So you could...
June 25, 2005 at 3:41 pm
When I took this job I was told I would be able to telecommute a few days each month. Well, they say to get everything in writing... Actually, I do...
June 21, 2005 at 6:34 am
Not sure. It looks like the lookup query is part of a Transform Data task. I haven't used that to delete rows, just append rows.
June 20, 2005 at 12:52 pm
SQL Server is an enterprise database management system. Access is meant more for just a few users. Some say it is only meant for one user at a time. The...
June 18, 2005 at 8:09 pm
You can do point in time restores with LiteSpeed.
The article was meant to show how to do point in time recoveries with native SQL commands, not to actually discuss third-party backup...
June 14, 2005 at 6:18 pm
Viewing 15 posts - 286 through 300 (of 583 total)