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...--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
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.--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: need help with syntax-EXEC i get an error
quote:
i get an errorServer: Msg 170, Level 15, State 1, Line 10
Line 10: Incorrect syntax near '@recipient'.
what is the problem ???
-------------------------
DECLARE @recipient...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: How to insert data containing ', /, etc
Hi Zambrtp,
quote:
HELP...I have a dynamic insert statment thaton occasions may have data that includs things like ticks ', and other symbols..
How can...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Update Query and Joins in EM vs. Query Analyser
quote:
I thought your picture really was you!
suprised?
I knew, you had...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
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...--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
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"....--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
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.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
...RE: weekly report
quote:
There is absolutely no shame in asking a valid question. The only poor question is the one not asked. Please...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
RE: Importing data from txt file and updating Table
quote:
i don't know what you mean by 'new' - do you mean new records??
sorry,...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
RE: Update Query and Joins in EM vs. Query Analyser
quote:
You made a good point about designing in the visual tool and then refining in QA. That's exactly what I'd like...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
RE: Importing data from txt file and updating Table
Hi djpeake,
quote:
We receive a text file every month from our supplier which is to be used to update a table we have...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
RE: Go to first new post
Hi Stefan,
quote:
Not exactly.'Active Topics' takes you to threads with new posts.
Some sites have the ability to:
1. View New Messages (Active Topics)
2....
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
RE: QOD Cheats
quote:
Frank, you must have outstanding PM's over there, if they not only know how to cut and paste but use ppt...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
RE: QOD Cheats
quote:
Shhhhh there maybe managers, or Project Managers, lurking around
so what?
Do...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 15 posts - 4,486 through 4,500 (of 5,356 total)