Viewing 15 posts - 14,221 through 14,235 (of 15,381 total)
Cool idea. Will have to add to my snippets.
August 18, 2011 at 2:31 pm
This seems like an awfully complicated way to handle getting more than record. Why don't you just pass the plates that the user wants? The way you built this you...
August 18, 2011 at 1:56 pm
Let your troubles be a good example and reason why you should store datetime data in a datetime datatype. Datetime information in NOT string data. It is datetime data. You...
August 18, 2011 at 1:29 pm
OK something like this should give you a decent example. This will keep your entries grouped together but you WILL have to figure out what column in your source table...
August 18, 2011 at 1:22 pm
That is because the sequence numbers were hard coded in the insert that Chris wrote. I believe you want to maintain the same kind of sequence you had in the...
August 18, 2011 at 1:11 pm
/facepalm
totally missed this was Intranet. That's what I get for responding for finishing my first cup of coffee. Yes internally you absolutely can get the current user. I am going...
August 18, 2011 at 7:56 am
The app pool is the user that is logged in. The web server has no way to know the username of the client that is connecting. That would be a...
August 18, 2011 at 7:46 am
You can't create a database and reference it in the same stored procedure. You can only use a single batch within a stored procedure and your database will not exist...
August 18, 2011 at 7:39 am
Oh my!!! There is so much inefficient and not accurate code in here.
Let's start here.
SELECT
@rate_type_home = rate_type_home, --Get...
August 17, 2011 at 3:10 pm
Oh man you so don't want to use a cursor here. I am pretty swamped at the moment but I can help later today if nobody else jumps in.
August 17, 2011 at 11:48 am
Yeah why would you create a stored procedure to create a permanent table? You can't run your stored procedure more than once. You probably should be using a temp table...
August 17, 2011 at 10:33 am
And what exactly did you contribute? A lot of arrogance and confrontational nonsense.
Here is your post with all of the arrogant and non contributing drivel strikethrough
There is nothing advanced or...
August 17, 2011 at 9:53 am
LOL We are all guilty of over thinking. It is part of what makes our type of people the way we are. If we didn't try to innovate we would...
August 17, 2011 at 8:41 am
If you have cascading deletes setup on your relationships just delete the parent. If you don't then you will have to delete the records from ALL the children first and...
August 17, 2011 at 8:09 am
Viewing 15 posts - 14,221 through 14,235 (of 15,381 total)