Topics
Started by
Posts
Last post
I HAVE GOT DATA AS DATE SOURCE TYPE COUNT 12/04 A IN 21 12/05 A OUT 29 …
5 replies
I have a logging table for SSIS packages that I want to examine for repeated failures. I have a col…
3 replies
We have a table like this ID Val 1 Data item 1 2 Data item 2 3 Data item 3 4 Data item 4 5 Dat…
19 replies
Hi, I am looking for a more elegant way to filter numbers out of names. This works but costs a lot:…
6 replies
Hi All, I searched the query to get all days of a month. DECLARE @FirstDay smalldatetime, @NumberOf…
2 replies
Hello Expert, I have created this scripts below SELECT COUNT(DEClearedDate) AS DECleared, COUN…
10 replies
SELECT od.OrderDetailID , Dbo.TruncToDay(OD.shippingdate) as ShippingDate , o.OrderID , Dbo.TruncTo…
1 replies
In a T_SQL Block i wantto define a nvarchar(max) variable for reciceving data with ntext type. let …
3 replies
Hello, all: I'm trying to clean up a dataset that's a complete mess to make it semi-usable, and I w…
5 replies
Is it considered good practice to end your T-SQL statements with a semicolon? SELECT * FROM Practic…
5 replies
I posted this in the noob forum too but I figured you might have better answers in here. Trying to…
2 replies
*** i have a 400000 lacs data. i want to this data separeted to 40 tables. per table have 100000 da…
6 replies
Hi, How can we convert the System local date to UTC date. Is there any function to convert the date…
9 replies
I have DB that lists products and the categories in which they belong. This is done via a products …
11 replies
hello, what is the command for get last 10 records in datatable.. regards: Giri.D Thanks …
13 replies
Viewing 15 topics - 8,071 through 8,085 (of 12,230 total)
You must be logged in to create new topics.