Forum Replies Created
Viewing 15 posts - 976 through 990 (of 1,183 total)
-
RE: invalid object
Does the user that you're logged in as have permissions to that object?
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: Dynamic File name creation in subscription
This doesn't address the filename, but you don't need the Enterprise version...
http://www.sqlservercentral.com/columnists/jselburg/2824.asp
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: popoulating multiple values to a single column in multiple rows
Can you post sample data and table definitions along with an example of what you are trying to do?
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: SQL Logic
If you post the Create scripts and some sample data along with what you expect, I'm sure someone on this site could help you a bit more.
It's rather difficult to...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: SQL Logic
Sorry, but your question is extremely vague. Can you post the create scripts for the "table #1" and more detail on what you want the output to look like.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: Do i need to ViewReport control for each report?
No, you can just place one report viewer control on your page, and then through code apply the settings depending on which report you want to run.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: Updating a production database with back up of development database
Red Gate SQL Compare works wonders!
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: Junior
I think this question and it’s answers bring up a missing job-title “DBevloper”, or the lack of true definition in job roles.
There is definitely a...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: Joins in SQL Server
-- EDIT -- sorry, I posted to the wrong question and removed it
--______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: SQL Xtended Stored Procedure Test
I have NO experience with extended stored procedures, but my first thought is ...
Change:
set @FileExists = 'xp_fileexist '''+@PathFileName+''''
To:
set @FileExists = 'master..xp_fileexist '''+@PathFileName+''''
AGAIN, JUST MY 1.5 cents!
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: Indexes - The water is gett''''n muddy
ANSWER: Nope, you don't get the job!
REASON: Not enough Posts on this site! [Smile]
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: SQL Update Query
The solutions you guys posted update the ORDER's table from the ORDERDETAILS.
What Mark was doing is the opposite, updateing the ORDER DETAILS table from the ORDER's table. this is why...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: SQL Update Query
Sergiy,
Isn't this backwards from what Mark is doing or am I looking at it wrong?
Using your example, He's updating the OrderDetails table from the Orders table. I understand this is...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: What is the datatype?
Longshanks,
We had a similar issue with a site we just built. Our date (when NULL) was changed to ‘1/1/1900’, then in the PreRender of the GRID caught...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: question on joins...
OK, I now have egg on my face! 🙁 I was making an assumption, and we all know what that does.
I should have tested this before opening my...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg
Viewing 15 posts - 976 through 990 (of 1,183 total)