Since I am able to bring in one record at a time, is it possible to create a sql user function to pull in multiple records for say, an SSRS report? Reply 4-18-14 Sri says: Enjoy.. We manage our SSRS folder permissions using AD and it would be a huge benefit to be able to query AD to get a list of who has permissions to folders and reports on our SSRS
The problem occurs only when i create a new case and cancel it, ie; i am not saving the case, but when i create a new case again, i get a new ref id instead of previous ref id. syam sundar.Kota Says: November 6th, 2006 at 2:07 am Hi, let me know how can get the sum of first and second sal ,second and third sal ,third and fourth sal and so on.
Fill in your details below or click an icon to log in: Email (required) (Address never made public) Name (required) Website You are commenting using your WordPress.com account
Newest Questions - Database Administrators Stack Exchange
mysql performance asked 1 hour ago George 1011 1 vote 2answers 25 views Get the nth distinct column value ordered by another column I want to get the row with the nth distinct value in a column, as ordered by another column. mysql phpmyadmin asked 1 hour ago Adriaan 11 0 votes 1answer 17 views How to configure SQL Server Port on multiple instances? I have a server called SQLDWDEV01, with 2 instances: default and UAT
any person entering teh gate after 8:45 is marked late and any person leaving before 4:10 is marked early out hence for each day that the person has left early or come late i have to show days in whole numbers as 1,2 ,3 etc for the above columns(early out and late in).. my weekly reports should contain the columns employeeid employee name no of days late no of days early out the start day and end dates are provided by the user at run time using a datepicker in vs2005
Thanks! Log In or Register to post comments Anonymous User (not verified) on Dec 19, 2004 how to retrive the current value in the database Log In or Register to post comments Bru CARLONI (not verified) on Feb 21, 2002 How can i convert a sql datetime into a date, using MSQUERY, for Excel 97? Log In or Register to post comments kenneth (not verified) on Apr 18, 2001 Hi there ! I am using SQL 6.5 , my problem is , I am passing two dates into a stored procedure
Because when you Open and Close a connection it stays in a kind of Sleep status where it waits to see if it will be reused, this process is probably thought to make it faster. The down side of this is if you have a total of 5 available connections to your SQL and you are using 1 and the 4 others are a Sleep your 6th connection attempt will take forever untill one of the Sleep is Disposed by SQL, you end up with a slow application even if all you code is top notch
oracle - SQL - How to select a row having a column with max value - Stack Overflow
fast HDD in a server environment Why does the power output peak and then drop as engine speed increases? You are a minor character in a fictional story. Now if the date spans for 10 days, I need to make this query for each of the 10 days resulting in 10 rows, with each having a max value of that particular day
How to Select a substring in Oracle SQL up to a specific character? - Stack Overflow
For example: ABC DEFGH IJKLMNOP The SUBSTRING function doesn't seem to be up to the task because it is position-based and the position of the underscore varies
No comments:
Post a Comment