|
|
-
|
|
Hi,I have a BI solution that uses a "dataversion" as the primary key for all major tables. A dataversion is an integer that has the format yyyymmddxx, where xx is the number of dataversions for a given date.My "date" table has about 500 entries, where t...
|
|
-
|
|
I have on table in which i am taking id in following manner.11.51.11.5.11.1.11.1.21.1.41.1.31.1.3.1 and so on.Here i want to do sorting on basis of this column but length of this column is not fix,on i can say that i don't know whether it will contain 3...
|
|
-
|
|
Hi?My select, which I will make into a stored procedure.Produces the correct number or rows,in the result table the UseId field and the IsEstimate field and NoteCode field are empty, now I want to just return those rows???I tried using NULL in my condit...
|
|
-
|
|
hello? my Q is:
In a select I want to include conditions in my where clause, based upon the ColumnId parameter, so if "ColumnId = 1" then I want these condition in my filter "IsEstimate=0" and if "ColumnId = 2" then this condition "IsEstimate=1 and ...
|
|
-
|
|
hello?I'm very new to T-SQL, I work part time as a programmer.I have difficulty in adapting a stored proc to recieve a parameter from an exact replicant of itself.This is the initial stored proc : alter procedure mlmMeterUsageStats @Action int=0asbegin ...
|
|
-
|
|
Hi, Could you please let me know how to translate a geography to a corresponding latitude & longitude coordinates.Thanks in advance...............
|
|
-
|
|
Experts,
Is there a way to send an email notification from within the SSRS 2005 report and not from the data driven subscription.
There are some constraints that I cannot use Data Driven subscription. When a particular data condition is not met in the r...
|
|
-
|
|
I am migrating Programmable objects from Oracle to SQL Server.There is a need to get the Table Variable or User Define Table Type as Output parameter in Stored procedure (Not as REadonly).
...
|
|
-
|
|
Hi Nakul,
If we click on Take Offline option unexpectedly. SQL Server is not asking for any warning. Database is going to Offline directly.
I have db_owner permissions. Recently i click on this option, database gone offline unexpectedly. Can ...
|
|
-
|
|
2. So the Range is 19-22.Last record is 25. so the range is 25-25.Hope i explained clearly.Can any one give the solution for this. Its bit urgent.SELECT NUMBER INTO #TEMPFROM master..spt_values WHERE TYPE='P'AND number BETWEEN 1 AND 25AND number NOT IN ...
|
|