Viewing 15 posts - 1 through 15 (of 56 total)
james.of.rivendell (6/19/2013)
--------
For SQL Tips, check out my blog: http://lantztechknowledge.blogspot.com/[/url]
You can also follow my twitter account to get daily updates: @BLantz2455
June 19, 2013 at 6:32 pm
Thanks for all the feedback. I definitely didn't consider the different date formats and how it would change depending on the language.
Besides the date formats, is there any other...
--------
For SQL Tips, check out my blog: http://lantztechknowledge.blogspot.com/[/url]
You can also follow my twitter account to get daily updates: @BLantz2455
June 19, 2013 at 2:25 pm
Is it possible the stored procedure is sending more than one report? Could you send us a code snippet?
--------
For SQL Tips, check out my blog: http://lantztechknowledge.blogspot.com/[/url]
You can also follow my twitter account to get daily updates: @BLantz2455
June 10, 2013 at 10:52 pm
I added a couple more accounts and more test data to make sure my query was complete. This is what I've come up with. Since you only need...
--------
For SQL Tips, check out my blog: http://lantztechknowledge.blogspot.com/[/url]
You can also follow my twitter account to get daily updates: @BLantz2455
June 10, 2013 at 3:56 pm
tshad (6/7/2013)
Not sure why, this doesn't work:
SELECT CASE WHEN TypeId = 8
THEN ISNULL(( SELECT...
--------
For SQL Tips, check out my blog: http://lantztechknowledge.blogspot.com/[/url]
You can also follow my twitter account to get daily updates: @BLantz2455
June 10, 2013 at 2:48 pm
Can you provide sample data for both tables? This will help while creating a query.
--------
For SQL Tips, check out my blog: http://lantztechknowledge.blogspot.com/[/url]
You can also follow my twitter account to get daily updates: @BLantz2455
June 10, 2013 at 2:39 pm
Please visit the following link to see how to best provide data for your questions:
http://qa.sqlservercentral.com/articles/Best+Practices/61537/
--------
For SQL Tips, check out my blog: http://lantztechknowledge.blogspot.com/[/url]
You can also follow my twitter account to get daily updates: @BLantz2455
May 21, 2013 at 2:05 pm
It just so happens that I tried the same thing you are yesterday. You cannot refer to a variable when using an IN query. The variable needs to...
--------
For SQL Tips, check out my blog: http://lantztechknowledge.blogspot.com/[/url]
You can also follow my twitter account to get daily updates: @BLantz2455
May 21, 2013 at 2:02 pm
Does your Report Server have access to the database in the data connection of DataSet1?
--------
For SQL Tips, check out my blog: http://lantztechknowledge.blogspot.com/[/url]
You can also follow my twitter account to get daily updates: @BLantz2455
May 21, 2013 at 1:53 pm
Thanks for all the tips. This is my first attempt at a Question of the Day, so I will definitely take all your suggestions into account (including pointing to 2012...
--------
For SQL Tips, check out my blog: http://lantztechknowledge.blogspot.com/[/url]
You can also follow my twitter account to get daily updates: @BLantz2455
May 21, 2013 at 1:50 pm
This is a pretty simple way to do it:
update b
set Address1 = a.Address1,
Address2 = a.Address2,
city = a.city,
stateAdd = a.stateAdd
from
(select * From #List join #Addredss on From_ID = ID) a
join
(select *...
--------
For SQL Tips, check out my blog: http://lantztechknowledge.blogspot.com/[/url]
You can also follow my twitter account to get daily updates: @BLantz2455
May 13, 2013 at 9:55 am
I sure hope this isn't homework for school. It certainly looks like it.
--------
For SQL Tips, check out my blog: http://lantztechknowledge.blogspot.com/[/url]
You can also follow my twitter account to get daily updates: @BLantz2455
May 13, 2013 at 9:46 am
Does the test user have any securables? If so, those need to be removed first before the user can be removed.
--------
For SQL Tips, check out my blog: http://lantztechknowledge.blogspot.com/[/url]
You can also follow my twitter account to get daily updates: @BLantz2455
May 8, 2013 at 11:24 pm
Where is the login located, within the database or within SQL Server? I've seen where a user has permissions on one server, the database is backed up and moved...
--------
For SQL Tips, check out my blog: http://lantztechknowledge.blogspot.com/[/url]
You can also follow my twitter account to get daily updates: @BLantz2455
May 8, 2013 at 10:49 pm
Check here under The Correct Way to Post Data: http://qa.sqlservercentral.com/articles/Best+Practices/61537/
We really don't need that much. Ten rows of data per table should be enough.
--------
For SQL Tips, check out my blog: http://lantztechknowledge.blogspot.com/[/url]
You can also follow my twitter account to get daily updates: @BLantz2455
May 8, 2013 at 6:18 pm
Viewing 15 posts - 1 through 15 (of 56 total)