I wanted to share my findings here using a temp table and a WHILE clause. I separate a comma separated string of INT's to use in a IN statement.
I have this query :
SELECT
IP, count(*) as cnt
FROM
withdraw_update wu
JOIN
update_detail u ON wu.Update_ID = u.Update_ID
group by 1
having count(*) > 1 LIMIT 10 ;
It returns two columns :
IP | Cnt
I want the results of Cnt to be sorted(DESCENDING)
So i tried,
SELEC...
I am facing issues in creating stored procedure in SQL Server 2008.
want to execute a procedure using SSIS package.
The output that generates from this procedure will also a Script, so
want to execute that Script output too.
How can we use wildcard functionality in more than one columns in SQL Server 2008?
below is my query
SELECT *
FROM sheet1
WHERE description like '%abc%'
if I fire the given then i'm able retrieve data in description columns whichever are in abc but I'm not able to search same with other colum...
I just ran into a wall when implementing my DB design into my web application. I have tried reading several of the similar questions to mine, here on SO, but I'm just getting lost in it.
My goal is to have a full text search that retrieves matching movie titles and two main starring actors. The...
How can find a solution to fix a SP that when I run from php I get Error 102 severity 15 state 1
PHP:
$stmt = mssql_init('DBO.TEST_sp_SET_Claim Status');
mssql_bind($stmt, '@ClaimID', $claimID, SQLINT4);
mssql_bind($stmt, '@Status', $status, SQLINT4);
mssql_bind($stmt, '@UserID', $userID, SQLIN...
I tried to alter a table with a new table name. I successfully changed the name but the schema also changed from "dbo." to be "dbo.dbo.". When I tried selecting data from the new table, it shows in the Message box that the table is invalid so I can't do anything with the new table.
Does anyone ...
I have the following question i would appriciates your kind assistant to get the output mentioned below: I need to get new report that has the following data : 1- Passengers traveling together in the same Reservation number the column is(Reservation) so new column should contain all the passenger...
This may seem very silly, but I am trying to count the number of a certain animal per month. This is how my data is in the database:
Time | Animal
-----------------------------------
2013-01-01 00:01:00 | Pig
2013-01-02 00:02:00 | Turkey
2013-02-01 00:02:00 | Turkey
2013-02-0...
