Viewing 15 posts - 10,486 through 10,500 (of 13,874 total)
Charmer (8/24/2012)
Phil Parkin (8/24/2012)
Consider changing the cache mode. See here.
i read the article Phil,
Could you please give me your idea for my condition?
My situation is , Look up or...
August 24, 2012 at 6:56 am
Consider changing the cache mode. See here.
August 24, 2012 at 3:15 am
raghuldrag (8/23/2012)
goals,date_of_commitment,kpi,
weightage,goals_review_date
--into #temp
from LIMS..GOALSDTL_Audit where accyear>='20110101' and accyear<='20120101'
and empcode=002244 order by slno
how to create procedure for dis..... while i am crearting procedure its...
August 24, 2012 at 1:45 am
Koen Verbeeck (8/23/2012)
August 24, 2012 at 1:42 am
I've used the File Watcher task in the past for situations like this. See here.
In summary, you execute your package with the FW task as the first task in the...
August 24, 2012 at 1:39 am
MSzI (8/23/2012)
IF EXISTS (SELECT 1 FROM sys.objects WHERE OBJECT_ID = OBJECT_ID(N'[ABC_SCHEMA].[ABC_TABLE]') AND [Type] IN (N'U'))
DROP TABLE [ABC_SCHEMA].[ABC_TABLE]
Because:
1. It's safer to check the schema in witch the...
August 23, 2012 at 6:45 am
What language is this that you are coding in?
August 23, 2012 at 1:59 am
Here is a possible alternative. I haven't compared it to Phil's solution.
Actually, my name is now 'Pro' 🙂
August 22, 2012 at 2:31 pm
n79799 (8/22/2012)
August 22, 2012 at 2:02 pm
You appear to have written your entire question in the subject line, leaving the body of the question blank - but you are new, so please be aware in...
August 22, 2012 at 1:58 pm
Karan_W (8/22/2012)
requirement is:
1: read the raw text or CSV file which doesn't...
August 22, 2012 at 12:24 pm
vp7986 (8/22/2012)
this logic will only apply if there are only 2 matching rows.If there are multiple i cannot get the match.
Sorry, my first post was rubbish. Try this:
create table #temp...
August 22, 2012 at 12:21 pm
ChrisM@Work (8/22/2012)
Cadavre (8/22/2012)
Phil Parkin (8/22/2012)
August 22, 2012 at 9:40 am
Lowell (8/19/2011)
August 22, 2012 at 8:46 am
Viewing 15 posts - 10,486 through 10,500 (of 13,874 total)