Topics
Started by
Posts
Last post
So I have two tables with similar structures CREATE TABLE [dbo].[ABC]( [COLL] [char](6) NOT NULL, …
2 replies
I have data like this in one column and want to get the data by hour for 24 hours. how can i get it…
4 replies
Hi all. I have a stored proc which currently return the top 4 rows from a view. What im looking to …
12 replies
I'm trying to pass values within an insert statement, however, I'm not sure what is the best way to…
1 replies
Hello, I am querying a table and can get the required results all ok, however all of the date field…
2 replies
It seems the more I get into SQL the more it appears I am also getting into Programming! Being "old…
8 replies
Hi folks Here's the UDF: CREATE FUNCTION [dbo].[GET_EMA_Multiplier](@Period INT) RETURNS FLOAT AS B…
4 replies
Hello, I am querying a table and can get the required results all ok, however all of the date field…
1 replies
Hi Can someone give me a hint if it's, in any way, possible to call up a vbscript without using xp_…
2 replies
How can I create a fixed length file using SSMS? I assume .. i have to select 'result to file' and …
4 replies
Hi all: Given: ‘111111-0000-9999’ Return: SeqResult 1111111 20000 39999 Do we have a function …
9 replies
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
I have 3 columns in one table. Col1, Col2, Col3. The data in these columns has data, and some null …
1 replies
Viewing 15 topics - 7,681 through 7,695 (of 12,230 total)
You must be logged in to create new topics.