Viewing 15 posts - 91 through 105 (of 337 total)
Thanks, Sachin. I appreciate your time.
My pleasure Jeff and a great honor.
I gleened what it does from Lowell's post and a couple of dozen posts that I Yabingooglehoo'd but...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
June 22, 2014 at 11:37 am
Having good background with C# maybe I will try to clear that.
Cid is called ContentIdentifier.So when an image needs to be referenced in a mail basically it can be done...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
June 22, 2014 at 9:45 am
geo123abram (6/22/2014)
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
June 22, 2014 at 7:16 am
Can you post the SP code ?
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
June 22, 2014 at 3:43 am
Eirikur Eiriksson (6/21/2014)
Sachin Nandanwar (6/21/2014)
What should happen in case of trailing zero's ? Example 1000,9990 or zero's that are neither leading or trailing ex : 1001
Those would then certainly...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
June 22, 2014 at 12:03 am
You can define the parameter to a default value of NULL
@YourParameter1 varchar(100)=NULL,
@YourParameter2 int=NULL
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
June 21, 2014 at 11:54 pm
What should happen in case of trailing zero's ? Example 1000,9990 or zero's that are neither leading or trailing ex : 1001
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
June 21, 2014 at 11:48 pm
Without sample data this is just a shot in the dark.
SELECT DISTINCT S.EnrollNo
,S.Name
,ET.Descriptions AS EventName
,T1.AttendStudent AS AttendStudent
,T2.AttendFaculty AS AttendFaculty
FROM StudentEvent SE
INNER JOIN SStudent S ON SE.PresentatorID = S.StudentID
INNER JOIN StudentEventType...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
June 21, 2014 at 10:16 pm
pwalter83 (6/20/2014)
Sachin Nandanwar (6/20/2014)
CREATE TABLE [dbo].[GL](
[Sequence] [int] NOT NULL,
[WK NO] [int] NULL,
[AC] [nvarchar](10) NULL,
[COMP] [nvarchar](10) NULL,
[USD_AMOUNT] [numeric](16, 2)...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
June 20, 2014 at 11:53 pm
The deadlocks now typically involve inserts and deletes from the filter table and CRUD action against a table that has a foreign key to master table. The deadlocks are keylocks...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
June 20, 2014 at 9:50 pm
Couple of months back I used a VBScript in Script task component of SSIS package to change file extensions.Not sure about DTS.
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
June 20, 2014 at 10:23 am
I dont understand the problem here.Your query seems to be achieving it.
CREATE TABLE [dbo].[GL](
[Sequence] [int] NOT NULL,
[WK NO] [int] NULL,
[AC] [nvarchar](10) NULL,
[COMP] [nvarchar](10) NULL,
[USD_AMOUNT] [numeric](16, 2) NULL,
[SOA_TYPE] [nvarchar](20) NULL
)...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
June 20, 2014 at 9:46 am
http://technet.microsoft.com/en-us/library/ms188603%28v=SQL.105%29.aspx
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
June 20, 2014 at 8:22 am
How do you define a quarter ? Based on financial year or Calendar year ?
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
June 20, 2014 at 8:02 am
But you seem to having one already in your query
(SELECT SUM(CASE WHEN SOA_TYPE IN ('Agent','Freight','Cost') or AC = '16208'THEN USD_AMOUNT ELSE 0 END) YourSum
FROM GL b WHERE...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
June 20, 2014 at 6:55 am
Viewing 15 posts - 91 through 105 (of 337 total)