Database

31-May-11 2:15

i have an interesting question for you guys.

SELECT   S.SCHOOLID AS [SCHOOLID],S.SCHOOLNAME AS [SCHOOLNAME],SP.PHOTO AS [PHOTO]
FROM SCHOOLPHOTO SP
INNER JOIN SCHOOL S
ON SP.SCHOOLID = SP.SCHOOLID
WHERE S.SCHOOLID  IN (SELECT SCHOOLID FROM #SCHOOLS)

the Photo Field is an Image Datatype Field, i now you can use them in a Distinct or group by , How can i go by have that field there without casting it , because if i cast it it will not work together in Silverlight or any other image control.

Thanks

Vuyiswa Maseko,

Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code.

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

Hash code

David Mujica31-May-11 2:48

David Mujica

31-May-11 2:48

How about generating a hash code for your image and store that value in your table along with the image. You could then use the hash code in your group by clause.

check this article out ...
http://www.vcskicks.com/image-hash.php[^]

It was the first thing that popped up in my Google search.

Good luck.
Thumbs Up | :thumbsup:

Vimalsoft(Pty) Ltd31-May-11 3:51

31-May-11 3:51

I need a Solution in T-SQL

Pete O'Hanlon31-May-11 4:10

Pete O'Hanlon

31-May-11 4:10

What version of SQL Server are you using? If it's sufficiently advanced, you could apply this as a CLR Trigger.

Forgive your enemies - it messes with their heads

My blog | My articles | MoXAML PowerToys | Mole 2010 - debugging made easier - my favourite utility

Vimalsoft(Pty) Ltd31-May-11 4:35

31-May-11 4:35

I am SQL 2008

Pete O'Hanlon31-May-11 4:57

Pete O'Hanlon

31-May-11 4:57

Then it's job done. You can use a SQL CLR trigger and store the hash when the image is inserted or updated.

Forgive your enemies - it messes with their heads

My blog | My articles | MoXAML PowerToys | Mole 2010 - debugging made easier - my favourite utility

Vimalsoft(Pty) Ltd31-May-11 5:25

31-May-11 5:25

this did the Job

 ;with cteSchools as (SELECT DISTINCT S.SCHOOLID AS [SCHOOLID],S.SCHOOLNAME AS [SCHOOLNAME]
FROM SCHOOL S

WHERE S.SCHOOLID IN (SELECT SCHOOLID FROM #SCHOOLS))


SELECT S.SCHOOLID AS [SCHOOLID],S.SCHOOLNAME AS [SCHOOLNAME],SP.PHOTO AS [PHOTO]
FROM cteSCHOOLS S
CROSS APPLY (Select TOP (1) PHOTO from SchoolPhoto SP
WHERE SP.SCHOOLID = S.SCHOOLID
ORDER BY SCHOOLID DESC) SP

Thanks

BCP CLI Cannot find Invalid object name. [modified]

Shameel31-May-11 5:28

Shameel

31-May-11 5:28

Use the T-SQL function hashbytes like this:

select hashbytes('MD5', 'your value')

Groulien30-May-11 23:37

Groulien

30-May-11 23:37

I'm trying to export the results of a stored procedure to a csv, here's what I've got:
"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\bcp.exe" myDb.dbo.spExport out "Data.csv" -T -Slocalhost -t";" -c
It keeps telling me "Invalid object name 'myDb.dbo.spExport'."

Other stored procedures don't work either and none require parameters.
Pointing to a table works so I thought I was pointing to at the SP's the right way.
What am I doing wrong?

-Nevermind, got it working:
"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\bcp.exe" myDb.dbo.spExport queryout "Data.csv" -T -Slocalhost -t";" -c

modified on Tuesday, May 31, 2011 10:08 AM

Re: BCP CLI Cannot find Invalid object name.

Corporal Agarn31-May-11 4:31

Corporal Agarn

31-May-11 4:31

BCP is tricky at best.

MSSQL Backup database - without BACKUP command

David Hovey30-May-11 4:58

David Hovey

30-May-11 4:58

Hi all, I have a MSSQL database with Godaddy, and I have access using the SQL Server Managements Studio, and of course their Hosting center interface with a web browser.

I need a more robust backup setup. Currently I would have to manually initiate a backup.

-Is there a way to automate a backup using The Sql Server Management Studio? Perhaps from my client PC (COM, DLL)?

-I can't use the BACKUP command statement as the server is attempting to create the backup file on THEIR servers. The only information I'm using the database is table data. If using .NET along with the SQL database, are there any methods (that would be reasonably affective) to SELECT statement for each table in db. Then export this database to csv or other format.

Appreciate your help.

SilimSayo30-May-11 8:41

Re: MSSQL Backup database - without BACKUP command [modified]

30-May-11 8:41

How about creating the back on their servers and then ftping the backup files to your server/computer?

Shameel31-May-11 0:33

Shameel

31-May-11 0:33

IMO, the only place where you can backup the databases on a server is on the server itself. What you can do is to write a script to execute the BACKUP command and FTP the file from the server to your PC/Laptop.

modified on Tuesday, May 31, 2011 7:11 AM

SilimSayo31-May-11 3:49

31-May-11 3:49

If I may ask, how is your answer different from mine? Confused | :confused:

Shameel31-May-11 4:22

Shameel

31-May-11 4:22

I did not read your post.

SilimSayo31-May-11 7:24

31-May-11 7:24

No problem Smile | :)

Stored Procedure

berba29-May-11 23:09

berba

29-May-11 23:09

Hi,

Can anyone provide me with a link for tutorials on stored procedures?

Thanks

Cheers
Nikhil

Re: Stored Procedure

Luc Pattyn29-May-11 23:59

Luc Pattyn

29-May-11 23:59

Everyone can[^].

Smile | :)

Luc Pattyn [My Articles] Nil Volentibus Arduum

The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Please use <PRE> tags for code snippets, they improve readability.
CP Vanity has been updated to V2.3

Re: Stored Procedure

SilimSayo30-May-11 2:31