Viewing 15 posts - 14,371 through 14,385 (of 15,381 total)
Can you just end your first string before </body> and duplicate your logic for tables 2 and 3 and just append your variables?
By the way, you have two instances of...
July 28, 2011 at 7:40 am
Jeff Moden (7/26/2011)
I also don't understand why anyone would ever require such a thing.
Hear Hear!!! I often tell business people (which are the ones that usually ask for this kind...
July 27, 2011 at 2:40 pm
danschl (7/27/2011)
around my office there is a sayingJust because you can put it into one query doesnt me you should
I would break that up:w00t:
Or at the very least add...
July 27, 2011 at 2:00 pm
They are different datatypes. Try doing this in SSMS and looking at the script. It creates a new column (with a temp name), updates with old column, drops the old...
July 27, 2011 at 1:57 pm
WOW that is hard on the eyes. :crazy:
You really should not be running dynamic sql like that directly from your managed code. I would suggest turning that beast into a...
July 27, 2011 at 12:57 pm
Curious what you are trying to do here. Is this just playing or do you have some actual reason for this? Your code is sort of half dynamic and half...
July 27, 2011 at 12:39 pm
Nothing wrong with it as long you realize you are only going to the first 3 characters in your string.
July 26, 2011 at 2:20 pm
It is much like any other code, the readability often comes down to user preference. In general code tends to be easier to read if you use white space liberally....
July 26, 2011 at 1:30 pm
The other thing that can kind of ugly is when you no longer have just varchar data. You suddenly start being forced to cast/convert stuff. By all means don't just...
July 26, 2011 at 11:49 am
That kind of structure will work but it gets nasty. As you said there are as many as 70 groups of data. Imagine the query when you need to get...
July 26, 2011 at 10:57 am
Sweet. I am guessing that is way faster than that old nasty cursor. Nice work! Will have to see if this meets the criteria for the OP but it looks...
July 26, 2011 at 10:42 am
I am thinking there has to be a set based solution to this but my brain is too full with my own stuff today. 😉
At any rate I moved a...
July 26, 2011 at 8:35 am
Sounds like you have a nightmare to deal with. It sounds like your "cluster" is based on the first word of the company name. Is that correct? How do you...
July 26, 2011 at 7:43 am
pietlinden (7/26/2011)
The ONLY difference between LIKE in SQL Server and LIKE in Access is the wildcard character...Access uses * for a wildcard and SQL Server uses %
That is not true....
July 26, 2011 at 7:12 am
No it is nothing like Not Null.
the Value 'br459' would be returned with Not Null
it would not be returned with access Like 'br4?'
it is a single character wildcard.
like 'br4?9' would...
July 25, 2011 at 3:13 pm
Viewing 15 posts - 14,371 through 14,385 (of 15,381 total)