Very good question.Refreshed the basics.

I was not sure about middle two but sure about first two(7,7) and last two(14,80).

So objective approach which I developed from Engineering Entrance Exam worked and...

ALI100 (7/10/2012)

---

let's suppose i have a value having lable name abc#= '6599912268'

& the new project has no ERD no standard of naming conventions... I need a fast way to...

Arman Khan (7/10/2012)

---

Hello, I need some help from the experts to get the Start date for each week in a given month.

For example:

...

ALI100 (7/10/2012)

---

Hi

Actually i have a new client ,& their Database has no standard naming conventions & the application is in classic asp.I have a form in which a form there...

Devesh_Srivastava (7/10/2012)

---

I am really sorry for the confusion!

Currently my issue is with the second step of the package i.e DataFlow Task inside ForEach Loop container. Rest of the story for...

Devesh_Srivastava (7/10/2012)

---

Hi,

I am trying to insert data from source to destination table. Both the Tables are of same name and same table structure, just they are in Different databases.

The whole...

mayank.gauswami (7/10/2012)

---

Hi All,

Can anyone help me and show me right way to prepare for these exams.

please post a good link or book to prepare....basically i need the basic idea...

deba_20032004 (7/9/2012)

---

Dear Sir,

I never use '>' operator in case of text field with where cluse now i see one example which is written below..

SELECT CompanyName FROM customers

WHERE CompanyName > 'a'

result...

I got the answer in first click but then I thought what if SQL 2012 get WHERE clause in TRUNCATE command :hehe:

kulkarnikag (7/9/2012)

---

hi

i am using sql server 2005 ,unable to schedule the job giving error

TITLE: Microsoft SQL Server Management Studio

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

Unable to cast object of type 'Microsoft.SqlServer.Management.Smo.SimpleObjectKey' to type 'Microsoft.SqlServer.Management.Smo.Agent.JobObjectKey'. (Microsoft.SqlServer.Smo)

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

BUTTONS:

OK

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

pls...

Fearsome

bala2 (7/9/2012)

---

Hi,

Many thanks for reply,

I have used this command

select REPLACE(LTRIM(REPLACE(A_H, 'D', ' ')), ' ', ' ') from tableA

It is working .But is displaying space before the numric.

IS ther...

Engine

bala2 (7/9/2012)

---

Tabe-A

A-d-int,pk,notnull

A_H--nvarchar(10),null

A_dn-navrchar

A-S-int,null

A_c-date(smalldatetime,null

Table-B,

B_d --int(PK,not null)

B_H---int,notnull,

B_Dn---nvarchar(14),notnull)

B_c_date--(smalldatetime,null)

B-si--(int,null)

B_DT--(smalldatetime,null)

when we are using the below insert into query we are got the error as "Msg 245, Level 16, State 1, Line 1

Conversion failed when converting the...

mpdillon (7/9/2012)

---

A slight modification to dwain.c's solution works and seems simple enough.

--Remove ItemNo from the Group By

Select OrdNo

From OrdLine

where ItemNo IN ('A', 'B', 'C')

GROUP BY OrdNo

HAVING COUNT(ItemNo) =...