Yeah... nor i m able to find it in server list for sql...

No, i m not.

If i could able to get my web server on my Network server list, then i think there wont be any problem... 😉

Hey jocampo, r u going for certification for 2008 or going to upgrade your 2005 certificate?

Hi Melton, Congratulations for your success. 🙂

The link which you have provided here is very useful. Thanks for that.

I am in some what similar situation as you. I also didn't...

Sorry, but i couldnt get your problme clearly.

Though, as per i understood, you have one batch file, say mybat.bat on c:\, which will give list of dirs. Now, you are...

Have a look at this,

http://www.experts-exchange.com/Other/Math_Science/Q_24368714.html

Here is some basic work,

create table #weekData (date datetime, sname varchar(5), price int)

insert into #weekData

select '06-01-2008', 'A', 1 union all

select '06-01-2008', 'B', 2 union all

select '06-01-2008', 'C', 3 union all

select...

Will this work?

Declare @Text1 Varchar(max)

Set @Text1 ='Test Message'

select len(@text1)+(LEN(@text1) - LEN(REPLACE(@text1, 'e', '')))+(LEN(@text1) - LEN(REPLACE(@text1, 'a', '')))

Hi,

can u give the definition of your table and supposed query to read the table.

Though, for quick view, you can replace your inner query (if there is any) with...

Hi,

some more specification will help to better understand the problem.

Hi musab, it's ok.

Actually, i m not in favor of indexing on datetime filed... i would rather change it at design time only. Though scenario like urs also needs...

Then try to change your indexing from datetime to int.. as desc in my last reply and suggested by Grant Fritchey.

Provide some piece of code. that would be better to understand the problem...

Can you be some more specific? there seems a lot may questions..

if you can provide your desired CTE code with sample output then it would be better...

No, both, sys.sysdepends and sys.sql_modules, have different purpose in sql server.

Actually, sys.sysdepends is still there in 2K5 and 2K8 for backward compatibility only. 2k5...