Viewing 15 posts - 1,246 through 1,260 (of 5,590 total)
You know, the people that help out here are all un-paid volunteers, so please HELP US HELP YOU. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables...
June 2, 2011 at 7:24 am
The biggest issue is that you'll have to get (aka purchase) the PostNet barcode font, and install in on the appropriate computers. sounds like the web server, possibly the end-users...
June 2, 2011 at 7:22 am
rhutchinson 13368 (6/1/2011)
Leju,You nailed it!!!! I don't fully understand the code, but thank you very much for being specific!!! I really appreciate your help and thanks again.
Might I...
June 2, 2011 at 7:13 am
Lordy, I knew 2005 made it easier... forgot just how much easier! I'm having trouble even thinking along those lines anymore. 🙂
June 1, 2011 at 2:48 pm
sql_jr (6/1/2011)
[task_name] [nvarchar](30) NULL,
[task_id] [int] NOT NULL,
...
June 1, 2011 at 1:02 pm
tfeuz (6/1/2011)
I have taken you code and I am having some sucess with it -- can you give me an example of how to eliminate the last cursor? (you make...
June 1, 2011 at 12:41 pm
Hi Kit,
Try this:
;with CTE as
(select ROW_NUMBER() over (order by ID) as AddrNum,
ROW_NUMBER() over...
June 1, 2011 at 12:25 pm
So, based on the sample data provided, please show what your expected results are.
June 1, 2011 at 11:54 am
lgonzales 69796 (6/1/2011)
What if you need to this but the type is in another table?
JOIN to it.
June 1, 2011 at 11:33 am
DevNate (6/1/2011)
Do you mind providing an example?
Nope. Do you mind providing table definitions (DDL, aka CREATE TABLE statements), sample data (aka INSERT statements) and expected results based upon that sample...
June 1, 2011 at 11:31 am
My comments:
1. If you use an artificial / surrogate key, it should be used in conjunction with the natural key. The column(s) of the natural key should have it's own...
June 1, 2011 at 10:55 am
Okay, I see where you're coming from. Yes, it would be a bit of front-end code pain to deal with that.
June 1, 2011 at 10:27 am
GilaMonster (6/1/2011)
Dave Ballantyne (6/1/2011)
Some people really dont want to be helped do they :crazy:http://www.sqlservercentral.com/Forums/Topic1116629-9-3.aspx#bm1117914
Yeah...
I always wonder about the threads where someone asks for a bunch of information and the OP...
June 1, 2011 at 7:49 am
Actually, you need to query sys.parameters...
SELECT SchemaName = ss.name,
ObjectName = so.name,
ParameterName = sp.name,
...
June 1, 2011 at 7:39 am
You know, the people that help out here are all un-paid volunteers, so please HELP US HELP YOU. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables...
June 1, 2011 at 7:20 am
Viewing 15 posts - 1,246 through 1,260 (of 5,590 total)