Thanks for replying! :-) Actually, that's what I ended up doing and it worked! I also ended up using a table variable (since it has to be a function) and a CTE to make sure I don't count the same month twice. It's possible someone could take leave for one week in the middle of the month. That...
SQL Server 2005 sp3
This is driving me nuts. It's probably a simple solution but I'm just not seeing it.
We have a table of employment records like this (simplified):
ID fromDate throughDate type
---- ---------- ----------- ----
1 2009-08-02 2010-09-12...
I have SQL Server Management Studio 2005 (9.0.4035) and 2008 (10.0.2531) installed on my computer (Windows XP). Today when I opened the replication monitor in SSMS 2005 connecting to a SQL 2005 server, all of my publishers (SQL 2005) were either missing or had a red X on the name. I re-added the...
What version of SQL Server are you using? If it's 2005 or 2008, there's a template regarding this sort of thing. It's called "Direct Reports Recursion Example". It basically uses a CTE (common table expression).
http://technet.microsoft.com/en-us/library/ms186243(SQL.90).aspx
Hope that helps!
Hello all!
When I run T-SQL to drop and re-create a specific stored procedure on a development server, I get a stack dump every time and it disconnects my session from the server.
Server Info:
SQL Server 2005 SP3 (9.0.4035)
Windows Server 2003 Standard SP2
2 GB RAM
The procedure contains a...
Using Reporting Services 2005, does anyone know how to format a column cell in a matrix so that it reads from bottom to top? I have the writing mode set to tb-rl but it reads from top to bottom. Can this be rotated so that it reads from bottom to top instead? Any help is appreciated!
Thanks! :-)
Thanks for replying. I know what you're saying. Here is some code to show what I'm asking. Which of the two statements below is better?
select o1.name
,Address.streetNumber
,Address.streetName
,Address.zip
,Address.city
,Address.state
from vwNam o1
left join dbo.Contact
on...
Hello all,
I'm a bit rusty with database development and am hoping someone could help me figure something out.
Normally when I write select statements with joins, I don't include things such as "and codeDeleteFlag = 'N' " as part of the join clause. I usually put this in a where clause. Is it...
What I did was follow the instructions in the link below. I used the data pump task to copy the packages from msdb.dbo.sysdtspackages to the same table in the other server.
http://www.sqldts.com/204.aspx
It worked great for me. Hope this helps!
I believe that just because the Start, Stop options are greyed out that doesn't necessarily mean the Agent wasn't installed correctly. I'm looking at one of my 2005 installations and the agent is running fine even though the Start, Stop options are greyed out.
Have you checked the...
One option could be to encrypt the actual data files using something like Windows File Encryption System. Another option would be to secure the server or computer the files are on to prevent someone from getting to the files in the first place.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.