Tagged questions

1000 results found

SQL Query buildersAugust 18, 2011

hi do you guys know of a good query builder designed for an end user in a sort of wizard like format where they choose various options such as i want these customers from this date etc etc without get

8

views

0

votes

2

answers

Deploying ClickOnce App with SQLExpress: Users don't have permission to install SQLExpressAugust 18, 2011

I am building an internal app that I want to deploy via clickonce. The app uses SQLExpress and it works fine if I install SQLExpress on the user's machine beforehand, however due to the security p

21

views

0

votes

2

answers

sql query derived column url contructionAugust 18, 2011

warning--sql skill level is beginner.  I am dealing with a web based application that contains reports that accept user input, after which, returns a result set.  It uses %1,%2,%3 as user in

22

views

0

votes

4

answers

Order SQL Query by Status IDAugust 18, 2011

I've got what I think is a very simple query - I'm just having a slow day! I have a database, with loads of articles in, and each article has a status - 'PUBLISHED', 'COMPLETE'

6

views

0

votes

13

answers

Accessing underlying dataset in Rendering Extension in SSRSAugust 18, 2011

I have written a custom rendering extension for my reporting services. In one of my function inside custom rendering assembly, I want to access the underlying dataset and manipulate with it. I gain so

8

views

0

votes

2

answers

Populate a listbox from a database using linq to sqlAugust 18, 2011

How do I convert this to c#? <asp:DropDownList ID="dpDistributor" runat="server" Height="22px" Width="153px"              

12

views

0

votes

1

answers

FirebirdSQL 2.1 and TimestampsAugust 18, 2011

Novice SQL writer, here.  Situation is trying to run weekly reports based on a timestamp in a table. I'm trying to dump a report on Friday night that extends back to Saturday.  I have Ja

13

views

0

votes

3

answers

What's Worng with this SQL StatementAugust 18, 2011

What's wrong with this statement? UPDATE [Record of Expenses] SET [Record of Expenses].[EffectiveStart] = (SELECT B.[ID] From PerDiem AS B WHERE Nz([Record of Expenses]/[TravelDate], Date()) BETWE

6

views

0

votes

5

answers

How to configure automatic logins on database-driven intranet only web siteAugust 18, 2011

I am modifying an intranet web site run on a Windows Server 2003 32-bit machine using IIS 6.0.  I am writing my code using Visual Studio 2005.  My pages are in Visual Basic.Net. I am using S

7

views

0

votes

6

answers

SQL Syntax VariableAugust 18, 2011

I am trying to setup an automated process in my scheduler and I need to know how I would create a variable for this below. Currently my backup script reads something like this: backup database db_name

1

views

0

votes

8

answers