Topics
Started by
Posts
Last post
Please I need help I have the following tables assessment (assessmentid,sectionid,assessmentitle,ma…
1 replies
performance wise which is better subquery or scalar function
5 replies
I have a column called update_source in my table that I want to pivot on. I want to make sure that…
5 replies
Hi all, I am new to tsql .i need to write trigger based on source table and rules. My source table…
5 replies
Hi, I have a table like, Invoice No Vendor 1 vendor 1 2 …
4 replies
I am using temporay tables instead of table variables and cte in stored procedure would this be ok…
3 replies
Hi, need help with understanding the mechanisms involved in these 2 queries which accomplish the sa…
5 replies
I need to capture two statistics: 1) The total count of legal Case_IDs that take <30, 30-60, and…
59 replies
DECLARE @Table TABLE( [ID] int, [CostA] real, [CostB] real, [CostC] real ) INSERT INTO @Table E…
32 replies
hi this is just question to know. in my cursor i am giving condition like(@maxdate =null) it was no…
25 replies
Is their a slick way that I can check the condition of a field and return multiple discrete fields …
8 replies
HI I want to script a table with data using query wise. if its having any possible to script the…
7 replies
Two part problem: (1) For validation purposes need to compare returned int values of result set wit…
14 replies
Below is an example of a script I have, which works fine. However, I would now like to multiply the…
10 replies
Hi all, I have a table with this structure : CREATE TABLE dbo.tblStuffPriceHistory ( sphI…
1 replies
Viewing 15 topics - 6,091 through 6,105 (of 10,647 total)
You must be logged in to create new topics.