SELECT *
FROM (SELECT ROW_NUMBER() OVER ( ORDER BY departureDate )
AS ROW,COUNT(*) OVER() as MaxNum, holidayId, airportCode,
departureDate, days, price, other, substring(hotel,0,20) AS hotel,
...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_22761250.html
I have a stored procedure which does insert to the table with new values.
What i need to do is to see if record exists then UPDATE else INSERT. But main thing I need help with is,
If record ...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23436858.html
Thanks....My question is I need to make a stored procedure for testing use. The pseudo-code is:
BEGIN
Open input file for reading
Create new output file REJECTE.txt in the delete folder
While...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2360...
I have a search form that I'm stuck on. Let me try to explain. Here's an example. Lets say we have a Clients table, States table, and a ClientsStatesCrossReference table. So in the ClientsState...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2373...
I have a sqlServer stored proc, that will do a bunch of stuff. I have to pass that SP a userID and Lname. I have a php web form that has a txtbox for the userID and the LName.
Could someone S...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/PHP_Databases/...
Hi all,
I need to pass two List<> objects from my .NET application to a MsSQL SP - one is List<Pair> (name and value are actually strings if that matters), and the second is List<Guid>. I'm usin...
http://www.experts-exchange.com/Programming/Languages/.NET/ASP.NET/Q_23179481.html
I need the data that is returned from the SQL 2000 box to have a reference field chopped up to some degre so i can do a group by.
SELECT IIf([ref] Like "*(oc:*",Left([ref],InStr([ref],"(oc:")-1)...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23706468.html
Hi, I have a table that has a sequential reference column and a quantity column, for example:
Ref Quantity
1 100
2 50
3 150
4 75
5 23
6 96
...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22764645.html
Hi All,
I am writing a SQL Server stored procedure. I would like to know how I can optimally find out the value in a datetime field is today.
Example:
select * from table where some_functi...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2325...
Hi.
My requirement is to be able to use MS Excel 2003 SP3 to retrieve multiple result set data from Microsoft SQL Server 7.
What I was looking for (and will probably have to roll my own) is a...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
