Viewing 13 posts - 16 through 28 (of 28 total)
Ian Scarlett (7/6/2009)
Don't forget, "'D:\alianz\output\CEMTXOUT_ALIANZ'" is referring to the D: drive on the server, not the workstation you are...
July 6, 2009 at 7:17 am
I displayed the output and it work but when trbasfer it give this error
Error = [Microsoft][ODBC SQL Server Driver]Unable to open BCP host data-file
do u have any idea to...
July 6, 2009 at 6:59 am
ALZDBA (7/6/2009)
Try this:
SET @bcpCommand = 'bcp " select ' + @CTX_TRAILER +' " queryout "'Why aren't you using the T-SQL "Backup database" command with a SQLCMD ?
It not owrk I...
July 6, 2009 at 5:46 am
Dave Ballantyne (7/1/2009)
create table ali
(
code varchar(16),
fromcol integer,
toCol integer
)
go
insert into ali values('ali1',1,5)
insert into ali values('ali2',6,15)
go
with ctenumber(rownum)
as
(
Select rownum = row_number() over(order by id)
...
July 1, 2009 at 4:51 am
GilaMonster (7/1/2009)
So want you want outputting isAli, 1
Ali, 2
Ali, 3
Ali, 4
Ali, 5
Ali2, 5
Ali2, 6
Ali2, 7
... all the way up to
Ali2, 49
Ali2, 50
yes exactly what I want , please help me...
July 1, 2009 at 3:01 am
GilaMonster (7/1/2009)
Can you give us some sample data for the Ranges table? Read this to see the best way to post this to get quick responses.http://www.sqlservercentral.com/articles/Best+Practices/61537/
The Ranges Table have the...
July 1, 2009 at 2:08 am
GilaMonster (7/1/2009)
ali.m.habib (7/1/2009)
select *from RANGES CROSS APPLY dbo.fnCrossJoinRange2([Ranges.from],[Ranges.to])
but give the same error
Is the database case sensitive? If so, you'll need to fix the case in the proc's parameters.
thanx alot...
July 1, 2009 at 1:38 am
GilaMonster (7/1/2009)
ali.m.habib (7/1/2009)
select *from RANGES CROSS APPLY dbo.fnCrossJoinRange2([Ranges.from],[Ranges.to])
but give the same error
Is the database case sensitive? If so, you'll need to fix the case in the proc's parameters.
thanx alot...
July 1, 2009 at 1:37 am
GilaMonster (7/1/2009)
select <Column list >
from RANGES
CROSS APPLY...
July 1, 2009 at 1:18 am
I found the solution thnax for all the member
January 29, 2009 at 2:10 am
GSquared (1/27/2009)
iainthepitman (1/27/2009)
January 27, 2009 at 8:17 am
GSquared (1/27/2009)
You can't build the string to be executed inside the Exec command. Build it as a variable first, then execute it.
the problem not in the string it work...
January 27, 2009 at 7:31 am
delete and reinsert 2 thousands and more record oh, are ukiding
January 4, 2009 at 7:38 am
Viewing 13 posts - 16 through 28 (of 28 total)