Viewing 15 posts - 2,311 through 2,325 (of 2,894 total)
I think it does it always, otherwise "running total update" method wouldn't work.
August 1, 2011 at 9:01 am
Can you specify what your expected results should look like? Do you want to calculate how many hours employee did work each day or what?
DDL with table setup and some...
August 1, 2011 at 7:39 am
cengland0 (8/1/2011)
Eugene Elutin (8/1/2011)
DECLARE @var varchar(max);
SET @var =...
August 1, 2011 at 7:31 am
mahalaxmi.k62 (8/1/2011)
In my query I have to compare two fields, one uniqueidentifier and the other nvarchar.
Uniqueidentifier Field value is :
the query in Where clause is:
wpmp.grew_workproductmoduleprofilesid in
(select grew_includemodules from...
August 1, 2011 at 6:55 am
Can someone guess without executing what the following SQL will return on Canada like server setup (I have the UK one) 😀
DECLARE @var varchar(max);
SET @var = 'Hello World';
SELECT...
August 1, 2011 at 5:52 am
Map the drive or use full path :
\\machinename\c$ ...
But, why are you using SQL for this? PowerShell or old dos-batch are designed exactly fo the purpose you have.
August 1, 2011 at 4:08 am
C.K.Shaiju (7/29/2011)
...
There is a procedure which is returning 2 separate record sets (Refer 2nd Part).
I need to get both the record sets from the SP and make to...
August 1, 2011 at 3:49 am
If you determined to use LEN function and want it to return 3 in your case you can do the following:
select len('1 ' + 'a') - 1
:w00t::w00t::w00t:
August 1, 2011 at 3:38 am
Ninja's_RGR'us (7/30/2011)
Attopeu (7/29/2011)
August 1, 2011 at 3:30 am
If you don't have a value for this new column in your existing source file, you can use some default value for that column.
If you don't want to change...
August 1, 2011 at 3:08 am
Would help if you provide DDL and data setup scripts...
Please follow the link in my signature where you will find details.
Otherwise, you will need to wait for someone who has...
July 28, 2011 at 8:50 am
Shamshad Ali (7/28/2011)
1- What are the pros & cons of this change?
2- Should I remove the stopList which is StopWith as mentioned above? or...
July 28, 2011 at 7:06 am
You shouldn't have this word in the list! It works other way arround!
Try
ALTER FULLTEXT INDEX ON table_name SET STOPLIST OFF
then rebuild the index.
July 28, 2011 at 6:44 am
allmhuran (7/27/2011)
...Why not SSIS? Because the idea is to create a data driven framework that allows one to easily add new queries to the set of available exports.
...
Why not create...
July 28, 2011 at 6:03 am
Viewing 15 posts - 2,311 through 2,325 (of 2,894 total)