well ideally im getting rid of everything older than year , which is around 1 million rows. And ill be left with 2mil rows

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[u_od](

[id] [INT] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,

[created] [DATETIME] NOT NULL,

[createdBy] [INT] NOT NULL,

[updated] [DATETIME] NOT NULL,

[updatedBy] [INT] NOT NULL,

[orderId] [INT] NOT...

This is the link if it will help..

https://social.microsoft.com/Forums/getfile/3856/

but primarily I'm talking about when you right click on an application in IIS > manage application > physical path

I mean the physical path of the application , like this...

the values from the other table which exists on a different database

Getting a error

Msg 245, Level 16, State 1, Line 1

Conversion failed when converting the varchar value ',' to data type int.

SELECT

MIN(s.created) loginDateTime,

MAX(s.updated) logoutDateTime,

UPPER(s.appName) appName,

CAST(s.created AS DATE) createdDate,

UPPER(s.userName) userName,

r.id

FROM a_Session s

--------------------------------

INNER JOIN u_Contactrole c ON s.employeeid = c.empid

INNER JOIN u_role r ON c.roleid = r.id

--------------------------------

WHERE...

variable number

Thank you , Appreciated the help

yes you can EXEC master..xp_cmdshell '"C:\Program Files\WinRAR\unrar" x e:\rartest\*.rar'

but i dont know how to execute my code within it . at the moment the code above is jus putting...

Second Question ,

would...

Did the trick thank you

Spoke to one of our network guys and he said he will need to map the drive for it to be access. Which is causing my error.

My last problem...

Now im getting a Error = [Microsoft][SQL Native Client]Unable to open BCP host data-file

but the file does exist > C:\bcp and i have created a csv file [customers.csv] which is...

Thanks for that , I changed it to just server. Now Its coming up with a different error

SQLState = 28000, NativeError = 18452

Error = [Microsoft][SQL Native Client][SQL Server]Login failed for...