Topics
Started by
Posts
Last post
drop table #test go --===== Create a test table and populate it. CREATE TABLE #Test (Order…
5 replies
Hi All, How are you doing all? I have created 3 Views and each of one is BO, CT, and NH and add whe…
6 replies
I have a query that sometimes returns nothing...not a NULL value...but nothing. The query looks lik…
2 replies
By: Garadin
I have 3 columns in one table. Col1, Col2, Col3. The data in these columns has data, and some null …
1 replies
My table data is OrderNo SeqNo Type 1234 1 BL 1234 2 " 1234 …
30 replies
I need to extract data from a table where created data >=yday data <=2 in the morning. This i…
3 replies
I'm probably making this harder than it needs to be. I have a data set that looks like: ItemNo, Da…
1 replies
Hey all, I recently had this problem thrown at me to find the people three most recent activity re…
3 replies
This shouldn't be hard, but TRY/CATCH and RAISEERROR are just enough different from other programmi…
3 replies
Hello All, I'm looking for a way to write the data in a table to .CSV file using T-SQL. Is there an…
1 replies
hi frnds i want to know why does temporary tables in a stored procedure are recompiled more number …
1 replies
Hi all, I am trying to create text file or any out put file in certain directory straight from sql …
5 replies
I'm trying to create a trigger that retrieves the max value of a primary key column and updates max…
14 replies
Hello, [font="Courier New"] if object_id('tempdb..#tmp1') is not null drop table #tmp1 create tab…
2 replies
By: _simon_
Hi. I have a field on a report that displays a date value. The expression is as follows: =FORMAT(F…
2 replies
By: 2Tall
Viewing 15 topics - 7,696 through 7,710 (of 12,234 total)
You must be logged in to create new topics.