john.arnott (5/6/2008)

---

Excellent question in that to understand the result, you have to step through the entire process.

--The statements compile.

--Each "select" is executed.

--Then the two result sets...

Jeff Moden (5/2/2008)

---

Part of the problem is that you go back to delete the trailing comma... you basically do something like this...

DECLARE @somestring VARCHAR(8000)

SET @somestring =...

this is...

Mahesh Bote (4/30/2008)

---

[font="Verdana"]Have you tried to execute it with sp_executesql?

From BOL:

Using sp_executesql is recommended over using the EXECUTE statement to execute a string. Not only does the support for parameter...

Thanks

i can't try it now, since my excell feature is not yet installed. i will try later. but i understand the other way from bcp

i think the index seek is not taking weekend column it is taking only customer id , but it is showing full conditional string

nice..can you explain...

Javier (4/24/2008)

---

You can try to export using bcp...

We use this sproc, don't know where i saw first

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=72841

http://www.eggheadcafe.com/software/aspnet/31906881/importing-saltable-to-exc.aspx

DECLARE (We made some modifications to use it 'cause having...

sorry guys

i found the result. since i am using INFORMAT_SCHEMA views i am getting these result

Thanks

Bilichi (4/10/2008)

---

Hi

i am Getting the following error in sqlserver 2000 with service pack 1 while executing the sp.Same sp when i am run in some other server of same...

hi

i used the given example, but i got error saying

Server: Msg 156, Level 15, State 1, Line 1

Incorrect syntax near the keyword 'WITH'.

i am using sql server 2000, I don't...

hi

refere this url

http://searchwinit.techtarget.com/tip/0,289483,sid1_gci1014050,00.html

Hi guys,

I am sorry, i made a mistake after execute sql i called getdate() function and after i called...

i already tried the result is 1 not rows affected

try yourside

You are right,...