pee2002

Hi there! I´m with some difficult to do this query. I have this: [CODE]SELECT IDReport AS [ID Report], IDHardware AS [ID Hardware], DataHoraReport AS [Último Report], Versao AS Versão, DataInstalacao AS Instalação, DataUltimaActualizacao AS [Última Actualização] FROM Report[/CODE] in which result this: [URL="http://img189.imageshack.us/img189/6872/26352213.png"]http://img189.imageshack.us/img189/6872/26352213.png[/URL] How can i query those results to …

Hi! I´m communicating via webservices with the Server (where's installed the database) and the c# application. So, **i dont have direct access with the database** Somehow, i receive a DataSet with 3 tables inside: [url]http://img339.imageshack.us/img339/5171/90768184.png[/url] And would like to populate 3 combobox like this: [url]http://img97.imageshack.us/img97/6145/29315365.png[/url] Which (as you already see) …

Hi there! I was force to change my old menus (Manual input in Master Page) to Sitemap Menus using Menu control with Sitemap DataSource. I have this: [URL="http://img12.imageshack.us/img12/8975/beforejg.jpg"]http://img12.imageshack.us/img12/8975/beforejg.jpg[/URL] Made by this code: [CODE] <ul class="sidemenu"> <asp:Menu ID="Menu1" runat="server" DataSourceID="SiteMapDataSource1" StaticDisplayLevels="2" Font-Size="Smaller" ItemWrap="False"></asp:Menu> <asp:SiteMapDataSource ID="SiteMapDataSource1" runat="server" /> </ul>[/CODE] and want this: …

Hi there folks! I´m pretty blind regarding Callback Url. I only know that someone will dump in information that i want to see. Thats it. I have this to fill out: [URL="http://img18.imageshack.us/img18/1912/clickatell.jpg"]http://img18.imageshack.us/img18/1912/clickatell.jpg[/URL] And this has an explanation: (Full Version PDF [URL="http://www.clickatell.com/downloads/http/Clickatell_HTTP.pdf"]here[/URL]) [URL="http://img29.imageshack.us/img29/5005/manuald.jpg"]http://img29.imageshack.us/img29/5005/manuald.jpg[/URL] I think the XML GET callback URl is …

Hi there! I made a backup of my database (MandoTECA) using the following code: [code]CREATE PROCEDURE [dbo].[CreateBackup] @uri nvarchar(MAX) AS BACKUP DATABASE MandoTECA --TO DISK = 'C:\Users\Pedro\Desktop\MandoTECA.Bak' TO DISK = @uri WITH FORMAT, MEDIANAME = 'Z_SQLServerBackups', NAME = 'Backup Completo da MandoTECA'; [/code] And used it a restore procedure to …

Hi there! I have the following SELECT Statment: [code]SELECT IDLivro,Titulo ,LEFT(Nome, LEN(Nome) - 2) AS Nome ,LEFT(Categoria, LEN(Categoria) - 2) AS Categoria ,Posicao ,Classificacao ,Comentario FROM ( SELECT L.Titulo ,( SELECT A.Nome + ' ; ' AS "text()" FROM dbo.Autor A JOIN dbo.LivroAutor LA ON A.IDAutor = LA.IDAutor WHERE LA.IDLivro …

Hi there! In my Library project i want to replace some text with images. I have this: [img]http://img33.imageshack.us/img33/8425/antesx.jpg[/img] Wich is generated by the following code: [code]SELECT IDLivro,Titulo ,LEFT(Nome, LEN(Nome) - 2) AS Nome ,LEFT(Categoria, LEN(Categoria) - 2) AS Categoria ,Posicao ,Classificacao ,Comentario FROM ( SELECT L.Titulo ,( SELECT A.Nome + …

ER Model: [url]http://img22.imageshack.us/img22/7292/modeloer.jpg[/url] I´ve got this: [IMG]http://img31.imageshack.us/img31/2384/antesj.jpg[/IMG] And want this: [IMG]http://img12.imageshack.us/img12/5241/depoispkd.jpg[/IMG] (Paint image.. lol) Anyone knows how to build a stored procedure who does that or a view? Thanks!