And you are absolutely sure you are using the correct domain account password?

Pinal Dave (sqlauthority.com) has a great collection of SQL Server term and concept definitions at http://blog.sqlauthority.com/2008/09/20/sql-server-2008-interview-questions-and-answers-complete-list-download/[/url]. They are labeled 'SQL Server 2008 interview questions and answers,' but should be...

Ray K (12/18/2009)

---

So, way back when I was coding ASP.NET, I was in the habit of embedding SQL code (for example, "select * from sometable where somecolumn = somedefinition"), putting...

Jeff Moden (12/6/2009)

---

Thank you for taking the time to post the test data the way you did... saves me a lot of time...

This will do it...

;

WITH

ctePreAgg AS

(

SELECT Name1,

...

how do i determine the no of instances on sql server unding t sql or anyother method . and how do i know total size of harddisk .

please let me...

A primary key is a constraint that uniquely identifies every row in a table. It forces a unique value for that field of every record. It...

You don't need to use a cursor or a loop. You can update the DailyPercent col for a particular month like this:

update DailySalesTable

set DailyPercent = Sales/(

select sum(Sales)

from DailySalesTable...

Actually, now that I see your query, I think the problem may be resolved by using a FULL OUTER JOIN in place of a LEFT OUTER JOIN.

Why can't you just use ISNULL to replace the null value with a zero?

The more important question is "Why do you think that you need to do this?" Generally the preferred approach to provide this information is to just calculate it on request:

SELECT...

Yes, I think a an insert trigger would be the simplest solution. I made an example for you, using the Northwind Orders and Order Details tables. 'TriggeredDetails' is...

Try setting the date variable in SQL Server, not Windows:

select @setdate = cast(datename(year, getdate())as varchar(10))+'_'+cast(datepart(month, getdate())as varchar(10))

select @CreateDir='mkdir G:\Testing\test1\'+@setdate

That way, your @CreateDir var prints:

mkdir G:\Testing\test1\2009_12

Windows assumes that %folderdate% is a...

I guess I come back to the fact that for there to be a clean methodology I either need to have a delimiter or a set size to chop off...

No, the '[NULL VALUE]' string that I substituted is just a placeholder. You could put anything in there...

Wrap each QUOTENAME function instance with an ISNULL function:

select 'Select '

+ ISNULL(QUOTENAME(NoteID,''''),'[NULL VALUE]')+ ','

+ ISNULL(QUOTENAME(CompanyID, ''''),'[NULL VALUE]') + ','

...

from dbo.NOTE_tblNote