Viewing 8 posts - 1 through 8 (of 8 total)
I will get an error when adding Nothing to the parameters.
When choosing dont group i get the error NothingName does not exists.
What am i doing wrong?
Also I dont understand how...
September 4, 2015 at 3:41 am
I would like to see this file as well please.
September 4, 2015 at 2:48 am
Yes, because this is also like this in the solution offred.
INSERT INTO ##SQLFiles
EXECUTE master.dbo.xp_cmdshell 'dir /b "C:\DATA\testsql\Procedure\*.sql"'
GO
select * from ##SQLFiles
--DROP TABLE ##SQLFiles
DECLARE cFiles CURSOR LOCAL FOR
SELECT...
June 19, 2015 at 12:32 am
I am getting an error.
I got sql files in the map C:\DATA\testsql\Procedure\*.sql
i run the script, getting an error:
Cannot open input file - C:\DATA\testsql\table\time.sql
No such file or directory
June 18, 2015 at 2:20 am
i am missing or not seeing the place where to puth my path
i.e. C:\data.xml
April 16, 2015 at 5:15 am
i think i changed something. now it is working thanks
April 14, 2015 at 5:51 am
Create table bstest
(project varchar(50),
description varchar(50)
)
Insert bstest (project, description)
(select project, description from table)
** insert 19 rows **
SELECT DISTINCT project,
STUFF( (SELECT ',' + description FROM bstest WHERE bstest.project = T.project FOR...
April 14, 2015 at 5:48 am
i am getting the error
`the multipart identifier project could not be found`
April 14, 2015 at 5:39 am
Viewing 8 posts - 1 through 8 (of 8 total)