Frank Kalis

Forum Replies Created

Viewing 15 posts - 4,486 through 4,500 (of 5,356 total)

RE: Dynamic Columns

quote:

declare @max int

declare @ct int

declare @sql nvarchar(4000)

select @max = max(ColPosition) from frtabledef where jobid = @jobid

create table...

July 25, 2003 at 8:07 am

#467070

RE: How to remove leading zeros?

Hi CarKnee,
quote:
The only cases that have letters are "ed". It is roughly 200 records out of 200,000 that have letters in them.

July 25, 2003 at 7:58 am

#467053

RE: need help with syntax-EXEC i get an error

quote:
i get an error
Server: Msg 170, Level 15, State 1, Line 10
Line 10: Incorrect syntax near '@recipient'.
what is the problem ???
-------------------------
DECLARE @recipient...

July 25, 2003 at 7:36 am

#467043

RE: How to insert data containing ', /, etc

Hi Zambrtp,

quote:
HELP...I have a dynamic insert statment that
on occasions may have data that includs things like ticks ', and other symbols..
How can...

July 25, 2003 at 7:33 am

#467041

RE: Update Query and Joins in EM vs. Query Analyser

quote:
I thought your picture really was you!

suprised?

I knew, you had...

July 25, 2003 at 7:31 am

#467040

RE: How to remove leading zeros?

Hi Carknee,

quote:
The records look like this in one table 00123 and 123 in the other. However, there are a few instance where...

July 25, 2003 at 7:26 am

#467037

RE: Update Query and Joins in EM vs. Query Analyser

quote:
You are just a sponge for this stuff. You are what we Americans call a "Cyber Geek". ...

July 25, 2003 at 7:14 am

#467031

RE: Update Query and Joins in EM vs. Query Analyser

quote:
Here's another good link on Visual Language Research Bibliography:
http://eecs.oregonstate.edu/~burnett/vpl.html
You'll find everything under the sun there on this topic.

July 25, 2003 at 7:01 am

#467027