here's a CTE of your data that is inte ready-to-use format my friend Cadavre suggested:

WITH myCTE ([Branch],[Year],[Count of All who failed],[Count of all right handed who failed])

AS

...

how much memory does your developer machine have?

I find VS2010 is very resource intensive; a single isntance devenv.exe is currently 1.4 gig or ram for a big project, and two...

well, ideally, your scalar UDF can be converted to an inline table funciton instead.

Create FUNCTION fnAdjustDateTime_itv (@date datetime, @timezone int)

RETURNS table

AS

RETURN

SELECT DateAdd(hh,CASE

...

bulk insert expects raw data, and not formatted INSERT...statements.

if your file looked like this isntead:

1,Apr 27 2012 12:00AM

2,Apr 27 2012 12:00AM

bulk insert would insert into a two column table witht...

Monitoring can be a wide subject, sicne there is a lot of different things you might want to review.

redgate, the website sponsor/owner, provides some free reports you can add to...

probably what you are asking, is, if you have multiple email accounts, how do i change which one is used for the default email profiles?

IN SQL Server Management Studio, int...

well, it's possible... you can do it with a wHILE loop, i guess.

something like this seems to be what you are asking for, maybe?

DECLARE @rowcount int

SET @rowcount = 1

WHILE @rowcount...

have you looked into SSRS Data Driven Subscriptions, I'm pretty sure that's exactly what you are after, so that there is no user interaction required to create teh reports...so you...

tripri (10/11/2012)

---

Hi I got a table with one column of lenght 500 and i got around 500,000 records.

So from that i'm looking for some record 'abc dfgr hjk kishg lZDjsdf...

ok SELECT OBJECT_NAME(437576597) will tell you the table that is having the problem.

since it says index(0) and index(2) on that object, we know the table is a Heap, and...

run this command in SSMS, and post the entire results back here.

the database in question is VertexProd, right?

DBCC CHECKDB('VertexProd') WITH NO_INFOMSGS, ALL_ERRORMSGS

yeah the second half of the issue is tough; you can stick the descriptive data in a relationsship witht eh columns/tables, etc with extended properties(sys.sp_addextendedproperty and fn_listextendedproperty), but that also...

if the OP can identify how he knows the "same record" already exists, it would be something like this

CREATE trigger Del_records on Active_Table

AFTER insert

as

delete from Active_Table a

INNER JOIN...

I had to do that a lot previously.

keep the table you import into, but create a view with column names that better describe the purpose of the columns;

even better, the...

this thread has a very similar issue:

too strong of permissiosn were granted, but the DENY command doesn't have the level of granularity to take away things like ALTER TABLE

this example...