robert.wiglesworth (4/18/2013)

---

Hello,

I have a column called EventText with a string such as 'Receiving batch [688_31142.TRN].' (without the ' marks)

I need to get it to be '688-31142'

I can accomplish that with...

prathibha_aviator (4/18/2013)

---

My requirement is to

-Get the value stored...

mike.hamilton721 (4/18/2013)

---

Tried one more thing.. Not sure if I'm closer or farther away:

insert into #DBID (LogicalName,BindingID)

EXEC ('DBCC fileheader('+@dbid+')')

But that gives me "column name or number of supplied values does not...

patrickmcginnis59 10839 (4/18/2013)

---

dbursey (4/18/2013)

---

From the other side of the fence - I've asked questions here and got ripped a new one because I didn't provide actual examples - sometimes it's...

The problem I have seen in most of the posts asking for interview questions is a lack of effort on the part of the poster. Most of the time...

Ananth@Sql (4/18/2013)

---

Thank you Dina

Your Explanation And presentation Makes Me Clear Of This Question.

And for a clarification tell Me The datatype...

Please read the first article I reference below in my signature block regarding asking for help. It will walk you through the things you need to post and how...

batgirl (4/18/2013)

---

sugiarttampubolon (4/18/2013)

---

i am have a problem to get overtime hours

the table

EmployeeNo TimeIn TimeOut BreakHours WorkingHours

001 06:20 ...

Can you reproduce the error by setting up tables that look similar in structure and data type and recreate the issue?

I have a question, have you tried recreating the problem using a set of tables that resemble the tables used in the query (data types and column order) with a...

I can see the problem, you have an extra single before the cast and before the final + sign.

Look at what I had posted earlier.

Join it to the INFORMATION_SCHEMA.TABLES view by TABLE_NAME and filter TABLE_TYPE = 'BASE TABLE'.

Or add the following in the WHERE CLAUSE

exists(select 1 from INFORMATION_SCHEMA.TABLES t WHERE t.TABLE_NAME = c.TABLE_NAME and...

mike.hamilton721 (4/17/2013)

---

Thank you Lynn. I tried that new EXEC you listed (missing a ' ?), and I thought I added it in the right spot. But I'm not...

mike.hamilton721 (4/17/2013)

---

Alright. Played around (and Googled), and came up with this:

DBCC traceon (3604);

drop table #DBID

Create table #DBID (

Name nvarCHAR(256)NULL,

LogicalName nvarCHAR(256)NULL,

BindingID nvarCHAR(256)NULL)

declare @db varchar(256),

@dbid int,

@hidb int

select @hidb = MAX(dbid),

@dbid =...

Could just be me, but ith the title Row Constructor I knew immediately that we were talking about SQL Server 2008 and newer as this was a new feature in...