Viewing 15 posts - 1,231 through 1,245 (of 5,504 total)
WayneS (7/15/2011)
Lynn Pettis (7/15/2011)
Chad Crawford (7/15/2011)
Craig Farrell (7/14/2011)
July 17, 2011 at 2:40 am
kish1234 (7/16/2011)
Thanks for your reply.
What happens, if I want to make my select statement dynamic.
My actual request from client is to get all the incidents that are raised as...
July 17, 2011 at 2:38 am
You could use
/(NULLIF(sil.[Quantity],0))
This would cause a divide by NULL which will return NULL.
July 16, 2011 at 4:59 pm
Because there was no match?
We can't see what you see nor do we have the data available you're testing against.
But most probably it is cause by the non-unicode data type...
July 16, 2011 at 2:52 pm
If you want to run it permanently on your prod server I recommend to go to the next level: server side trace.
But what I meant originally was to set up...
July 16, 2011 at 7:49 am
saurav.rukd (7/16/2011)
i solved it..Thaks
Great. Care to share what you did to solve it so others may benefit?
July 16, 2011 at 7:27 am
unfortunately, the data are not ready to use.
Please have a look at the first link in my signature on how to post sample data.
July 16, 2011 at 7:15 am
Here's a link that might help you to get started using SQL Profiler:
July 16, 2011 at 6:17 am
So, if you select the data using Management Studio, the data are there but when you try to query it via the app, the data cannot be displayed? Weird, indeed.
You...
July 16, 2011 at 5:45 am
http://www.simple-talk.com/sql/learn-sql-server/service-broker-foundations-workbench/
http://www.sqlservercentral.com/articles/Development/anintroductiontotheservicebroker/1957/
Easier than using google, isn't it? 😉
July 16, 2011 at 5:03 am
Does the table have a IDENTITY column? If so, are the values stored in that column for the period in question consecutive? If so, the data (most probably) were never...
July 16, 2011 at 4:59 am
You could also replace UNION with UNION ALL since due to the different values for s.objecttype in each UNION statement there isn't any need to check for duplicates.
July 16, 2011 at 4:50 am
There were more than 40 people so far looking at the issue you posted.
Even though you did a fine job to present table definitions, some of us refuse to open...
July 16, 2011 at 3:00 am
Would something like the following help you to get started?
DECLARE @tbl TABLE
(
PNO CHAR(3),Injury INT,Theft INT, Selfharm INT
)
INSERT INTO @tbl
SELECT 'ABC', 1, 1, 0 UNION ALL
SELECT 'XYZ', 1, 0, 0...
July 16, 2011 at 2:56 am
The most important thing is to find the pattern.
It certainly would help to get a longer list of values where the rows to find are already identified including a short...
July 16, 2011 at 2:48 am
Viewing 15 posts - 1,231 through 1,245 (of 5,504 total)