Topics
Started by
Posts
Last post
We have a table that stores building and unit numbers in an apartment building. What I need to do i…
6 replies
I have a stored procedure and with in the stored procedure I have multiple select statements. When…
7 replies
HI all, Can anyone see an advantage to having a smalldatetime field(no time stored e.g 00:00:00) an…
5 replies
hi guys, i have a query with cumulative total. for the Column in a table, i need a Cumulative Total…
5 replies
Hi, One of the tables in the database got locked. when a select statement is issused, it shows that…
5 replies
select trans_Date,'MD' as org, case when rate_cat = 'INTER'then sum(trans_amt)*0.1 when rate_sub_ca…
1 replies
i am writing this SSIS and I need to pass a value to a varibale. SELECT Top (1) CASE ENCT_HDR_BATCH…
2 replies
SELECT CASE WHEN h.cloned_wrksht_indcr IS NULL THEN AVG(ABS(CAST(dbo.fn_workdays(h.job_execution_dt…
4 replies
I have a an issue were i want to check if specific characters or strings exist in a string based on…
6 replies
I have a set of data that gives me month name and year in this format: FiscalMonth July, 2008 Augus…
2 replies
i want to get a value from another database table. the db name should pass as a variable. i try wit…
3 replies
I have the following query that is supposed to update a date-column in a table based on the lowest …
23 replies
Hi All, I am trying to do paging with T-SQL, and I managed to do it for a small table, retreiving p…
2 replies
Any idea what Latin1_General_CI_AS stands for? I mean what CI and AS stands for? I think the defaul…
3 replies
I have address data that contains City, ZipCode, and CityType. For any given distinct city and zipc…
4 replies
Viewing 15 topics - 8,926 through 8,940 (of 12,230 total)
You must be logged in to create new topics.