Viewing 15 posts - 53,266 through 53,280 (of 59,068 total)
Thanks, Jason...
Funny about these free offerings, though... they teach all of the bells and whistles on the new product (ie. Propaganda 😉 ), but they never teach folks how to...
December 28, 2007 at 4:35 pm
What would you have the cursor or While loop do in a test? I think they'll come out the same but I'm not sure so, you know me, I'll...
December 28, 2007 at 4:26 pm
how can i keep track of which table synonym TableA is currently pointing to?
How does a database keep track of anything? Table. Create a new table to...
December 28, 2007 at 4:21 pm
that these were not GUI applications that were loading these tables, but some sort of machine-driven data entry
Doesn't matter... same idea. Data is being added at a decent rate...
December 28, 2007 at 4:19 pm
The parameters are defined in the report parameters with the default value.
No they're not... only the UserID parameter has a default on it.
December 28, 2007 at 4:14 pm
Damon is spot on... don't drop the user immediately... just disable it.
December 28, 2007 at 4:12 pm
This snippet was created and posted by someone else who frequents this site. I wish I could remember who to give them credit.
Thanks for the compliment, Joel... nice to see...
December 28, 2007 at 3:57 pm
That's nice... But the OP did say "Unfortunately the only tool available to me right now is sql server 2005. How can I achieve this ?" I'm pretty sure...
December 28, 2007 at 3:17 pm
This should do it, Mike...
SELECT *
FROM yourtable
WHERE ISDATE(LEFT(yourcolumn,4))=1
AND yourcolumn LIKE '[0-9][0-9][0-9][0-9]-[0-9][0-9][0-9][0-9][0-9]'
December 28, 2007 at 3:15 pm
Huh? I must be missing something there...If you only want them if they have "4" for "posuf", then I'm thinking that you need to say that somewhere in the...
December 28, 2007 at 3:11 pm
Heh... Happy New Year to you to... you should make a good resolution... repeat after me, please... "I will NOT use cursors for simple set based problems." 😛
December 28, 2007 at 2:59 pm
Heh... see that! Another good answer that wasn't in the possible answers :hehe:
December 28, 2007 at 2:57 pm
1. is the table locked during the export?
2. what if at that particular moment i have hundreds of new inserts?
3. what would be the best...
December 28, 2007 at 2:56 pm
I don't know what this table is actually for, but it's generally a bad idea to just flush data down the toilet without carefully considering what that loss of data...
December 28, 2007 at 1:31 pm
I absolutely agree with Sergiy and Madhivinan... the root problem is that the column is the wrong data type. The datatype for the column should be/must be changed to...
December 28, 2007 at 1:28 pm
Viewing 15 posts - 53,266 through 53,280 (of 59,068 total)