Forum Replies Created
Viewing 15 posts - 3,106 through 3,120 (of 3,544 total)
-
RE: Identity Function
There is nothing in SQL7 BOL either way about using a variable. Try this as an alternative
create table #temptable (rowID int IDENTITY(1,1),...)
DBCC CHECKIDENT (#temptable,...Far away is close at hand in the images of elsewhere.
Anon. -
RE: Distributed Query fail on local machine
OPENQUERY needs a linked server and there is not one for the local machine. I have not tried it but I suppose you could create an alias called LOCAL to...
Far away is close at hand in the images of elsewhere.
Anon. -
RE: Complicated Extration... Use cursors ???
Don't need a cursor.
If each proc updates the extract table using the PK then write one proc to EXECUTE all the rest.
Another way is to number the procs from 1...
Far away is close at hand in the images of elsewhere.
Anon. -
RE: Exporting data in vertical text format
Are you extracting to variable output? If so there is a 255 byte limit per field. Try changing to fixed length
Far away is close at hand in the images of elsewhere.
Anon. -
RE: datawarehouse with DTS + stored procs only ?
I think it is one of those buzz words that got around. I understand it as a datawarehouse but on a small scale or part of a datawarehouse.
Datawarehousing is not...
Far away is close at hand in the images of elsewhere.
Anon. -
RE: How to Break a While ?????
Yep your right Frank expecially when that someone reiterates multiple nested subs and functions 10 to 20 times. I keep my procs as small and compact as possible and only...
Far away is close at hand in the images of elsewhere.
Anon. -
RE: need help with COUNT
Well spotted there James. Hoisted by my own petard. I just copied,edit and pasted. I personally don't use BETWEEN and I always match dates in yyyy-mm-dd format.
Far away is close at hand in the images of elsewhere.
Anon. -
RE: How to Break a While ?????
Hi Frank,
quote:
be careful with such statements!There were times when I wished I'd meet the developer alone at night
Far away is close at hand in the images of elsewhere.
Anon. -
RE: datawarehouse with DTS + stored procs only ?
We don't have any datawarehouses but have datamarts (corner shop variety). I use procs, dts, scheduler for whole process from data extraction to cube build. It works for me
Far away is close at hand in the images of elsewhere.
Anon. -
RE: Exporting data in vertical text format
SELECT
'Name : '+[Name]+CHAR(13)+CHAR(10)+
'Address : '+Address+CHAR(13)+CHAR(10)+
'Country : '+Country+CHAR(13)+CHAR(10)
FROM tablea
Far away is close at hand in the images of elsewhere.
Anon. -
RE: Export to a text file using fixed fields w null
I'm on SQL7 SP4 and it works fine for me.
What are you using to check column alignment (proportional font!)
Far away is close at hand in the images of elsewhere.
Anon. -
RE: need help with COUNT
In addition to SQLBill's observation you are also grouping by mor columns than you are selecting. Try this
SELECT fname, mhlka, sog, COUNT([id]) AS Count_id
FROM dbo.searchall
WHERE...Far away is close at hand in the images of elsewhere.
Anon. -
RE: Worst Practice - Bad Connection Strings and Bad Info in Sysprocesses
Good article Andy. My apps use common code for connection strings so adding this would be easy for me. As I do not have a large user base for my...
Far away is close at hand in the images of elsewhere.
Anon. -
RE: Running Multiple SQL Files
ISQL & OSQL are the DOS batch file equivalent of ISQL (aka QA Query Analyser)
use
ISQL -S servername -U username -P password -d database -b -m-1 -i scriptfilename
if ERRORLEVEL 1 pause
-b...
Far away is close at hand in the images of elsewhere.
Anon. -
RE: Running Multiple SQL Files
I put all my procs in separate files and use ISQL on the file I want to update my database(s). You can put several ISQL commands in a batch file...
Far away is close at hand in the images of elsewhere.
Anon.
Viewing 15 posts - 3,106 through 3,120 (of 3,544 total)