-- details of tables called [student]

-- or columns called [mark2] etc

-- in the 'current' db

SELECT TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME

FROM INFORMATION_SCHEMA.COLUMNS

WHERE COLUMN_NAME IN ('mark2', 'mark3', 'mark4', 'mark5', 'mark6')

OR...

Kumara1011 (4/22/2013)

---

If we take specific column in the count function, its fine.

But when i am using count(*), it showing difference.

i found that in background one command is executing i.e.,

DBCC...

Divya Agrawal (4/22/2013)

---

ChrisM@Work (4/22/2013)

---

Divya Agrawal (4/19/2013)

---

DECLARE @T TABLE (auditlogid int, userid int , auditlog varchar(max))

INSERT into @T

select 1,1,'ProgramCompletionStatus - ProgramNotCompleted, '

union all

select 1,1,'InputValidationStatus - Success, IsValidUserID - Yes,...

jcrawf02 (4/22/2013)

---

Brandie Tarvin (4/22/2013)

---

So this morning as I'm getting ready for work, I can't find earrings to match my shirt and I say "I need more jewelry."

The SO looks at...

Jeff Moden (4/22/2013)

---

BWAAAA-HAAA!!!!! I say the same thing everytime...

-- No

SELECT COUNT(*), SUM(Total)

FROM (

SELECT ID = 1, total = 10...

sravan.here (4/19/2013)

---

All the similar rows should go into one table. In my example, row 1 and 3 will be in table and 2 will be another table. but my metatable...

Divya Agrawal (4/19/2013)

---

DECLARE @T TABLE (auditlogid int, userid int , auditlog varchar(max))

INSERT into @T

select 1,1,'ProgramCompletionStatus - ProgramNotCompleted, '

union all

select 1,1,'InputValidationStatus - Success, IsValidUserID - Yes, IsValidProgramID -...

sravan.here (4/19/2013)

---

Yes there are tables with 4 or 5 or more columns as well as you doubted.

I have just provide a simple example here.

But the maximum column names (with csv)...

rodjkidd (4/19/2013)

---

wolfkillj (4/19/2013)

---

ChrisM@Work (4/19/2013)

---

Sean Lange (4/18/2013)

---

patrickmcginnis59 10839 (4/18/2013)

Time and again I've read in the news folks absolutely ruin their own lives over dumb forum stuff even when posting under what...

surendiran.balasubramanian (4/19/2013)

---

how to convert the below subquery into join ..

SELECT CtryId, WrkflwId, Dt

FROM stepHistory H

WHERE EXISTS

(SELECT * FROM

...

Luis Cazares (4/18/2013)

---

I wish I could help you, but I don't understand what you're trying to do.

Please take a look at the article linked in my signature to obtain better...

Sean Lange (4/18/2013)

---

patrickmcginnis59 10839 (4/18/2013)

Time and again I've read in the news folks absolutely ruin their own lives over dumb forum stuff even when posting under what they perceive as...

sravan.here (4/18/2013)

---

Hi,

Yes please see the Create table script for source table and the insert script as well

CREATE TABLE yt

([ID] int, [Name] varchar(14), [text] varchar(21))

;

INSERT INTO yt

([ID], [Name], [text])

VALUES

(1, 'SID,DOB', '123,12/01/1990'),

(2,...

Here's one way:

CREATE FUNCTION [dbo].[IF_Calendar]

(

@StartDate DATE,

@EndDate DATE,

@FirstWeekDay VARCHAR(10)

)

RETURNS TABLE WITH SCHEMABINDING AS

RETURN

(

-- inline tally table

WITH E1(N)...