Viewing 15 posts - 31 through 45 (of 47 total)
Check your insert operation first before proceeding to the Join...
Check if your table2 has data in it or not???
June 5, 2009 at 9:43 am
Superb. 🙂 Excellent.
Thanks a lot for your help, even your post solved my issue, Article has nothing about remote machine without having sql client installed on it.
I copied...
June 5, 2009 at 8:39 am
Here is what I would do in such case. In fact this is what we have in our project.
Let's say you simply have two different groups of users,
...
June 4, 2009 at 3:03 pm
Please provide some example for this... it would be better that way
June 4, 2009 at 2:47 pm
Ya, I can do that using VBS but they don't want it. they want it to be done by .bat or .cmd only.
Is it possible?
Thanks for your reply..
-RP
June 4, 2009 at 10:53 am
Database1 has table, database2 has view.
view contain select data from table_n.
E.g
Database1: Table1
Database2: View1
and if you are on Database1 Server
then,
Use following syntax
select * from Table1 t
join [Database2].dbo.View1 t2
on t1.col=t2.col
You...
June 4, 2009 at 9:07 am
Well,
I couldn't get any help on this anywhere on web., What I found on the web is, we have to set language property design time only. We can not change...
June 4, 2009 at 8:57 am
Strange!!... Your logic is straight and simple. Are you sure, you have desired data in order to get other values out of this IIF function?
-RP
March 25, 2009 at 7:48 am
Select all of the columns and right click on that. Select MergeCells
Done.
Hope that helps
March 24, 2009 at 3:28 pm
What error you are getting with your iif logic?
March 24, 2009 at 3:14 pm
Thank you GSquared for your reply.
Just to confirm I didn't explain my question wrongly.
we need to connect to SQL Server 2008 database from SQL Server 2005 reporting services(SSRS2005 was pointing...
March 24, 2009 at 3:04 pm
You made right assumption. You will not see lines for the rows with only one occurrences. You need starting point and ending point in order to create line. You have...
March 24, 2009 at 2:59 pm
If you have Table control in your report and if you are trying to reduce space between rows of this table then...
...
March 24, 2009 at 2:21 pm
Click on Menu -> Report
Click on Report Properties
Click on Layout Tab
Set Page width and Page height accordingly
Set Left and Right margin
You will get what you set as simple as...
March 24, 2009 at 1:57 pm
Viewing 15 posts - 31 through 45 (of 47 total)